web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : tcPp/W5aL4HeOBHkNIwuX2
Power Automate - Using Connectors
Answered

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

Like (0) ShareShare
ReportReport
Posted on 4 Mar 2020 19:09:29 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
    v-alzhan-msft Profile Picture
    on 05 Mar 2020 at 03:17:50
    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
    32,506 Most Valuable Professional on 05 Mar 2020 at 01:46:38
    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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics