
Hi,
I have a sql stored procedure that will extract data into multiple sql tables (minimum 5, up to 10 tables) with prefix table name(for example tableA_1, tableA_2, tableA_3 ..etc) with different columns created in each tables during the execution of SP.
I would like to create a flow to populate all tables prefix with tableA_% to a new excel file. Create individual sheet(name same as table name) for respective tables with all columns. Then save the file in the Sharepoint.
I am new to Power Automate, I would appreciated if someone can share with me some light of how we can create a flow populate multiple sql tables into single excel file with multiple sheets.
Thanks,
Tlau