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 / Update Excel table fro...
Power Automate
Answered

Update Excel table from changes in a Sharepoint List

(0) ShareShare
ReportReport
Posted on by 32

Hello, I have a flow that I want to do the following:

 

Anytime an item is added to SP List --> Add row to Excel Table

Anytime an item is updated in SP List --> Update row in Excel Table

 

It seems like a simple enough flow, but the second part of my flow (updating excel rows) is not working. It for some reason doesn't recognize the ID and adds a new row. Please note ID2, is in fact the ID field from SP (it was somehow renamed, but it is still represented by ['body/ID'].

 

The Condition formula is empty(body('filter_array')) is equal to TRUE

 

pmasse1_0-1685016918459.png

pmasse1_1-1685017114594.png

 

Any help is appreciated!

 

Thanks,

 

Pete

 

Categories:
I have the same question (0)
  • Verified answer
    pmasse1 Profile Picture
    32 on at

    It looks like I was able to get this flow to work by following the suggestions of @RodM in this post here: Solved: Re: Clone SharePoint list to Excel table and keep ... - Power Platform Community (microsoft.com)

     

    Thanks!

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 785

#2
Valantis Profile Picture

Valantis 669

#3
Haque Profile Picture

Haque 563

Last 30 days Overall leaderboard