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 :
Power Platform Community / Forums / Power Automate - Using Connectors / Merge Excel files in s...
Power Automate - Using Connectors
Answered

Merge Excel files in sharepoint to an Azure SQL database

(0) ShareShare
ReportReport
Posted on by dbocvan 6

Hello,

 

I have a SharePoint folder with hundreds of excel files with the same columns. Every day I save a new file.

 

How can I prepare a flow to take the rows of an excel file (when it is added to the folder) and append it to an existing Azure SQL table?

 

Thanks

I have the same question (0)
  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Merge Excel files in sharepoint to an Azure SQL database

     

    Hi @dbocvan ,

     

    Generally speaking, we can only get the created Excel table and configure it in List rows present in a table, so that we can get the field value in the Dynamic content list so that we can configure other actions.

     

    Now we can directly use the Excel file identifier to get the field value in the Excel table. But it seems that the requirements are more demanding. https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations

     

     

    If the Excel table is obtained dynamically, it is hoped that the structure of the fields in the Excel table is the same, and the table names also need to be the same. In this way, we can click Enter custom value to dynamically get the Excel table. Only when the above conditions are met, we can configure the same schema in Parse JSON to parse the data in Excel table.

     

    You can refer to the following link for more details about Parse JSON:

    http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

     

    Image reference:

    109.PNG110.PNG

     

    Hope that makes sense.

     

    Best Regards,

  • dbocvan Profile Picture
    dbocvan 6 on at
    Re: Merge Excel files in sharepoint to an Azure SQL database

    Hi Barry,

     

    Thank you for your reply.

    I'm a Power Automate entry level user with no experience in Java Script.

     

    I think my requirement has 3 parts:

     

    Build an Azure SQL table with data from hundreds of excel files saved in SharePoint, each one with same columns.

     

    Merge to that same table other hundreds of excel files with other columns. The two type of files has the date column as common field.

     

    I have a Power Automate flow activated that saves 2 daily files I receive in my gmail account, in a SharePoint folder. The idea is to update the new SQL table with the new data on daily basis.

     

    Can you please share some documentation that I can refer to complete the 3 tasks?

     

    Thank you,

     

     

     

  • dbocvan Profile Picture
    dbocvan 6 on at
    Re: Merge Excel files in sharepoint to an Azure SQL database

    Hi @v-bacao-msft ,

     

    Any idea of how can I create a SQL table in azure based on several excel files saved in Sharepoint, and update the table using Power Automate?

     

    Thank you,

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 544 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 482 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 287

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans