Skip to main content

Notifications

Community site session details

Community site session details

Session Id : n1SU1NVQ2o//QndpJ1sNZd
Power Automate - General Discussion
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 6 Mar 2023 19:42:54 by 516

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

or

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

  • ME-25101658-0 Profile Picture
    6 on 25 Oct 2024 at 17:17:50
    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 Profile Picture
    516 on 10 Mar 2023 at 13:41:21
    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 Profile Picture
    on 10 Mar 2023 at 01:54:35
    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 Profile Picture
    516 on 09 Mar 2023 at 13:43:17
    Re: How to use Power Automate to Import csv or excel file to SQL Server

    when I search this is what I get:

    SPSDEV22_0-1678369373100.png

     

    Do you have the URL to the Template, maybe I can find it that way

     

  • v-jefferni Profile Picture
    on 09 Mar 2023 at 01:32:53
    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.

    vjefferni_0-1678325357456.png

     

    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 Profile Picture
    516 on 08 Mar 2023 at 13:46:00
    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 Profile Picture
    on 08 Mar 2023 at 06:13:43
    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?

    vjefferni_0-1678255986088.png

     

    Best regards,

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard