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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / how to filter from per...
Power Apps
Unanswered

how to filter from person column group?

(0) ShareShare
ReportReport
Posted on by 127

how to select a  single column?

idsectionmemberUser
1

ICT

Accounting

CSE

abc

xyz

cyz

2

Bilogy

Chemisity

maths

hagos

axum

alamata

memberuser is a person colum which could have multiple user in each row.

Now i want to display section on level, if the current user is memberUser.

each memberUser contains unique users.

if MemberUser column was a single value I would use something like this on my label or textbox to show section name

Lookup(mysharepointlist, memeruser=User().Email,section)

so how do i display the section name of the current user, if the column is person with multiple users?

Categories:
I have the same question (0)
  • Verified answer
    v-mengmli-msft Profile Picture
    on at

    Hi @Sebey ,

     

    Do you want to lookup the multiple selected column and show section name?

     

    If the section is a text type column in your list, maybe you can try this:

    Lookup(mysharepointlist, User().Email in memberUser.Email, section)

    Best regards,

    Rimmon Li

  • Sebey Profile Picture
    127 on at

    works great, thanks

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard