1

For some reason when a user is adding a record, it duplicates it three times.

Why is that happening?

enter image description here

Since there is many How can I remove any records that contains a duplicate in a specific column?

3
  • do you have the any workflow on the list or any other customization?
    – Waqas Sarwar MVP
    Commented Apr 28, 2015 at 19:28
  • another thing, i am thinking if you enforce Uniqueness on the JPPNum column then duplicate can avoide
    – Waqas Sarwar MVP
    Commented Apr 28, 2015 at 19:32
  • I was thinking that but I already have a lot of duplicates, which I need to remove first. so I can do the unquiness option. Commented Apr 28, 2015 at 19:35

2 Answers 2

2

Two possibilities

  1. A workflow
  2. Event Receiver

Workflow you can check using SharePoint Designer.

Event Receiver - You can download SharePoint Manager and connect to SharePoint server or you can use below PS script

$site = Get-SPSite -Identity "http://siteurl"
$web = $site.RootWeb
$list = $web.Lists["ListName"]
$list.EventReceivers | Select assembly, name, type
5
  • what kind of workflow would it be? Commented Apr 28, 2015 at 19:32
  • Not sure you can check List Settings -> Workflows and see what all workflows are associated Commented Apr 28, 2015 at 19:33
  • where would the ps script go Commented Apr 28, 2015 at 19:33
  • You need to login to Server and open SharePoint Management Shell and execute it Commented Apr 28, 2015 at 19:35
  • I don't have access to the management Commented Apr 28, 2015 at 19:36
0

Looks like you have some kind of Workflow or Event receiver can cause this issue.

you can avoid this in future to implement the Uniqueness on the column.

Enforcing Uniqueness in Column Values

Now to remove the Duplicate values from list, couple of options.

Option # 1

  • Make sure all item are at least major version and checked in.
  • Create a fresh view without any filter and display all claims.
  • Export to excel
  • Try to to run excel ->Data -> Remove duplicate
  • See is there any duplicate removed or not

Option # 2

Please try to open this list as access(link in IE) and run this query in access

SELECT Claim.[Claim Number], Count(*) AS Expr1
FROM Claim
GROUP BY Claim.[Claim Number]
HAVING (((Count(*))>1));

https://social.msdn.microsoft.com/Forums/office/en-US/1fbe7492-418d-4242-a9d3-ee550115affe/this-field-contains-duplicate-values-remove-all-duplicate-values-and-try-the-operation-again?forum=sharepointcustomization

3
  • I did option 1 and theres 300 duplicates but scarrtered through out the view. so theres no way to do a specific filter Commented Apr 28, 2015 at 19:39
  • also check this one stackoverflow.com/questions/21331530/…
    – Waqas Sarwar MVP
    Commented Apr 28, 2015 at 19:40
  • Does anyone know why when a certain user adds a new record, it is being duplicated but it happens randomly. no event receiver or workflow. Commented Apr 29, 2015 at 13:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.