Multi select combobox only saves single value despite selecting multiple options

Like (0) Share

Report

Posted on 5 Jul 2023 16:53:15 by Iantaylor2050

494

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:

General Questions

All responses (2)

Answers (0)

AJ_Z 3,711 Super User 2024 Season 1 on 05 Jul 2023 at 17:14:56

Like (0)

Report
Re: Multi select combobox only saves single value despite selecting multiple options

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.
Rajkumar_M 3,681 Super User 2025 Season 1 on 05 Jul 2023 at 16:59:57

Like (0)

Report

Re: Multi select combobox only saves single value despite selecting multiple options

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.