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

(0) Share

Report

Posted on by Datanerd

103

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

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

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 Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No