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
Solved! Go to 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:
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:
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
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?
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
265 | |
209 | |
76 | |
42 | |
33 |
User | Count |
---|---|
345 | |
219 | |
117 | |
71 | |
54 |