cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Update ComboBox Selected Items from a collection

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Responsive Resident
Responsive Resident

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

Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-xida-msft 

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

Thanks a lot for your support !

Rémi

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (96,966)