Announcements
Hi all,
I just started using Power Automate and would like to know how to connect and copy files from excel files in SharePoint and copy the values of the file to a SQL DB.
Any help on how to go on that will be highly appreciated.
Thanks
Hi @Datanerd
You need to use Excel connector and use List rows in a table. Next you need to and a for each action step to iterate the rows. Finally use SQL insert rows action step to insert the values.
The below blog explains how to read excel file.
https://mydevexperience.wordpress.com/2019/09/25/microsoft-flow-excel-list-rows-present-in-a-table/
If you want to load the excel file to sql please see below post
https://powerusers.microsoft.com/t5/Building-Flows/Load-Excel-Attachment-into-SQL-Server/td-p/293828
Hi @Datanerd ,
You should format a table in the excel file refer to link below:
https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
And then you could refer to screenshot below to create the flow:
Best Regards,
Alice
Community Support Team _ Alice ZhangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 103 Super User 2026 Season 1
Haque 87
trice602 63 Super User 2026 Season 1
