Hi, is there a way to check for duplicate IDs and delete the one entry if it exists?
I tried something below but was unable to get it working - I was attempting to create a list. Would concat or join even work or am I completly going this the wrong way? Thank you!
If you just want to find & mark duplicates, then you could load this template & remove the last delete step:
Hello, Need workflow help.
Task: Find a Duplicate item from List B and change the status column value to Duplicate item
We receive work from List A to List B
I work on List B. I created a Choice column called status- and I added choices of New item, Duplicate item, completed, and Under review.
Sometimes we receive duplicate items in List B from List A, I would like to identify those duplicates every time when a new item is created in List B and I want to change the status to Duplicate item if the manufacturer’s part number is matching.
Hello, Need workflow help.
Task: Find a Duplicate item from List B and change the status column value to Duplicate item
We receive work from List A to List B
I work on List B. I created a Choice column called status- and I added choices of New item, Duplicate item, completed, and Under review.
Sometimes we receive duplicate items in List B from List A, I would like to identify those duplicates every time when a new item is created in List B and I want to change the status to Duplicate item if the manufacturer’s part number is matching.
Hi @Brad_Groux
This is great. I am looking to do something similar and wondered if you could help. I would like to identify duplicates in my list based on the email column, but I don't want the flow to delete them. Instead I would like to be presented with a view of the duplicates, either in SharePoint, Excel or any other way that is possible so that I can review the two records and manually choose which one I'd like to delete/keep.
Is that possible?
I think I figured it out. I replaced Sort ID by Email in my list, because it was a user list, and I knew if there were 2 of the same email it would be a duplicate. You can use whatever field that would show you it was a duplicate.
Now when running, it creates a list of all the items the first time it sees them, "if No" add it to the array. Then when it sees them again it's already got them in the list and it runs the "If Yes". I hope that helps someone else.
@Brad_Groux @Anonymous how would the above 'Apply to each' configuration change to delete all rows in an excel sheet?
Please suggest
Brad,
Could you please explain why this works? I tried this, and it does indeed work, but honestly I can't understand why it works.
Thanks!
@Anonymous is on my team, and he and a teammate were able to accomplish checking for, and deleting duplicates in a list utilizing a Flow that looks like so:
If you have an questions about further about how we accomplished this, pleaset let he or I know. Otherwise, marking this question as solved.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
stampcoin
14
Churchy
12
rzaneti
8
Super User 2025 Season 1