How to connect from excel files in sharepoint to a sql database

[Datanerd]

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

[abm]

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

[v-alzhan-msft · Accepted solution]

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-5af9df0ac6...

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.