Hello, I wish to make only the selected item with same Staff ID appear only in Gallery1_1.
Solved! Go to Solution.
You have Gallery 1 where You will select a member of Staff make sure that SharePoint List have StaffID column or however You called the Employee Number field.
In Gallery2 place Filter like below
Fillter(
"SharepointList",
StaffID = Gallery1.Selected.StafID
)
hope this is what You looking for
Hi @Virikefe22 ,
What are the current Items of the gallery and how are you going to determine which Staff ID to display ?
Just Gallery.Selected, which is populating all the values mixed together, but I need to filter same user with same Employee Number.
You have Gallery 1 where You will select a member of Staff make sure that SharePoint List have StaffID column or however You called the Employee Number field.
In Gallery2 place Filter like below
Fillter(
"SharepointList",
StaffID = Gallery1.Selected.StafID
)
hope this is what You looking for
User | Count |
---|---|
253 | |
113 | |
92 | |
48 | |
38 |