Listbox MultiSelect Values

[Henry1]

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

[Ryanmch · Accepted solution]

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:

[Henry1]

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

[rahulvartak]

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]

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

[rtoapanta]

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?