This sample shows how to fix the issue where a Power Apps ComboBox connected to a SharePoint "Person" column does not display all users.

By default, SharePoint person columns are limited in search results and may exclude users who haven't accessed the site yet. This solution uses the Office365Users connector to properly search and select any user in your organization, and ensures the selected value is correctly saved back to SharePoint.

🧪 Instructions

1. Connect the Office365Users connector to your app.
2. Replace the ComboBox in your person field with the following configuration:

// Items property of the ComboBox
Office365Users.SearchUser({SearchTerm: ComboBox1.SearchText})

// DisplayFields
["DisplayName"]

// SearchFields
["DisplayName"]

// IsSearchable
true

3. Update the Update property of the corresponding data card in the form with:

// Update property of the DataCardValue (the ComboBox)
{
  '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
  Claims: "i:0#.f|membership|" & ComboBox1.Selected.Mail,
  DisplayName: ComboBox1.Selected.DisplayName,
  Email: ComboBox1.Selected.Mail
}

4. Test the form and publish.

⚠️ Notes

• If a user has never accessed the SharePoint site, they may not appear in the default people picker.
• This workaround solves that by querying Azure AD directly.
• Make sure all users have Microsoft 365 accounts and appropriate access.