Hello all!
Please may I ask for some help...
Building an app that our employees will use to identify their skills that should store their selections in a SP List against their name (ideally all skills in one column).
The users should be able to come back to the app and see the selections they have made and either add new ones or remove existing selection.
1) Have a sharepoint list with a list of 50 entries (skills)
2) Have a 2nd SP list that stores the results of Submit (have also created a Choice column in this list with all the entries in SP List 1 but not using it at the mo)
2) Have a gallery with Items property set to the list name (works fine, all items in the list are showing) and Collection created when clicking the arrow next to each item
3) Have a 2nd Gallery connected to the Collection so that when an item in Gallery 1 is selected, it populates in the 2nd Gallery.
I would like that Onselect of the submit button, the values selected in Gallery 2 are written back to a single column against the user that made the submission.
I have this in OnSelect:
ForAll(Gallery2_1.AllItems, Patch(' Capability Inventory', Defaults('Capability Inventory'), Form4.Updates, {Choices:Label8_1.Text}))
Form4 in the formula is a form on the home screen that grabs logged in user name, their email, Line Manager etc.
The current result is that mutilple items are created in the SP list (one line in SP per each entry in Gallery 2) against the user that submitted it.
Have added some screenshots that will explain it.
Thank you in advance for any advice you can give me 🙂
SP List showing selected items in Gallery 2 after Patch...one entry for each item submitted bu the logged in user
Selected items FROM gallery 1 INTO Gallery2
Entries created in SP List; one for each item in Gallery 2 against the name of the user that submitted
