Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(0) ShareShare
ReportReport
Posted on by 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

  • Verified answer
    Re: How to connect from excel files in sharepoint to a sql database

    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:

    1.png

     

    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.

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: How to connect from excel files in sharepoint to a sql database

    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

     

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics