Unanswered

filter csv data before entering foreach

(0) Share

Report

Posted on by douglasabreu

120

how could I filter to have, before starting the interaction, only the lines that I want to carry out the process, I'm doing an if but it just skips and is time consuming, I want to get only the lines in which a column has a certain data as in the example of Image. it's like a filter in pandas in python, or even in sheets. is there a way for me to do this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @douglasabreu

There is no direct filter option available.

However you could use the Excel sheet as a database and write a SQL query to filter the required rows.

Some examples are like:

- the 3rd post from the top

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Filter-a-an-excel-doc-Power-Automate-Desktop/m-p/1365044

- https://powerusers.microsoft.com/t5/Power-Automate-Desktop/split-a-big-Excel-sheet-into-multiple-csv-files/m-p/966859#M4686

Was this reply helpful? Yes No
XRQ57 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
you better use Powerquery to prepare your file.

Was this reply helpful? Yes No
douglasabreu 120 on at

Like
a
(0)

Report
Copy link

Link copied!

entendo as colocações, sei que eu poderia fazer isso do jeito que mencionaram, afinal está vindo do sheets direto via download from web, eu poderia fazer isso lá, mas pensei que eu pudesse fazer isso sem acionar algo externo, usando um action interna.

Was this reply helpful? Yes No