cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
moosmutzel
Level: Power Up

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
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Related data sources at different screens

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
Level: Power Up

Re: Related data sources at different screens

Hey CarlosFigueira,

many thanks. This was the missing link 🙂

 

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,057)