Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

ComboBox.SelectedItems.Result to Text field in SP List

  • 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]" ?

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.

Super User
Super User

Re: ComboBox.SelectedItems.Result to Text field in SP List


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.

Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources


Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!


Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)


Community Highlights

Check out whats happening in Power Apps


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,979)