Update ComboBox Selected Items from a collection

[RMA13]

Hi !

I use gallery and collection in my form to select several items.

Gallery and collection are based on the choices of a SharePoint combobox field.

I would like to update the selecteditems value of the combobox with the result table (from the collection), to store the user selection on my sharepoint list.

Hope it will be clear enought 🙂

Thank for helping !

Rémi

[PavanKumar]

HI, You can use following formulae to get all selected items from combobox and update the same in sharepoint.

items: Distinct(Filter(Product,Name.Id=Dropdown.Selected.ID),Title

Please let me know if you have any further questions.

Regards,

Pavan Kumar Garlapati

[v-xida-msft · Accepted solution]

Hi @RMA13 ,

Could you please share a bit more about the result table that you mentioned?

If you want to update the Selected items within the ComboBox control, please consider take a try with the following workaround:

Set the DefaultSelectedItems property of the ComboBox control to following:

ForAll(
           ResultTable,
           {
             Value: ColumnName
           }
)

Note: The ColumnName is a column in your ResultTable, which you want to use as Display value within the ComboBox. I assume that the SelectMutiple property of the ComboBox control has been set to true.

Please take a try with above solution, check if the issue is solved.

Best regards,

[RMA13]

Hi @v-xida-msft 

I will try to use the DefaultSelectedItems property to update the combobox 🙂

Thanks a lot for your support !

Rémi