how to use Power Automate to delete filtered rows in Excel

(0) Share

Report

Posted on by J蒋-10120840-0

After filtering the data that needs to be deleted, I want to delete these rows. Could you please advise on how to set the appropriate variables for row deletion?

The Microsoft learning hints state, "The index number of the row to be deleted. Numbering starts from 1." However, I find it challenging to set this because of the filtered data.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

If you are only filtering the data to delete it I would not use filter at all. I would just find the rows I want to delete and loop and delete them.

Like so:
Use Find and replace cells in Excel worksheet

That produces Cells Table like so:

Then Sort data tables RowIndex -column to decending so the table looks like this:

We sort it to be decending so that when you delete the row in excel it deletes from top to bottom. If you would first delete rowIndex 2 then the 5th row index would become 4 and so on. So that’s why we sort it to decending.

Then use For each to loop the Cells table and delete those rows.

Was this reply helpful? Yes No
jblackcitrin 6 on at

Like (1)

Report

eetuRobo's solution worked really well for me - very appreciative of this writeup!

I used the concept to to do the opposite - remove rows NOT on my list. To accomplish this, I used an inner join of all rows and the data I want to keep then filtered the list to remove the rows I want to keep.

This allowed me to use Power Automate Desktop to split up a table to separate sheets based on unique values in a column while preserving formatting (conditional formatting & data validation)

Was this reply helpful? Yes No