Manipulating data in datatables

[eberry]

I currently have 3 datatables on 1 screen. Datatable A is showing approved access housed in a SQL Table and is returning ID's for resources and access schedules.

Datatable 2 shows the list of all resources, along with their ID's, this is stored in its own table. Datatable 3 shows schedules and their ID's this is also stored in its own table. How can I have PowerApps query my information to give me a nice layout that'll just show what's been approved as well as the schedule it was approved for? I can filter Datatables 2 & 3 to show corresponding information with an entry in Datatable 1, but this will only show 1 item at a time, and it's possible that I could have multiple resources with their own schedules.

[timl · Accepted solution]

Hi @eberry 

The easiest way to do this would be to create a SQL Server view that joins your 3 data tables. You can then add the view as a data source to your app, and display the view with gallery control.

[eberry]

Thanks for the idea. That worked.