web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Export multiple sql ta...
Power Automate
Unanswered

Export multiple sql tables to respective excel work sheet dynamically

(0) ShareShare
ReportReport
Posted on by

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

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard