Is it possible to delete rows in Excel based on a cell value?
I am comparing a data-set in Excel to another Excel file using Feature Merger. I want to delete the rows in the data-set which match a specific field (DETECTOR) in the new file(s).
I feel like this should be very basic since Power Automate can do it (And MS has a surprisingly poor integration with their own software). The closest thing I found was the Database Deleter, but it doesn't have an Excel option for format. I can add Microsoft Excel as a new custom format, but that doesn't behave the way I would expect (opens a new workspace?).


But when it executes, the FeatureWriter only deletes the first row (red is the deleted row, purple is the row that should be deleted, and blue is the new row that was added):