Hi There!
I have a main SP item list (DOAItemList) for Delegation of Authority. Each individual get their own country scope.
Person A gets Germany, Austria, Switzerland
Person B get Germany, Austria
In a second list (AccessManagement), I have access rights defining which employee of the Human Resources can access the different items from the main List.
Title HREmailAccess
Germany Person 1
Austria Person 2
Switzerland Person 3
In order to secure the list with Power Automate, I need to get for each new item created the name of the person/people from the list 2 who will get access.
I have no problem when the item from the main list has only one country
(LookUp(AccessManagement,Title=DataCardValue49_1.Selected.Value).HREmailAccess)
and could use it in the form so that the email is written to DOAItemList when submitting the form.
But cannot get the formula right with a ForAll(DataCardValue49_1.Selecteditems...), a Lookup and maybe a concat functions all together.
Has someone a solution?
Thanks a lot in advance.
Best regards from sunny Munich!
Christelle