Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

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

(2) ShareShare
ReportReport
Posted on by 1
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!

  • WarrenBelz Profile Picture
    WarrenBelz 145,422 on at
    Issue: Limited Users Displayed in "Person or Group" Field in Canvas App (SharePoint Data Source)
    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    Buy me a coffee
  • WarrenBelz Profile Picture
    WarrenBelz 145,422 on at
    Issue: Limited Users Displayed in "Person or Group" Field in Canvas App (SharePoint Data Source)
    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
     
     
  • SaiRT14 Profile Picture
    SaiRT14 1,926 on at
    Issue: Limited Users Displayed in "Person or Group" Field in Canvas App (SharePoint Data Source)
     
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard