Read data in filtered Excel file

(0) Share

Report

Posted on by SeanLin

I get the free row and column and can read the data one by one. But how can I read the filtered Excel?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Filters in Excel are ignored by PAD. The entire data regardless of filters will be extracted. You will need to read it and apply the filters in the flow afterwards.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

CU31080729-3 502 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,SeanLin
you can fallow this step
1) launch excel
2) read from excel worksheet (output-excel data)
3) then used loop action for iterating one by one excel row of excel data(excel data)
4) close excel
( note:- if you got your solution then you can mark as solution and gives kudos or thumbs )

thanks & regards
Chetan Ninghot

Was this reply helpful? Yes No
SeanLin 55 on at

Like
a
(0)

Report
Copy link

Link copied!

@Agnius Thank you.
@Chetan_Ninghot That's what I did. But the entired data is kind of huge. It wastes a lot of time to read the useless data. Thanks anyway.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!

There is an Excel command called “select visible cells only.” You can add this to your quick actions (like where print preview is).

Have the bot, select the data, click this button, paste the data in a new workbook, and use the new workbook to extract the data.

Was this reply helpful? Yes No