Unanswered

Filter gallery from another gallery

(0) Share

Report

Posted on by jessicabishop47

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @jessicabishop47,

Add a gallery and set this as the 'Item' property:
Filter( 'HR Alerts', 'Employee Full Name'.Value = User().FullName )

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
jessicabishop47 71 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!
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')

Was this reply helpful? Yes No