cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
moosmutzel
New Member

Related data sources at different screens

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?

 

2 REPLIES 2
CarlosFigueira
Power Apps
Power Apps

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)

 

Hey CarlosFigueira,

many thanks. This was the missing link 🙂

 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (61,689)