Display multiple SQL tables in one table ready for export

[jamesfisher]

Hello everyone,

My PowerApp is linked to a number of SQL tables, which cover customer, financial, approval and sponsor details etc. All of which have a customer number ID in each table to link them. The information is manually entered within the app and the subsequent tables above update on submit

I am trying to figure out how to display the tables alongside one another in a master view where the data can be reviewed before exporting to Excel. What is the best way to do this? I've provisionally built the flow to create the Excel file and store it in SharePoint but I just can't figure out the summary table view because of the different tables.

One other thing, there is a status column, which has a number of stages but it is when it gets to 'ready for export' that I want the summary table filtered to

I can provide anymore information if required

Appreciate any help/guidance

[jcfDaniel]

Hi,

Can you create a view in SQL? If you can, you can pull that view and show it in a gallery, for exemple.

[jamesfisher]

SQL isn't really my strong point to successfully achieve this so wondering if it can be done using collections or something similar. I just don't quite know how to get started to display this on its own screen 

[jcfDaniel]

I you can setup a gallery and point its Items to the Customer Table. In that gallery you can lookup the othe tables:

Lookup(FinancialTable, CustomerID = ThisItem.ID ).TheColumnYouWant

You can also collect the tables so you don't have to lookup an external source in your gallery. You can do this OnStart, for example: Collect(colFinancial, Financial). The the label in the gallery would be Lookup(colFinancial, CustomerID = ThisItem.ID ).TheColumnYouWant