Unanswered

Issue: Limited Users Displayed in "Person or Group" Field in Canvas App (SharePoint Data Source)

(2) Share

Report

Posted on by SR-01100727-0

Hi,

I am using a Canvas App that includes a form with a field named "Audit Owner." This field is of the data type Person or Group and is connected to a SharePoint list as its data source.

In SharePoint, all users within the organization are displayed correctly in this field. However, in the Canvas App, only a limited number of users are visible in the dropdown, instead of the full list.

What could be causing this discrepancy, and how can I ensure that all users from the organization are displayed in the Canvas App's "Person or Group" field?

Thank you in advance for your assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi SR-01100727-0,

pls try the following:

Increase Delegation Limits in Power Apps: Go to File > Settings > Advanced Settings in the Power Apps Studio. Increase the data row limit for non-delegable queries (default is 500, increase it to a higher value like 2000). Ensure the formula in the Items property of the dropdown supports delegation.

Use the Office365Users connector to fetch all users from Azure AD. Set the Items property of the dropdown to: Office365Users.SearchUser({searchTerm: ""})

thanks

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

Like (0)

Report
Copy link

Link copied!
Hi @SR-01100727-0

Firstly what is the Items of your Combo Box ? If it is
Choices(ListName.PersonFieldName)

then it will only display the users currently in your data set.

If this is the case, then try this
Office365Users.SearchUserV2({searchTerm:Self.SearchText,top:999}).value

which together with the search should get the required users. If you are not already using this function, your DefaultSelectedItems and Data Card Update will need some modification as well, but firstly, is this what you need ?

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 Buy me a coffee

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

Like (0)

Report
Copy link

Link copied!

@SR-01100727-0

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