Answered

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

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

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 89 on at

Like
a
(0)

Report
Copy link

Link copied!

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

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

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.