News and Announcements icon

Power Platform CommunityForums Power Automate - Power Automate Desktop how to use Power Autom...

Power Automate - Power Automate Desktop

Suggested answer

how to use Power Automate to delete filtered rows in Excel

(0) Share

Report

Report

Posted on by J蒋-10120840-0

6

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:

Process Advisor

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

eetuRobo 2,574 on at

Like (0)

Report

how to use Power Automate to delete filtered rows in Excel

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 144,609

#2

RandyHayes 76,287

#3

Pstork1 64,420

Leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts

List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans