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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Local excel file to sq...
Power Automate
Suggested Answer

Local excel file to sql server update automatically

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

I am trying to build a flow where When the contents of an excel sheet changes a flow is triggered and the contents of the excel file are either updated or created in the sql server.. 

I am using azure "when a file is modified as a trigger".

my question is how can iterate through the ids and identify which ones to update and which ones to add. 

Please help

 

Example:

 

excel file 

id    desc

1     a

2     b

7     c

6     d (needs to be updated)

5     e (need to be added)

 

sql server

id    desc

1     a

6     l

8     x

7     c

2     b

 

after the flow triggers i would like the sql server to be as such

1    a

6    d

8    x

7    c

2    b

5    e

 

Categories:
I have the same question (0)
  • ME-25101658-0 Profile Picture
    6 on at
    Did you ever get a way to ingest a Excel file into SQL in the end? 
  • Suggested answer
    trice602 Profile Picture
    16,007 Super User 2026 Season 1 on at
    Hi,
     
    I just replied how to do this in another post about 5 minutes ago.  Please check this out.
     
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     

     
  • takolota1 Profile Picture
    4,978 Moderator on at
    You can monitor an Excel file for creates, updates, & deletions and copy those changes to another datasource like in this template

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard