Multiple selected item on List box to Excel

[RobinMauldin]

On a app I have created, I have a list box where people can make multiple selections. When I Submit the form, only the last item selected in syncing to my excel file I have saved in One Drive. How do I get my Excel folder to record all the items selected? Attached is my form

[v-qiaqi-msft · Accepted solution]

Hi@RobinMauldin, 

Based on the issue that you mentioned, do you want to write all the selections back to the Excel?

Could you please share more about your List box, is it filled with another table or items put in Items property? 

Combine that with your description, I think SubmitForm() can solve your problem. I have a test on my side and I'll explain the test conditions here for reference.

• Insert a List Box and put the formula below into the Items property

["Disc","Spring","Guide","Seat","O-ring","Module","Rubber Kit","Other"]​

• Set the Update property of the data card belonging to  ‘'Cleaning  Repairs and Parts Value'’ as below.

Concat(ListBox2.SelectedItems.Value, Concatenate(Text(Value),","))​

• Set the OnSelect property of the Save button as below

SubmitForm(Form1)​​

Note: 'Cleaning  Repairs and Parts Value' represents the column name in your Excel table. [ListBox1.SelectedItems.Value] is a table format that is not matched to the Excel table format. You need to convert it to strings.

Best Regards,

Qi