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 from an...
Power Apps
Unanswered

Filter gallery from another gallery

(0) ShareShare
ReportReport
Posted on by 71

Hi,

 

I have a sharepoint list 'Employee Register' displayed in my power app as a gallery. Then I have another sharepoint list 'HR Alerts'. In the HR Alerts list, I have a lookup field of 'Employee Full Name' which is from the 'Full Name' field in the employee register.

 

Onselect of the employee register, it views the item form as a view. Above it I would also like to show the Hr Alerts connected to the same employee register item. How do I filter the HR Alerts Gallery to view only items with the same full name?

Categories:
I have the same question (0)
  • Akser Profile Picture
    1,546 Moderator on at

    Hi @jessicabishop47,

     

    Add a gallery and set this as the 'Item' property:

    Filter(
     'HR Alerts',
     'Employee Full Name'.Value = User().FullName
    )

     

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @jessicabishop47

    If possible, use email addresses as they are unique. Names can apply to many people. In HR, giving the wrong data to people can be catastrophic. 

  • jessicabishop47 Profile Picture
    71 on at

    Why do I use the User().FullName? I'm wanting to grab the correlating item from the first gallery/sharpeoint list 'Employee Register'.

  • R Bakker Profile Picture
    725 on at

    How about this

     

    OnSelect: of you person gallery Set(varPersoneSelect,ThisItem)

    Then filter your second gallery with.

    Filter('HR Alerts','Employee Full Name'.Value=varPersoneSelect.'Full Name')

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard