Update Excel table from changes in a Sharepoint List

Like (0) Share

Report

Posted on 25 May 2023 12:21:20 by pmasse1

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

Any help is appreciated!

Thanks,

Pete

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

pmasse1 32 on 25 May 2023 at 12:53:22

Like (0)

Report

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!