Filter Duplicate rows

[kiran_g]

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)

[NathanAlvares24]

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.

[Nived_Nambiar · Accepted solution]

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! 🙌

[kiran_g]

Thank you @Nived_Nambiar