I have a multiselect combobox in powerapps which is the equivalent person or group field in SharePoint. Allow multiple selections has been enabled for this column named "Members" in SharePoint and powerapps as well.
Items property of the combobox
Filter( Office365Users.SearchUser({searchTerm: DataCardValue17.SearchText,top:500}),
Department = "Banking & Finance"
)
Default property of the combobox = Blank
Default Selected Items of the combobox = Parent.Default
Update property of the datacard
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(DataCardValue17.Selected.Mail),
Department: DataCardValue17.Selected.Department,
DisplayName: DataCardValue17.Selected.DisplayName,
Email: DataCardValue17.Selected.Mail,
JobTitle: DataCardValue17.Selected.JobTitle
}
I have selected multiple values in combo box in powerapps new form and submitted the form. However in SharePoint i can only see single value.
Any idea where i am going wrong?
Hi @Iantaylor2050
You're seeing only one value in SharePoint because in your Update property of the data card, you're using "Selected" property which is for single selection. For a multi-select combo box, you should use the "SelectedItems" property which returns a table of all selected items.
Below is an example of how you can modify your code to accommodate multiple selections:
ForAll(
DataCardValue17.SelectedItems,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(Mail),
Department: Department,
DisplayName: DisplayName,
Email: Mail,
JobTitle: JobTitle
}
)
In this formula I assumed DataCardValue17 is your combobox name if not, DataCardValue17 should be replaced with your actual combo box control name. This will iterate over each selected item and create a table of user information which will then be written to your SharePoint "Members" field.
Remember, when you're using the ForAll function, the context inside the function changes. So instead of using DataCardValue17.Selected.Mail, you simply use Mail, Department, DisplayName, and JobTitle. This will refer to the properties of the current item in the ForAll loop.
Also, ensure that the "Members" field in your SharePoint list is set up to accept multiple values.
I hope this helps! Let me know if you have further questions.
Hi
Plz try this formula, it may help you
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Concat(
DataCardValue17.SelectedItems,
Concatenate(
"i:0#.f|membership|",
Lower(Mail)
)
),
Department: First(DataCardValue17.SelectedItems).Department,
DisplayName: First(DataCardValue17.SelectedItems).DisplayName,
Email: First(DataCardValue17.SelectedItems).Mail,
JobTitle: First(DataCardValue17.SelectedItems).JobTitle
}
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
WarrenBelz
83
Most Valuable Professional
MS.Ragavendar
54
mmbr1606
41
Super User 2025 Season 1