Navigating to a parent from a gallery to a details screen with two data sources

[AislingFaulkner]

I have two tables, one with employee names, and one with each employee's records of a specific request. I want to navigate from the gallery with the employee names to the selected employee's request screen. How do I navigate from one data source(gallery.selected) to another datasource?

[eka24]

Assuming the common Field between the 2 Datasource is EmpID, in the Onselect of an icon inside the Gallery1, put:

Set(Myselection, ThisItem.EmpID)

Then on the Item of the form in the details screen;

LookUp (Datasource,EmpID=Myselection)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[AislingFaulkner]

That works for navigation, but it only shows one record instead of the 8 it should. Is there another value I should pass?

[eka24 · Accepted solution]

If it not a form but another Gallery, change the formula to:

Filter(Datasource,EmpID=Myselection)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.