Skip to main content
Community site session details

Community site session details

Session Id : Z67kFGYDz/QFGVNq+qNvd7
Power Apps - Building Power Apps
Answered

PowerApps - Lookup function from a multiple choice combobox

Like (0) ShareShare
ReportReport
Posted on 12 Mar 2022 10:17:40 by

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

 

 

  • Christelle Profile Picture
    on 16 Mar 2022 at 20:22:29
    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 Profile Picture
    on 15 Mar 2022 at 03:14:13
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2