Unanswered

Multi select combobox only saves single value despite selecting multiple options

(0) Share

Report

Posted on by Iantaylor2050

531

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
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.

Was this reply helpful? Yes No