top of page
Search

Let's Fix the Form Control Issue in Modern Power Apps: People Picker Not Loading All Users?

Updated: May 9

ree


Problem Statement

Using modern drop down control as people picker displays only 4-5 initial records, search is sluggish and do not work.


 Drop Down on Modern Form control
Drop Down on Modern Form control


Solution

  • Add a new data connections for O365 Users in your Power App


    Office365Users Connection
    Office365Users Connection

  • Insert modern form control on your power apps and connect to your SharePoint list.

    Modern Form
    Modern Form

  • Unlock your datacard for person field and update Items property of your drop down control.


    Unlock Data Card on form control
    Unlock Data Card on form control

  • Include following code to get items directly from O365 Users connector.


Filter(
    Office365Users.SearchUserV2(
        {
            searchTerm: Self.SearchText,
            isSearchTermRequired: false,
            top: 20
        }
    ).value,
    And(AccountEnabled = true,
    Not("#EXT#" in UserPrincipalName))
)

Items Property of Drop Down
Items Property of Drop Down

  • Update default selected items of the drop down to preselect the item from record.


Office365Users.SearchUserV2(
        {
            searchTerm: ThisItem.'Person Responsible'.Email,
            isSearchTermRequired: false,
            top: 1
        }
    ).value

  • In the properties of Drop Down control, Update behavior to Delayed output. This will enhance the search experience and trigger after you entered few characters.


    ree

  • On the datacard,  include following code in the Update property (replace with the correct control name e.g. DataCardValue15 in the image).


{
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    Claims: Concatenate("i:0#.f|membership|",DataCardValue.Selected.Mail),
    Department: "",
    DisplayName: DataCardValue.Selected.DisplayName,
    Email: DataCardValue.Selected.Mail,
    JobTitle: "",
    Picture: ""
}

Update property for DataCard
Update property for DataCard

This should make your people picker drop down control work for you and also the search will be a better experience for users.


People Picker drop down working with search
People Picker drop down working with search

 
 
 

Comments


© 2025 by SPXPERT Solutions Pune, India

bottom of page