web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Not able to Read Multi...
Power Apps
Unanswered

Not able to Read Multi Select People Field using LookUp in PowerApps

(0) ShareShare
ReportReport
Posted on by Rp_singh

Hi, 

 

I have a list where i am storing Country wise Approvers, Ex:

Country         Approvers

USA               User1; User2

Mexico          User3; User4

 

In a canvas app i need to show a button if user is in these approvers. I tried LookUp but it only gives first value of the column.

Formula : LookUp(Country, true).Approvers.Email

Result: User1; User3

 

Is there any way i can get list of all Approvers in this scenario?

 

Categories:
Building Power Apps
I have the same question (0)
  • v-yutliu-msft Profile Picture
    v-yutliu-msft Microsoft Employee on at

    Hi @Rp_singh,

    Do you want to get the records that you want ?

    Could you tell me is Email a column in your list?

    The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria. That’s the reason why you only get the first value of the column.

    I recommend you try the function of Filter.(Approvers is a multiple selection Person column)

    You can try this formula:

    Filter(listname,User().FullName in Approvers.Value)

    This formula is used to filter the records that Approvers include current user’s name.

    Here’s a doc for your reference:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

     

     

     

     

     

    Best regards,

    Community Support Team _ Phoebe Liu

  • R3dKap Profile Picture
    R3dKap 1,594 on at

    Hi @Rp_singh,

    Do you need to know if the user is among the approvers of a specific country or among the approvers for ALL countries all together ?

    Emmanuel

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks for posting in the community @Rp_singh - can you review the above replies and update the thread when you have a chance?

     

    Thank you,

     

    @Anonymous 

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans