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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter gallery items b...
Power Apps
Answered

Filter gallery items based on login user

(0) ShareShare
ReportReport
Posted on by 68

Hello All, @RandyHayes 

 

I am trying to filter a gallery items based on login user.

I have 2 "Person or Group" fields (Employee & Hirining Manager) from the SharePoint list.

so i would like to see all items where my name is in the hiring manager field or if my name is in the Employee field.

 

i tried using something like below but didnt work and need your advise please!

 

Filter('Test List', 'Test List'.'Hiring Manager' = User().Email)

or 

Filter('Test List', 'Test List'.'Employee' = User().Email)

 

Note: Test List is the SharePoint list

"Hirining Manager" and "Employee" are (Person or Group) type of field

 

please find attached screenshot for details, any ideas please!

2019-05-12_18-43-34.jpg
Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @EMohaisen ,

     

    Please try below formula instead:

    Filter('Test List', Or(Hiring_xx20_Manager.Email = User().Email,Employee.Email = User().Email))

    Regards,

    Mona

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you for posting in the community @EMohaisen - can you review the above reply and update the thread if it was helpful? 

     

    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

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 335 Most Valuable Professional

#2
11manish Profile Picture

11manish 166

#3
sannavajjala87 Profile Picture

sannavajjala87 71 Super User 2026 Season 1

Last 30 days Overall leaderboard