If I have a Drop Box that allows multiple selections, Is it possible to record the multiple selections into a collection?
Solved! Go to Solution.
Hi @Wowwowha,
Could you please share a bit more about the Drop Box that you mentioned? Is it a Combo box control?
If the Drop Box that you mentioned is a Combo box control, I agree with @dinusc's thought almost. I have made a test on my side, please take a try with the following workaround:
Set the Items property of the Combo box control to following formula:
Choices('20180825_case1'.Status)
Note: The '20180825_case1' represents the SP list data source within my app.
Set the OnChange property of the Combo box control to following formula:
ClearCollect(Collection1,ComboBox1.SelectedItems)
or
Clear(Collection1);ForAll(ComboBox1.SelectedItems,Collect(Collection1,Value))
The GIF image as below:
Best regards,
Kris
Assuming your control is a ComboBox control, this can be done by copying the following formula to ComboBox.OnChange:
ClearCollect(sel, ComboBox1.SelectedItems)
This will create a collection "sel" which will always contain the selected items.
Hi @Wowwowha,
Could you please share a bit more about the Drop Box that you mentioned? Is it a Combo box control?
If the Drop Box that you mentioned is a Combo box control, I agree with @dinusc's thought almost. I have made a test on my side, please take a try with the following workaround:
Set the Items property of the Combo box control to following formula:
Choices('20180825_case1'.Status)
Note: The '20180825_case1' represents the SP list data source within my app.
Set the OnChange property of the Combo box control to following formula:
ClearCollect(Collection1,ComboBox1.SelectedItems)
or
Clear(Collection1);ForAll(ComboBox1.SelectedItems,Collect(Collection1,Value))
The GIF image as below:
Best regards,
Kris
User | Count |
---|---|
144 | |
142 | |
78 | |
76 | |
72 |
User | Count |
---|---|
227 | |
145 | |
78 | |
62 | |
58 |