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

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
JorgeT 20 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Mitanshu 1,650 Moderator on at

Like (2)

Report

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.

Was this reply helpful? Yes No
JorgeT 20 on at

Like (1)

Report

Is there a way to avoid using apply to each?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
JorgeT 20 on at

Like (0)

Report

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

Was this reply helpful? Yes No