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?

  • do you have the any workflow on the list or any other customization? – Waqas Sarwar MVP Apr 28 '15 at 19:28
  • another thing, i am thinking if you enforce Uniqueness on the JPPNum column then duplicate can avoide – Waqas Sarwar MVP Apr 28 '15 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. – Matt Ludwig Apr 28 '15 at 19:35

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
  • what kind of workflow would it be? – Matt Ludwig Apr 28 '15 at 19:32
  • Not sure you can check List Settings -> Workflows and see what all workflows are associated – Amal Hashim Apr 28 '15 at 19:33
  • where would the ps script go – Matt Ludwig Apr 28 '15 at 19:33
  • You need to login to Server and open SharePoint Management Shell and execute it – Amal Hashim Apr 28 '15 at 19:35
  • I don't have access to the management – Matt Ludwig Apr 28 '15 at 19:36

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));


  • I did option 1 and theres 300 duplicates but scarrtered through out the view. so theres no way to do a specific filter – Matt Ludwig Apr 28 '15 at 19:39
  • also check this one stackoverflow.com/questions/21331530/… – Waqas Sarwar MVP Apr 28 '15 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. – Matt Ludwig Apr 29 '15 at 13:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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