Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

PowerApps - Lookup function from a multiple choice combobox

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    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

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1