Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iDS2AcLWc9s/a/clAYa5fE
Power Automate - Building Flows
Answered

Update Excel table from changes in a Sharepoint List

Like (0) ShareShare
ReportReport
Posted on 25 May 2023 12:21:20 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

 

  • Verified answer
    pmasse1 Profile Picture
    32 on 25 May 2023 at 12:53:22
    Re: Update Excel table from changes in a Sharepoint List

    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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 288 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 245 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 212

Overall leaderboard
Loading started