Save Multiple Users From a Power Apps Combo Box to a SharePoint Person Field

Yesterday, I was working on a Power Apps form that included a multi-select Combo Box for choosing users. However, whenever I selected multiple names and attempted to save them to a SharePoint Person field, the values were not saved, and the field remained blank.

After checking and doing some research, I realized the issue was with the Update property of the Combo Box data card. Once I added the correct formula, the multi-select users started saving properly in the SharePoint list.

In this Power Apps tutorial, I will explain how to save multiple users from a Power Apps Combo box to a SharePoint Person field with a simple example.

Save Multiple Users From a Power Apps Combo Box to a SharePoint Person Field

Requirement:

There is a Power Apps form that contains all the fields from a SharePoint list named “Site Requests.” Whenever a user fills in the form details and saves them to the SharePoint list, a specific SharePoint site will be created, as selected by the user.

These are the various SharePoint fields below:

Column	Data type
Site Title	Single line text
Site URL	Single line text
Description	Multiline text
Site Type	Choice [Communication Site, Team Site (No Group), Team Site (M365 Group + Teams)]
Owners	Person [Enable Allow multiple selection]
Members	Person [Enable Allow multiple selection]

The screenshot below represents a Power Apps form (with a Button) that contains all the fields from the above SharePoint list. You can see here that both Owners and Members are Combo box controls, and they contain all the Office 365 users.

Owner Combobox Items property: Office365Users.SearchUser({searchTerm: DataCardValue9.SearchText})

Member Combobox Items property: Office365Users.SearchUser({searchTerm: DataCardValue10.SearchText})

However, when I selected multiple users and submitted the form, the Owners and Members were not being saved in the SharePoint list as shown below:

Then I researched and found that it won’t work unless I provide the code in the Combobox Datacard Update property. By default, it has the code below, but we need to change it if it’s a multiselected combo box.

DataCardValue9.SelectedItems

Remove the default code from the Update property and apply the formula below:

ForAll(
    DataCardValue9.SelectedItems,
    {
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
        Claims: "i:0#.f|membership|" & Mail,
        DisplayName: DisplayName,
        Email: Mail
    }
)

Where,

DataCardValue9 = Owners Combobox name

Similarly, for the Members Combo box, you can write the formula below on its Update property:

ForAll(
    DataCardValue10.SelectedItems,
    {
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
        Claims: "i:0#.f|membership|" & Mail,
        DisplayName: DisplayName,
        Email: Mail
    }
)

Where,

DataCardValue10 = Members Combobox name

Finally, save, publish, and preview the app. Fill in the form details and click the submit button. The record will be saved in the SharePoint list, along with the Owners and Members (with multiple selections), as shown in the image below.

I hope this article helped you learn how to save multiple users from a Power Apps Combo Box to a SharePoint Person field, along with a sample scenario.

Also, you may like some more Power Apps articles:

• Create a Monthly Timesheet in Power Apps
• Create a Dropdown Navigation in SharePoint
• Create SharePoint List Item Using Copilot Studio