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

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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (3,734)