Skip to main content

Notifications

Community site session details

Community site session details

Session Id : xbjKUUUzvA/ovIvaqx2eOm
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Churchy Profile Picture

Churchy 6

#2
Chriddle Profile Picture

Chriddle 4 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 4

Overall leaderboard