Answered

Filter Duplicate rows

(0) Share

Report

Posted on by kiran_g

150

I have an Excel file on OneDrive with duplicate data in the HR column. As a result, I have to copy the highlighted yellow rows and paste them into a new sheet. For example, if the HR Column contains 1Jyothsna, 2 Meghana, 3 Priyanka, 3 Neha, and 1 Samuel, I have to copy the rows 1Jyothsna, 1 Meghana, 1 Priyanka, 1 Neha, and 1 Samuel. (PAD)

File 1.PNG

File 2.PNG

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

NathanAlvares24 1,714 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @kiran_g !

My table in excel worksheet:

You can try out the following flow:
I used a list to store the HR column data. So loop and increment by 1 for each HR column data using %ExcelData[LoopIndex][2]%.

Result:

So I haven't extracted the file from the OneDrive for this flow. I am assuming that you have done that. But I hope the logic is correct. Hope this helps.

Regards,
Nathan Alvares
----------------------------------------------------------------------------------------------------------------------------------------
If this helps & solves your problem, please remember to give a "Thumbs up" and "Accept my solution" as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @kiran_g

Another simple approach you can try 🙂

Here for demo purposes, i have created the datatable using create datatable action like below

Now using run.net script action i wrote a linq query which group by HR column and take first values out of it and store the results in a datatable like below

References to be loaded field should have folder path where required dll files are stored

input and output arguments looks like below

Script should be like this

Output from .net run script should be like this :

I hope this is as expected.

For more details on how to run a linq query follow the steps as below

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
kiran_g 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Nived_Nambiar

Was this reply helpful? Yes No