cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,664)