PowerApps - Lookup function from a multiple choice combobox

Like (0) Share

Report

Posted on 12 Mar 2022 10:17:40 by Christelle

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

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

Christelle on 16 Mar 2022 at 20:22:29

Like (0)

Report

Re: PowerApps - Lookup function from a multiple choice combobox

Hi @v-qiaqi-msft

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
Verified answer

v-qiaqi@microsoft.com on 15 Mar 2022 at 03:14:13

Like (0)

Report

Re: PowerApps - Lookup function from a multiple choice combobox

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.