Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to make a simple ETL with Power Automate and Sharepoint ?

Hi there,

I would like to know your idea about the use case I'd like to automate.

We receive through Sharepoint several excel sheets from different partners. By definition all sheet carry same kind of data formated the same way the only which differs from one file to another is the column ordering. I would need to combine all those file into a single one after having unified the column ordering of the source excel sheets.


How would you make that ?


Thank you 

Solution Sage
Solution Sage

Hi @CSA75FR ,


How many rows of data would each sheet have?  Apart from combining the sheets into one, what else is required?  


If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Hi @eric-cheng,


Each sheet may have up to 100 rows. 

Operation expected between the source excel sheets and the target one is mostly about data mapping and calculation to fill fields in the target sheet which don't exist in the source.


I thought about the following approach :

1°) Importing each source sheet into a corresponding sharepoint list

2°) Creating a sharepoint list to receive the target content

3°) Running a SQL statement to populate the target list (which I don't know how to do)

or using an excel sheet linked to the source sharepoint list and running a vba code to produce the target content into a specific tab (in that case step 2 is not required)

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,409)