Let's Fix the Form Control Issue in Modern Power Apps: People Picker Not Loading All Users?
- Sudhir Kesharwani [spxpert solutions]
- May 2
- 1 min read
Updated: May 9

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

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

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

Modern Form Unlock your datacard for person field and update Items property of your drop down 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))
)

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.

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: ""
}

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




Comments