Related data sources at different screens

[moosmutzel]

I would like to create 2 screens. The first screen presents data from Excel-table1. When I switch to screen 2 by selecting a record, I would like to present data from Excel-table2 related to selected record. 

table1:

ID|name|email

1|Example|example@sample.com

table2:

ID|department|position

1|IT|Junior Systems Engineer

1|IT|Senior Systems Engineer

Screen1:

List of all employees

Screen2:

List of all departments and job positions of selected employee.

Is there a way to solve it with PowerApps?

[CarlosFigueira]

Yes, you can certainly do that. As long as the second table has a column that identifies the element in the first one (a "foreign key"), you can use a Filter expression in a gallery in the second screen.

For example, in the first screen you would have a gallery showing all items (i.e., its Items property is set to the first table) from the first table, as you mentioned, and when an item is selected, you would navigate to the second screen.

In the second screen, you would filter the second table based on the selected item of the first gallery. You can access properties of controls in any screen, so you can reference the first gallery in the Items property of the second one (assuming that the second table is called 'JobPositions'):

Filter(JobPositions, ID = Gallery1.Selected.ID)

[moosmutzel]

Hey CarlosFigueira,

many thanks. This was the missing link 🙂