How to Display SharePoint Person Column in Power Apps Dropdown?

One of my clients wanted to know if it was possible to show the names of the individuals in a SharePoint Group column and the SharePoint Person column in a Power Apps Dropdown control. However, I researched many articles and found straightforward solutions.

We usually display the SharePoint person column in a Power Apps Combo box control. However, we can also show the SharePoint people picker value in a dropdown control.

In this Power Apps article, I will explain how to display SharePoint Person Column in Power Apps Dropdown Control and how to display Power Apps Dropdown items from a SharePoint group column.

Display SharePoint Person Column in Power Apps Dropdown

Let me explain how to display the SharePoint person column values in a Power Apps dropdown.

Example:

I have a SharePoint list [Product Issue Tracker], which has different columns like:

Below is a Power Apps dropdown control that contains all the SharePoint Person field display names.

Refer to the instructions below:

• Insert a Dropdown control and set its Items property as:

Distinct(
    'Product Issue Tracker',
    'Issue Assigned To'.DisplayName
)

Where,

• Product Issue Tracker = SharePoint List Name
• Issue Assigned To = SharePoint list person column

• Save, Publish, and Preview the app. Once you expand the dropdown menu, all the SharePoint person display names will appear, as shown below.

This way, we can display the SharePoint person column names in a Power Apps dropdown control.

Display SharePoint Person Group Users in a Power Apps Dropdown

Now let me explain how to show SharePoint Person group user names in a Power Apps Dropdown control.

Example:

I have a SharePoint list [Order Booking Details] with a person or group type column [Order Handled by]. In this column, we can only choose users from a particular SharePoint group.

I want to retrieve and display all the SharePoint group user names in a Power Apps Dropdown control.

Let’s see how to achieve this:

• On the Power Apps, insert a Dropdown control -> Set its Items property as:

Distinct(
    'Order Booking Details',
    'Order Handled By'.DisplayName
)

Where,

1. Order Booking Details = SharePoint list name
2. Order Handled By = SharePoint list person column name

• Once you save and preview the app, we see that the dropdown only has users from a particular SharePoint group.

Moreover, you may like some more Power Apps articles:

• Power Apps Dropdown Control with SharePoint
• Convert Text box to Dropdown in Power Apps
• Filter Power Apps Dropdown Control
• Power Apps Dropdown Values Not Showing
• Set Default Value in Power Apps Dropdown Control from SharePoint list

I hope this article helped you to know how to retrieve and display the SharePoint Person column values in a Power Apps Dropdown control.

Also, we saw how to display Power Apps Dropdown items from a SharePoint group column with various examples.

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.