cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henry1
Level: Powered On

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
PowerApps Staff Ryanmch
PowerApps Staff

Re: Listbox MultiSelect Values

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
PowerApps Staff Ryanmch
PowerApps Staff

Re: Listbox MultiSelect Values

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

Henry1
Level: Powered On

Re: Listbox MultiSelect Values

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

rahulvartak
Level: Powered On

Re: Listbox MultiSelect Values

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 

rameshkc
Level: Powered On

Re: Listbox MultiSelect Values

@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!

Highlighted
rtoapanta
Level: Powered On

Re: Listbox MultiSelect Values

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 302 members 5,836 guests
Please welcome our newest community members: