Unanswered

Remove Duplicates from SP List.

(0) Share

Report

Posted on by StuartSmith

225

I have a SP list that due to a bad flow that previously ran, now has multiple duplicate rows. I spent all last night trying to find a solution on the web, but any that I found, I either couldn't get to work or couldn't modify to fit my issue and therefore hoping someone can assist.

The table looks something similar to the below, but with only 1 row for each entry. Can anyone please help.

Thanks in advance.

Agent	Call Type	Comments	Date/Time	TextName
John Doe	Type 1		01/01/2024 12:34PM	Doe, John
John Doe	Type 1		01/01/2024 12:34PM	Doe, John
John Doe	Type 1		01/01/2024 12:34PM	Doe, John
John Doe	Type 1		01/01/2024 12:34PM	Doe, John
John Doe	Type 1		01/01/2024 12:34PM	Doe, John
John Doe	Type 1		01/01/2024 12:34PM	Doe, John
Mike Smith	Type 3	Failed	09/02/2024 15:09	Smith, Mike
Mike Smith	Type 3	Failed	09/02/2024 15:09	Smith, Mike
Mike Smith	Type 3	Failed	09/02/2024 15:09	Smith, Mike

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did you already try this downloadable template?

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/td-p/2191403

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

I tried this earlier and it started to reduce the rows of the SP list from about 20,000 and thought awesome. Then the row count passed my expected duplicate row count and continued to drop. I then got in denial and thought maybe it removes all the rows and then re-adds the distinct row, but no, it kept dropping until my SP list had 1 row! 😂 I now need to figure out how I am going to get all the rows back.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@StuartSmith

What kind of column(s) did you try to use to mark the duplicates?

Was this reply helpful? Yes No