Deleting The Oldest Duplicate Item in a Sharepoint List

[diegothompson12]

Need Help on deleting the oldest duplicate item in a SharePoint list. So, every time I get a duplicate I want to update and remove the old record. 

Would like the top record to be deleted! 

If somebody could help me that would be awesome!!!

[ManishSolanki]

Hi @diegothompson12 

Please mentioned the triggering condition when duplicates are to be identified and process and share more details on use case.

Thanks

[diegothompson12]

Hi @ManishSolanki 

what I have rn:

My Error:

[diegothompson12]

Hi @ManishSolanki 

 I have another SharePoint list connected to this list and it converts calculations to a couple of new fields. The issue is every time the form is edited it makes a duplicate result. I wanted to delete the oldest result of the duplicated item so that it shows the most recent result.

[ManishSolanki · Accepted solution]

Hi @diegothompson12 

Please refer the sample flow to delete the duplicate records based on Job number:

1. When a new item is created, using filter query we will check if any duplicate record exists (excluding the current item):

Filter query used here, just paste in the filter query:

JobNumber eq '@{triggerOutputs()?['body/JobNumber']}' and ID ne @{triggerOutputs()?['body/ID']}

2. Next, we will iterate the duplicate items and delete them using 'Delete item' action:

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[Eryoun0]

How do I skip the newest and not delete it, but all the others. I'm not quite following where this is answered or I am missing it. 

[Eryoun0]

I think I am missing this point and the order by, needing it to be ordered by newest to oldest. Then the delete would remove the duplicates under the newest?

[Eryoun0]

"Created asc" typed in worked. Problem solved. 

[diegothompson12]

@Eryoun0 how you did you delete the old record and not the new. Because mine keeps deleting the new record and not the old one.  

[Eryoun0]

In the Get Items, the Order By, type "Created asc" to order it by ascending. 

[diegothompson12]

@Eryoun0   Darn it still keeps the old record for me but thanks for the help

[diegothompson12]

@ManishSolanki hello I followed your procedures, and it deletes duplicates but deletes the newest record not the oldest. Any suggestions 

[ManishSolanki]

Hi @diegothompson12 

Could you pls share the screenshot(s) of the flow in edit mode?

[diegothompson12]

@ManishSolanki Here is my flow:

My flow while running: 

Like I said it keeps only deleting the newest record and not the oldest record I added a top count of 1 and Order by Created asc which was recommended but got same results!

[ManishSolanki · Accepted solution]

Hi @diegothompson12 

Pls verify if you are passing the ID from the output of get items in "Delete item" action but not from the trigger as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.