How to Display SharePoint Person Column in Power Apps Dropdown?

Are you interested in how to bind dropdown items from the SharePoint list person column? No problem!

This Power Apps tutorial explains how to display the SharePoint Person Column in the Power Apps Dropdown with examples.

Also, I will show you how to display Power Apps dropdown items from the Power Apps SharePoint list group column.

Moreover, we will see how to work with bind Power Apps dropdown items from Office 365 groups.

How to Display SharePoint Person Column in Power Apps Dropdown

Here, we will see how to display the SharePoint Person Column in Power Apps Dropdown Control.

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

Column Name	Data Type
Issue ID	Title
Issue Type	Choice [“Laptop”, “IT Issues”, “HeadPhone”]
Issue Assigned To	Person/group
Is Still Issue Is Active	Yes/no

• In Power Apps, there is a Dropdown control. The dropdown control contains all the values from a SharePoint list Person column.

Let’s see how to achieve it, follow the below steps:

• Create a Power Apps blank canvas app -> Connect the SharePoint list to the app. Once you connect, it will look like the screenshot below:

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

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

Where,

1. Product Issue Tracker = SharePoint List Name
2. Issue Assigned To = SharePoint list person column

• Save, Publish, and Preview the app; the dropdown has a SharePoint list of person column users.

This is how I bound dropdown items from the Power Apps SharePoint list person column.

Display Dropdown items from Power Apps SharePoint list group column

This section will show you how to display dropdown items from the Power Apps SharePoint list group column.

Example,

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

1. In Power Apps, there is a Dropdown control. The dropdown control contains all the values from the above SharePoint list group column.

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 can see the dropdown has users from a particular SharePoint group only.

We can display Power Apps dropdown items from the SharePoint list group column.

Bind Power Apps Dropdown Items from Office 365 groups

Here, I will explain how to bind Power Apps dropdown items from Office 365 groups.

Example,

In Power Apps, a Dropdown control contains all the values from the Office 365 groups.

Let’s see how to achieve this:

• On the Power Apps screen, insert a dropdown control ->Set its Items property to:

Office365Groups.ListOwnedGroupsV3().value

NOTE:

For this, we must first connect the Office365Groups connector to the app. Otherwise, you may face some error.

• Once you save and preview the app, you can see the dropdown has the values of Office 365 groups, as shown below:

We can display Power Apps dropdown items from Office 365 groups.

Conclusion

This tutorial taught us about the Power Apps dropdown items from the SharePoint list person column.

Mainly, I have shown you how to display Power Apps dropdown items from the Power Apps SharePoint list group column.

Lastly, I have covered how to bind dropdown items from Power Apps Office 365 groups.

Furthermore, you may like some more Power Apps tutorials:

• Power Apps Dropdown Values Not Showing [How to Overcome]
• Bind SharePoint Lookup Column in Power Apps Dropdown
• Display Column Names in Power Apps Dropdown
• Bind Power Apps Dropdown Items From Collection
• Power Apps Error: Expected Record Value