Export multiple sql tables to respective excel work sheet dynamically

(0) Share

Report

Posted on by slau05

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

I have the same question (0)