Display Items in a lookup by linking two data tables

[Anonymous]

Hi,

I hope you could help me. My problem is that:

I have two data sources to display : "officer" and "application" and one gallery linked to officer. When I click on a officer item Gallery, I see his details. And under his details, we can click in a button which is supposed to display all the applications linked to this officer. That's my problem. Given that we can only have officer gallery, how are we supposed to tell to the PowerApps application: 

-> Display "application" data source linked to this officer. Knowing that only the date is the match between the two data sources.

I tried that:

LookUp('Apllication', variable=GalleryOfficer.Selected.Created Or variable=Gallery1_2Officer.Selected.Created)

.

I also tried that:

LookUp('Apllication', variable=GalleryOfficer.Selected.Created)

But its not work at all. This loop is supposed to return the "Application" item whom date correspond to the "Officer" item selected.

Please, I need your help 

[Jeff_Thorpe · Accepted solution]

If you are going to a detailed screen when you click on the Officer item in the gallery then you can add a gallery to the detailed screen (if there is room) and have that gallery display items from the application data source that is related to the selected officer.

If you don't have room on your detail screen then you could have your button open another screen that displays the application gallery.

I am not sure of the relationship between "officer" and "application" but here is an example of how the formula for the application gallery Items property might look (gallery1 is the officer gallery):

Filter('Application', AppUser = gallery1.selected.user)

[Anonymous]

Thank you Jeff_Thorpe for your help. Your first supposition is true.

I display a detail screen when I click on item in Gallery officer. My detail screen also have a Gallery officer instead of Gallery application.

What I want, is to display all the applications (from application data sources) linked to the officer item I selected.

Knowing that we manipulate 2 data sources : "officer" and "application". And we want to linked items from those 2 sources by saying, all "applications" created at date X are linked to the officer created at the same date. 

That's why I tried:

LookUp('Apllication', variable=GalleryOfficer.Selected.Created Or variable=Gallery1_2Officer.Selected.Created)

And

LookUp('Apllication', variable=GalleryOfficer.Selected.Created)