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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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