cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JorgeT
Regular Visitor

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

Hi guys, 

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

TasksExcel.png

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

6 REPLIES 6
Hardesh15
Super User
Super User

@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

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

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.

Is there a way to avoid using apply to each?

@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

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,334)