ComboBox.SelectedItems.Result to Text field in SP List

[PwrOf3]

• Inside my power-app I have a form connected to a SharePoint List I control.
• I have created a ComboBox that gets items dynamically from another SP list.
• This works, and my ComboBox offers the multiple items choice as expected.
• The DataCard in which I'm doing this is connected to a text field on my SP List.
• the Update value of this DataCard is currently only accepting Text values (because connected to the Text field in SP List).
• ComboBox.Selected.Result is a text value, but only keeps the latest selected choice from the dropdown menu
• ComboBox.SelectedItems.Result is a table type, hence it's not accepted by the text field in the SP List

How can I pass the multiple selected items to Update, so that final result would be a text field as follows:
"Item1; Item2; Item6" ?

Can I also read it back as "DefaultSelectedItems = [ThisItem.MyField]" ?

PS.
I use a text type for that field because I don't know the possible choices as they may vary in time.

Thank you for any help.

[RandyHayes]

@PwrOf3

Try changing your Update property for that datacard to the following formula:

Concat(ComboBox.SelectedItems, Result & ";")

 That will give you the concatenated list with semicolon separation.  Keep in mind that this will end with a semicolon.  (i.e. "Item1; Item2; Item6;")

If you wish to exclude that you can change your formula to the following:

Left(Concat(ComboBox.SelectedItems, Result & ";"), Len(Concat(ComboBox.SelectedItems, Result & ";"))-1)

This will perform the concat twice, once to get the length and the other to trim it by 1 (the trailing semicolon).

If you want, you can also use the With function for this - change formula to the following:

With({cList: Concat(ComboBox.SelectedItems, Result & ";")}, 
   Left(cList, Len(cList)-1)
)

All of the above should give you what you are looking for.

I hope this is helpful for you.