Answered

Power Apps Choices() Function Does Not Return Users from SharePoint Person Column

(0) Share

Report

Posted on by CU14071637-1

I have a SharePoint list that is open to all users.

In this list, there is a Person column.

On the SharePoint side, I can select any user I want in this Person column without any issues.

However, when I create a form in Power Apps, the Person DataCard appears correctly, but when I click the ComboBox inside it, no users are displayed.

I’m using the following formula: Choices([@'App Users'].Person)

I have used this code in many other tenants without any problems.

This is the first time I am experiencing this issue.

If I retrieve users with: Office365Users.MyProfile().DisplayName

it works fine — which means I have access to users.

However, the Choices() formula does not return any users.

What could be the reason for this?

Thank you in advance for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Sam_Fawzi 879 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hey @CU14071637-1,

Just make sure that the ComboBox Fields are assigned Property

Set the Fields property (this controls what shows in the dropdown):

Click on the ComboBox → go to the "Fields" section (right-hand pane), and make sure it's configured like this:

Primary text: DisplayName

Search field: DisplayName (or optionally Mail if searching by email)

Set the Items property of your ComboBox to:
Office365Users.SearchUser({SearchTerm: ComboBox_Search.SearchText})
(Replace ComboBox_Search with the actual name of the ComboBox if different)

Was this reply helpful? Yes No
CU14071637-1 4 on at

Like (0)

Report
Copy link

Link copied!

When I click on the ComboBox, no user suggestions appear.However, if I start typing a user's name, the results show up.

There is no issue with the DisplayFields property — I am using parameters like Picture, DisplayName, etc., as I normally do.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU14071637-1,

Firstly @Sam_Fawzi is on the right track and the posted code will work. The reason you are seeing nothing is that Choices([@'App Users'].Person) will only return values currently in the Person field in 'App Users', not the entire user list from your organisation.

There are a couple of other things you might want to add and two essential things that you will need to do as the schema from that connector is different to that of a Person/Group field. Firstly for the Items you might want to display the whole list before the users choose and also expand the selected number.

Office365Users.SearchUserV2( { searchTerm: Self.SearchText, isSearchTermRequired: false, top: 999 } ).value

More importantly however, both the DefaultSelectedItems of the Combo Box and the Update of the Data Card need to change. Assuming here that both the Combo Box and field are single selection, the DefaultSelectedItems should be: -
{ Mail: ThisItem.Person.Email DisplayName: ThisItem.Person.DisplayName }

Now the Update of the Data Card
{ Claims: "i:0#.f|membership|" & Lower(ComboxBoxName.Selected.Mail), Department: "", DisplayName: ComboxBoxName.Selected.DisplayName, Email: ComboxBoxName.Selected.Mail, JobTitle: "", Picture: "" }

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CU14071637-1,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No