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
