Unanswered

Related data sources at different screens

(0) Share

Report

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

CarlosFigueira Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
moosmutzel 2 on at

Like (0)

Report
Copy link

Link copied!

Hey CarlosFigueira,
many thanks. This was the missing link 🙂

Was this reply helpful? Yes No