Combo box Multiple selection

[Nandha]

Hi,

I have a combo box with 100 list items,

User should select multiple items and click submit

Selected items should save in excel in separate rows

pls guide me how to do it

[KrishnaV]

Hi @Nandha ,

Try this:

ForAll(comboControl.SelectedItems,
Patch(ExcelShourceName,Defaults(ExcelShourceName),{Clumn1:"Values1",comboValueColumn:Value})

Note: Value here should be replaced with the column name you are populating in your combo box

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my

community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[v-yutliu-msft]

Hi @Nandha ,

Do you want to update multiple rows by using selected items of the combo box?

Could you tell me the formula in the items of the combo box?

Usually, we use ForAll and Patch function to update multiple items of data source.

I almost agree with the formula that @KrishnaV  provided.

However, you could only update one field by using this combo box.

Try this:

ForAll(combo box name.SelectedItems,
Patch(exceltablename,Defaults(exceltablename),{columnname:fieldname in combo box})
//please replace with combo box name, exceltablename,columname(column in excel) fieldname in combo box

Best regards,

[Nandha]

I have put this formula

ForAll(DataCardValue30.SelectedItems, Patch(Emptyspoollist,Defaults(Emptyspoollist),{Emptyspooldetails:'Empty spool details_DataCard4'}))

But showing error

Name isnt valid. This identifier isnt recognised

[KrishnaV]

Hi @Nandha ,

Try this:

ForAll(DataCardValue30.SelectedItems, Patch(Emptyspoollist,Defaults(Emptyspoollist),{Emptyspooldetails:Value&";"}))

Note: In the above formula Value is from my multi-select dropdown field.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[Nandha]

Still same error coming