Delete Excel Row on Specific Criteria

[cosmaar1]

Hello all.  I am trying to build a combined flow for when an item is created/modified on a SharePoint list that it either adds a new row to an Excel file or modifies an existing entry on the Excel file if it already exists on the SharePoint list.

I am able to get new rows to be added and modified, but when I am trying to add a section about when a user deletes a row on the SharePoint list, the Excel file needs to also delete that same row, that is where I am having an issue.

I am having a lot of difficulty understanding the process of building filters and I think that is half of my battle.

I've posted a couple pictures below, but my criteria is simple:  when the status column on the SharePoint list is changed from Active to Void, the Excel file row that correlates is changed from Active to Void and then both the entry on SharePoint and Excel will be deleted.  This flow in particular handles the Excel file.

[cosmaar1]

bump.

[jesslynh]

I'm not a Flow expert, but I'd have a column in the Excel file that correlates to the ID column of the SharePoint list and then delete based upon that number as appropriate.  Definitely not the most elegant way to do this, but maybe the easiest.  

[cosmaar1]

Hello Jesslynh.  That is what I have set up currently.  The problem is I don't quite understand how to build the filter array correctly to filter out the values that do not apply.  For example, in my scenario, I only want the active values to show on the Excel document.  Anything that is marked void or revised need to be deleted.  This is all accomplished by the "Status" column I have on my SharePoint list.

In my Excel table, I have an ID column already set up, which captures the unique ID.

[jesslynh]

To find out where the disconnect is, you may want to use various connectors so that you can view the outputs.  I use temporary items like Compose and variables to see the output between steps to help me find where my code has gone wrong.  Once things are working, I delete them from the final flow.

In addition, Bhawana Rathore wrote a nice blog pots about filtering Excel tables - Power Automate list rows present in a table filter query - EnjoySharePoint.  Hope this helps