I want to replace an old sharepoint system which uses a choices field with the currently unsupported "multiple select" option.
This is a request system, and the multiple select field is for 'software to include'. Therefore the selectable items are fairly static BUT can change.
So I believe I have 2 options:
Option 1: Takes longer to set up, and requires training for multiople people on how to update/manage the powerapps form, and is dependent on an external change control process. If this is my only option.. what is the code to read through all the check boxes on the screen to 1) see if they are checked and then 2) add an entry to a text field to include the checked item.
Option 2: MUCH neater, and means I can have a single screen for multiple different lists, ie Company 1 has 1 list of software, Company 2 has a different list of software, but use the same powerapps form. This also means that items can be added to the sperate lists, using sharepoint control processes, and there are fewer powerapps admin people, less chance to screw up the system! If this is possible, whats the "code" required? and then, how do I then read all the check boxes on the screen/form to 1) see if they are checked and then 2) add an entry to a text field to include the checked item.
Hi @adstar22,
Option 2 is possible using the listbox control, or a radio control.
Radio control would allow only one selected at a time.
While list box have the SelectMultiple property, when set to true, it would allow multiple selection.
See if it would meet your requirements.
For configure the items property, use the formula:
Distinct(Table, ColumnName)
Or use the Datasource directly(only available in ListBox control).
Use the ListBox.Selected or the ListBox.SelectedItems to reference the selected item.
See if this would meet your requirements.
Regards,
Michael
Thanks for looking into this. I hate it when people dont reply to ideas, or the time spent by someone.
So, whilst I havent tried this out, because I have been trying so many different solutions to a range of problems, I appreciate the response which when I return to this, will give me something useful to start with.
User | Count |
---|---|
132 | |
127 | |
74 | |
72 | |
70 |
User | Count |
---|---|
206 | |
201 | |
64 | |
63 | |
52 |