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 should format a table in the excel file refer to link below:
And then you could refer to screenshot below to create the flow:
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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