Read from excel Variable when it is filtered or any other option

(0) Share

Report

Posted on by Hana123TEI

I am trying to create a flow where my excel is filtered based on Category.

and I have to copy these filtered rows and paste to other worksheet.

I am trying to use read from excel but the rows are dynamic , so is there any way or variable I can make when the sheet is on filtered mode. as the row sometimes start from B3 or the next time start from B7 and same way end to B 10 OR b 20 how can I achieve this .

Any help will highly be appreciated.

Regards,

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Hana123TEI Refer this https://www.matthewdevaney.com/power-automate-desktop-read-filter-excel-with-sql-query/ and follow the approach.

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Hana123TEI 49 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ankesh_49

Thank you so much for sharing the link, I somehow created based on the link but don't know how to get only required columns by sql query...and then paste those columns in other worksheet.....is there any other solution ....

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ok perfect. Now the heavy loading part is done. Its only the SQL queries which you want help with, refer this video:
https://www.youtube.com/watch?v=ZENLOah5G2E

It should solve your purpose. Let me know in case of any issue.

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
XRQ57 206 on at

Like (0)

Report
Copy link

Link copied!

Hi,
why don't you use Power Query for your filters?
-> Upload your table in power Query, apply your filter and load your new table filtered for PAD.

Was this reply helpful? Yes No