Multi-select items in listbox

[peterstylias]

can somebody please help me how can i make it to work in powerapps.  data source is a spreadsheet saved on onedrive account.

1.  i created a listbox with several items on it but when i ran it, i can do multi-select but only the last value will be saved on the spreadsheet column for that box.  i was hoping its going to be multi-values separated by a comma or something.

2.  i have "others" as an option on that list and i want to be able to type any character on a text box within the same datacard that will be visible once i press others and still be saved on the same column on the spreadsheet

appreciate all the help!

[peterstylias]

@v-xida-msft  , yes I want these to be stored in a record back to spreadsheet and still be highlighted/selected once i press edit on that same record.  i have tried your suggestions below but i am having error on these three settings (see attached pics), please advise.  i think we are on a right track though.

[v-xida-msft · Accepted solution]

Hi @peterstylias ,

Based on the formula you provided, I think there is something wrong with your formula.

Please set the Update property of the Data card which contains the ComboBox in your Edit form to following:

If(
   "Other" in ComboBox1.SelectedItems.ColumnName, // ColumnName represents the column you used as Displayed value within the ComboBox
   TextInputBox1.Text,
   Concat(ComboBox1.SelectedItems, ColumnName & ";")
)

Set the Visible property of the Text Box under the same data card to following:

If(
   "Other" in ComboBox1.SelectedItems.ColumnName,
   true,
   false
)

Set the DefaultSelectedItems property of the ComboBox to following:

ForAll(
       Split(
             ThisItem.ExcelColumn, // ExcelColumn represents the column in your Excel table to store the selected options
             ";"
       ),    // do not miss close ')' symbol here
       {
         ColumnName: Result   // ColumnName represents the column used as Display value in your ComboBox
       }
)

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

Best regards,

[peterstylias]

@v-xida-msft , finally got it to work.  thanks a lot!  i have a question on the ForAll function, are the previous values supposed to be highlighted on the combobox or it will only get those values and display it on the details screen?  right now, i am not seeing anything highlighted or selected on the combobox but at least when i did not do anything on that record when i press edit and submit, it doesn't go blank on the spreadsheet unlike before.  and also how can i remove the trailing ";" at the end.  there's always an extra semicolon at the end of the data.