cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henry1
Advocate I
Advocate I

Listbox MultiSelect Values

I am using a mulitselect list box that I need use all the values for somewhere else in my form( preferably coma or semicolon deliminated). In my text box I have the following TextBox = ListBox2.Selected.Value. This formula only gives me the last value selected. Am I missing something? thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Ryanmch
Power Apps
Power Apps

Hi Henry,

 

I tested your scenario with a new app with a multiselect listbox, using the default sample data for the listbox, and a textbox. The type of ListBox.Selected.Value is a table result so I was able to do the following to get the selected values.

 

TextBox1.Text = Concat(ListBox1.SelectedItems.Value, Concatenate(Text(Value),","))

 

Result:

 

GetListBoxSelectedValues.png

View solution in original post

5 REPLIES 5
Ryanmch
Power Apps
Power Apps

Hi Henry,

 

I tested your scenario with a new app with a multiselect listbox, using the default sample data for the listbox, and a textbox. The type of ListBox.Selected.Value is a table result so I was able to do the following to get the selected values.

 

TextBox1.Text = Concat(ListBox1.SelectedItems.Value, Concatenate(Text(Value),","))

 

Result:

 

GetListBoxSelectedValues.png

View solution in original post

Is there anyway to have multiple items (i.e 1 and 2) selected when the page loads?

Hi Henry,

 

Did you get a way to pre multi-select listbox items onload ? 

 

I am trying to achieve the exact same thing.

 

Any pointers would be greatly helpful ?

 

Thanks & Regards,

Rahul 

@Ryanmch

 

The formula you have works on New form creation. But on edit, all the values selected are gone. If i make edit on other fileds, the list box values changes to default ( in my case it sets it to none).

Can you help with this please.

 

Thanks!

This function works perfectly on my app. I can save in my data base as string like "1,2,3"

 

But I have a question, how can I read back that string to a Listbox again, obviously I want to color those selected items in my listbox?

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (26,826)