Get Row by the Column Value

(0) Share

Report

Posted on by jtorfila

Dear community,

I've been searching and haven't found an entry related to this topic.

If there is a related open topic, I would appreciate it if you could tell me where to find it.

I'm just starting with Power Automate Desktop so I sometimes encounter a number of difficulties that I'm sure you can easily solve for me. So, the problem is related to Excel because, I've got a table with 20,000 rows and growing and I need to delete a number of rows that contain a certain value in column X. Then, if I make a loop with the ExcelData I can be, approximately, 3 hours waiting, so it is not effective at all...

So I wonder if there's a way to get the row in question by some condition or if some where clause can be applied to the search.

I'm waiting for a response from the community. Thank you in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What if we filtered for a value and then deleted all visible rows from row 2 to the end; would that work?

If so, I recommend creating an Excel VBA macro. The bot can run the macro. This takes a little bit of knowledge, but it's not a horrible amount of knowledge, and the VBA macro is going to take seconds vs any solution with PAD which, like you said, will take hours.

Was this reply helpful? Yes No
jtorfila 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello, MichaelAnnis

After a whole working day behind this issue, I have managed to solve this issue by reading the Excel file using a connection to SQL. This way, it allows me to launch queries using the where clause and thus, I can filter by the column I am interested in and delete directly.

Nevertheless, thank you very much for your answer.

Was this reply helpful? Yes No