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

Multiple selected item on List box to Excel

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

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

View solution in original post

1 REPLY 1
Community Support
Community Support

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

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (5,332)