Answered

Deleting duplicates in SharePoint list

(0) Share

Report

Posted on by force_field

I have a flow that would create duplicate items in a SharePoint list. There could be 2, 3, or 4 of the same item after each approval process depending on the number of approvers for that flow.

I would like to create a new flow that would check for duplicate items and remove them, retaining only 1 item in that list.

Hope someone could guide me how to achieve this. Thanks very much!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @force_field

Try the following:

Use trigger as 'When ever an item is created'. Then use 'Get Items' filtered by Title or your specified identifier. Then add next action step as IF condition to check the count of the result is greater than one. Use the below expression

length(body('Get_items')?['value'])

Next add a for each loop to iterate all the list values.

Again add another IF condition to check the created date is not equal to newly created record (map the created date from the trigger). This way it won't delete all the records except the latest created.

Finally use the Delete Item to delete the duplicates.

Thanks

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (1)

Report
Copy link

Link copied!

Hey @force_field

The best option here is not to create the duplicates in the first instance... then you don't need to create another Flow to delete them 🙂

I'd suggest adding a SharePoint 'Get Items' action to check whether an existing item exists... and only create a new item if an item doesn't exist.

HTH

Jay

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @force_field ,

Could you please share a screenshot of the sharepoint list items?

Does the duplicates list items has the same title? And does the title of the list item would always unique?

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (0)

Report
Copy link

Link copied!

@abm
Hello, Need workflow help.
Task: Find a Duplicate item from List B and change the status column value to a 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.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Dhaval2002p

Could you please create a new thread for this please?

Thanks

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (0)

Report
Copy link

Link copied!

Created

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Find-duplicate-from-the-list-b-and-update-choice-status-to/m-p/2066193#M24160

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (1)

Report
Copy link

Link copied!

I created

Was this reply helpful? Yes No
trugita 2 on at

Like (0)

Report
Copy link

Link copied!

Hey Jay - I know this is super old, but any chance you can go through the process here? I'm cool with using "Get Items" action to check for existing items, but not clear on how to only create a new item if an item doesn't exist.

Thank!

Was this reply helpful? Yes No