How to Display a People Picker Name in a Text Field in Power Apps
Question details
The user needs to auto-populate a text input field with a manager's display name retrieved from a SharePoint People column, based on a specific country selection in a Power Apps form.

- Product
- Microsoft Power Apps
- Device & OS
- not provided
- Scenario
- Building a custom Power Apps form where selecting a country dynamically fetches and displays the corresponding regional manager's name from a SharePoint list.
- Observed behavior
- The user wants to extract the string text of the display name from the complex object returned by the SharePoint People Picker column and show it in a standard text field.
Ensure you have the correct SharePoint list connected as a data source in your Power App. Verify the exact internal column names for your Country and Manager (People) fields before writing the formula.
Extract the Display Name Using the LookUp Function
Use the LookUp formula to find the correct record based on the selected country, and append '.DisplayName' to extract the text string from the People Picker object.
A SharePoint People column returns a complex record containing multiple properties like Email, Claims, and DisplayName, rather than a simple text string. To display this in a text field, you must specifically reference the DisplayName property.
Open your Power Apps canvas and click on the Text Input control where you want the manager's name to appear.
In the properties dropdown at the top left of the formula bar, select the 'Default' property of your Text Input control.
Type the formula: LookUp(YourSharePointList, Country = DropdownCountry.Selected.Value, Manager).DisplayName (replace 'YourSharePointList', 'Country', and 'DropdownCountry' with your actual control and column names).
Hold the Alt key or click the Play button to preview the app. Change the country dropdown to verify that the manager's name dynamically populates in the text field.

Consult the Microsoft Power Apps Community
For highly complex data structures, delegation warnings, or multi-select People columns, seeking specialized help from the official community is recommended.
Boost Your Productivity with WPS Office
While Power Apps requires a Microsoft 365 ecosystem for advanced data integration, WPS Office provides a free, lightweight, and highly compatible suite for your daily document, spreadsheet, and presentation needs. Enjoy a familiar interface and seamless transition for all your desktop productivity tasks.
- 1. Download the software: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded installer and follow the on-screen prompts to set up the suite on your device.
- 3. Manage your files: Open your existing Office documents directly in WPS Office to experience full format compatibility and powerful editing features.

Frequently Asked Questions
Why is my Power Apps text field showing an error when referencing a People Picker column?
A People Picker column returns a complex record (an object) rather than a simple text string. A Text Input field expects a text value. You must append '.DisplayName', '.Email', or '.JobTitle' to your formula to extract the specific text string from that record.
Can I display multiple names if my SharePoint People column allows multiple selections?
Yes, but you cannot use a simple '.DisplayName' reference. Because a multi-select column returns a table of records, you need to use the Concat() function. For example: Concat(LookUp(YourList, Condition).Manager, DisplayName, ", ") will display all selected names separated by commas.
Why am I getting a delegation warning with my LookUp formula?
Delegation warnings occur when Power Apps cannot process complex queries on the server side, meaning it will only search the first 500-2000 records of your SharePoint list. Ensure the column you are filtering by (e.g., your Country column) is indexed in SharePoint and supports delegation for the operator you are using.




