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
I am still looking for a solution (I don´t know how I accepted the solution on my i-phone...).
A bit more information:
1). Column type you used to save the HREmailAccess in the DOAItemList:
It is a text column. I could change it to multiple People column if needed (but I don´t think it make things easier).
2). What are the fields and controls corresponding to the formulas you have provided
(LookUp(AccessManagement,Title=DataCardValue49_1.Selected.Value).HREmailAccess)
This formula is in a text field, independant from the form I have (in order to make my tries. The form is used to create a new item in the main list, where the delegation of authority for each employee is defined.
I am trying to find out, the best way to give access to a new created item to the right person from the Human Resources Department from the second list, depending on the countries where the employee for which the Delegation is created in the main list can work (their scope).
3). If the DataCardValue49_1 allows multi select or not.
It allows multiple choice (is a combobox).
As I am still in the development phase, I am pretty opened and could change my second list.
Thanks a lot for your help!
Best regards from Germany,
Christelle
Hi @Christelle,
Some info you need to provide:
1). Column type you used to save the HREmailAccess in the DOAItemList
2). What are the fields and controls corresponding to the formulas you have provided
3). If the DataCardValue49_1 allows multi select or not.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2