Hi folks,
I have built an input form out of a gallery to record interactions with organisations (Gallery is drawing from a sharepoint list called Organisations). In the gallery, if you select a checkbox on an item, it will prompt you to fill out some details for the interactions, and saves the data to another list (list is called Checklist data capture). This is working fine,
What is required (that I can't get my head around) is capturing the user data of the person filling out the form (currently I have a combobox that autofills the current user's profile) and adding that current user to a field in Organisations (called Relationships).
For example, this is what is looks like currently:
| Organisation Name |
Relationships |
| Organisation 1 |
Fred J |
| Organisation 2 |
Nina T |
| Organisation 3 |
John D |
Then someone fills out the form:
Person picker Combobox1: Jane D
Gallery1:
Organisation 1 [checkbox ticked]
Organisation 2 []
Organisation 3 [checkbox ticked]
What I want to happen in the sharepoint list:
| Organisation Name |
Relationships |
| Organisation 1 |
Fred J, Jane D |
| Organisation 2 |
Nina T |
| Organisation 3 |
John D, Jane D |
I figure that it requires ForAll, ClearCollect/Collect, and Patching, but I am struggling to figure out the right combination.
Thanks for your help.