Others

How to Display a People Picker Name in a Text Field in Power Apps

Khadija KhanKhadija Khan Nov 2, 2026 869 views

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.

How to Display a People Picker Name in a Text Field in Power Apps
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target text field

Open your Power Apps canvas and click on the Text Input control where you want the manager's name to appear.

2
Access the Default property

In the properties dropdown at the top left of the formula bar, select the 'Default' property of your Text Input control.

3
Enter the LookUp formula

Type the formula: LookUp(YourSharePointList, Country = DropdownCountry.Selected.Value, Manager).DisplayName (replace 'YourSharePointList', 'Country', and 'DropdownCountry' with your actual control and column names).

4
Test the application

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.

Extract the Display Name Using the LookUp Function
Handling Empty Results: If you want to prevent the field from showing an error when no country is selected, wrap your formula in the Coalesce() or IfBlank() function.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and click the free download button.
  2. 2. Install WPS Office: Run the downloaded installer and follow the on-screen prompts to set up the suite on your device.
  3. 3. Manage your files: Open your existing Office documents directly in WPS Office to experience full format compatibility and powerful editing features.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation with fast loading times and smooth performance.Free access to essential office tools for everyday data tracking and document creation.Familiar user interface reduces the learning curve for new users.
microsoft office alternative - wps office

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.