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?
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
197 | |
66 | |
46 | |
36 | |
25 |
User | Count |
---|---|
239 | |
108 | |
89 | |
87 | |
66 |