How to use Power Automate to Import csv or excel file to SQL Server

(0) Share

Report

Posted on by SPS-DEV-22

516

I was wondering if it is possible to either go from OneDrive excel/csv file to SQL server database?

if it is possible to load a excel/csv file to SharePoint and then have the Power Automate load the file to SQL database?

All responses (7)

Answers (0)

ME-25101658-0 6 on at

Like (0)

Report

How to use Power Automate to Import csv or excel file to SQL Server

Go Power automate, then go to My flows > New Flow > Then unders Start from a template select 'Template'
Search for this exact text: 'Synchronize files from OneDrive (Business) to SharePoint and SQL' press enter
SPS-DEV-22 516 on at

Like (0)

Report

Re: How to use Power Automate to Import csv or excel file to SQL Server

Ok, I don't have access to the link, I will try something else.
v-jefferni on at

Like (0)

Report

Re: How to use Power Automate to Import csv or excel file to SQL Server

Hi @SPS-DEV-22 ,

Try below URL:

Synchronize files from OneDrive (Business) to SharePoint and SQL | Microsoft Power Automate

Or

https://make.powerautomate.com/environments/YourEnvironmentID/galleries/public/templates/4f0d0bc0398811e7870df906aa521b7a/synchronize-files-from-onedrive-business-to-sharepoint-and-sql

Best regards,
SPS-DEV-22 516 on at

Like (0)

Report

Re: How to use Power Automate to Import csv or excel file to SQL Server

when I search this is what I get:

Do you have the URL to the Template, maybe I can find it that way
v-jefferni on at

Like (0)

Report

Re: How to use Power Automate to Import csv or excel file to SQL Server

Hi @SPS-DEV-22 ,

Strange... I can find this template.

I don't have an available SQL database to test, so I'm not able to create a flow from this template and show you the process. Sorry about that.

Best regards,
SPS-DEV-22 516 on at

Like (0)

Report

Re: How to use Power Automate to Import csv or excel file to SQL Server

It might, however I cannot find a link to the template.

I tried searching on PowerAutomate the templates - Synchronize files from OneDrive business to SharePoint and SQL and there is no template that name
v-jefferni on at

Like (1)

Report

Re: How to use Power Automate to Import csv or excel file to SQL Server

Hi @SPS-DEV-22 ,

Would this template meet your requirement?

Best regards,