So I'm making an app to keep documentation for all our customers network setups in a sharepoint site and then creating a front end for in it powerapps. The problem I'm having is getting page 2 of the app (a list of sites) to be filtered by the choice made on page 1 (a list of companies) the two lists are in a sharepoint site and were made in access with a relationship between 2 fields in each list. Here's how it's setup:
tblCompanies has it's primary key linked to the field "Company" in tblSiteDetails.
I want to select a company from the gallery on screen1 of the app and then have it filter the gallery on screen 2, showing only the sites belonging to the company I just picked on screen1.
Is there a simple piece of code I can use to do this or would it be a complicated feature? Any help would be great.
Thanks,
Corban
