How to delete multiple rows in a excel file without using an apply to each

[JorgeT]

Hi guys, 

I have a excel table and i want to make a flow that delete multiple rows, for example:

In this table i want delete all rows with user "Anthael" without using an apply to each that has to go through the entire table, Any suggestion?

Greetings!

[Hardesh15]

@JorgeT  You can use filter query in excel action- list row present in a table where User eq 'Anthael'. This will return all rows belongs to user Anthael and then you can delete.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[JorgeT]

The filter returns an array, how i can incorporate it into the delete a row excel action?

[happyume · Accepted solution]

List rows present in a table, use filter query as suggested by @Hardesh15 

Then use Apply to Each and  delete the row.

If you are concerned about time it would take to execute Apply to Each, then remember the filter query will not return every single row, but just the rows  that meet your criteria. Secondly, you can always use concurrency control to speed up the Apply to Each.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume · Accepted solution]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume · Accepted solution]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[JorgeT]

Is there a way to avoid using apply to each?

[Hardesh15]

@JorgeT  As far my knowledge, there is no other to delete row from excel. Why are you so much concern about 'Apply to each'? Please give reason in details.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[JorgeT]

In my work group they prefer to avoid the use of nested apply to each because they make the flow more complicated to understand, any way i have already convinced them that they are necessary so thanks for you helping