Answered

Filter Rows using the value then copy & paste it another sheet in PAD

(0) Share

Report

Posted on by kiran_g

150

if there is "Completed" in a Status column then copy those rows and paste it into new sheetn copy those rows and paste it into new sheet

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Fst use launch excel to open
Then read excel sheet and store in to a data table
Then use for each
We get current item
Use if activity
If curremtitem[status] is equal to completed
write to excel sheet
In that you give write value as current item

Was this reply helpful? Yes No
kiran_g 150 on at

Like (0)

Report
Copy link

Link copied!

Can we use Linq queries in PAD? It'll take time to process by using For Each

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can do it via the Run .NET script action.

-------------------------------------------------------------------------
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
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @kiran_g

As @Agnius suggested you can use Run .net script action to run linq queries on your dataset.

For details, refer the below link for the article which details how to run linq query using Power Automate Desktop using Run .NET script action.

https://www.linkedin.com/pulse/how-run-net-script-action-empowers-data-table-power-automate-bysani/

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No