How to use filter Gallery to another gallery by using the sharepoint ID

(1) Share

Report

Posted on by Seth18

146

Hello everyone!

I have 2 different galleries from 2 different screens. Gallery 1 shows the user's basic information while gallery 2 is detailed information for users to put in. To add on, 1 user can request multiple requests (in screen 2). How can I map the gallery 2 data to the gallery 1 data of the user so that when the user clicks to view itself on screen 1, it will only show the data of the user request? (For Ex: I requested 5 data under my name but also another user requested 3 data under his name how can I make sure when I click on my name it will only show my request and not include another user's request)

Screen 1 Gallery 1

Screen 2 Gallery 2

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

SoPatt Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I think you would have to share more information about your data, otherwise I can only guess.

You need a common point of comparison between the data sources of the two galleries. Let's say both Galleries' data sources have a field called UserID. Then in Gallery2's datasource you could do:

Filter(Gallery2DataSource,UserID=Gallery1.Selected.UserID)

That's about the best I can do given no information about what data the two galleries might have in common.
redeagle 8 on at

Like
a
(0)

Report
Copy link

Link copied!

From what you describe, you got a 1:n connectionin your data.
One dataset in list one (person) is connected to n datasets in list two (requests).
Now there is several ways to connect the lists.
You could do this with a lookup column in list two, refering to list one.
This works fine to assign (in your case) a person to a request, but in your app you will have delegation warnings, when trying to filter (display all request of selected person).
Delegation warnings should be avoided, since they not only mean incomplete results on large datasets, but also decreased performance of your app.
To get around this, you can either add a column or you just go with a simple (lookup is a complex) column in the first place.
Each SharePoint list has a column "ID", which is unique.
So simply, if you have a number column like "PersonID" in your list two, you can assign it the ID of your gallery one on creation of your dataset (In the form) you can set the Update property of the datacard for the PersonID field to be Gallery1.Selected.ID, so a new request will always have the selected Person dataset referred.
in your Gallery2 (requests) you can set the Items property to something like Filter(ListTwo, PersonID=Gallery1.Selected.ID). This will always show all requests related to the selection made in Gallery1.