Microsoft Dynamics CRM (Archived)

How can I remove duplicates in Dynamics CRM?

(0) Share

Report

Posted on by Community Member Microsoft Employee

I want a custom filed of Account to be unique. So I need to remove the duplicate record.

Can you tell me easy ways to approach this?

*This post is locked for comments

All responses (7)

Answers (1)

Anandhcrm 524 on at

Like (0)

Report

RE: How can I remove duplicates in Dynamics CRM?

You have to do manually. Otherwise, you can create a c# console application, search for each distinct emailaddress, then delete the records.
Mohammed Fakhri 402 on at

Like (0)

Report

RE: How can I remove duplicates in Dynamics CRM?

Hi Aileen,

This only removes one duplicate record at a time. What if we need to remove all duplicates at once? Is it even possible?
Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I remove duplicates in Dynamics CRM?

Custom fileds are not supported with the default functionality. You might want to have a look at www.duplicate-detection.com (Certified Microsoft ISV add-on)
Betty Well 5 on at

Like (1)

Report

RE: How can I remove duplicates in Dynamics CRM?

iMyMac's Mac Cleaner can help you find the duplicateVideos, Music, Images, Documents...and to clean up.And iMyMac's Mac Cleaner software is free to use!
Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I remove duplicates in Dynamics CRM?

We using the new power Apps. how can I run the duplicate seacht there
Suggested answer

Aileen Gusni 44,522 on at

Like (0)

Report

RE: How can I remove duplicates in Dynamics CRM?

If you are using onPremise and need complicated filter criteria, what I did last time is I create a SQL Query then I update a flag field isduplicate to 1, then I use Bulk record deletion job in CRM by deleting records with flag isduplicate = 1 or Yes.

This is unsupported and only works for OnPremise, but this is faster, yet more complicated.

Hope it helps!

Thanks.
Verified answer

Aileen Gusni 44,522 on at

Like (1)

Report

RE: How can I remove duplicates in Dynamics CRM?

Hi,

For the easier way, you can use Duplicate Detection:

Go to Settings --> Data Management, and find Duplicate Detection Rules, create your detection rules:

Set the field criteria that you want.

Save it and publish to activate.

Then, go to Account view, and run your duplicate detection

After that, you go to the Duplicate Detection Job (Settings --> Data Management)

Then see the duplicate detection job, then you will see the potential duplicate record:

Then, you can delete the Potential duplicate record, you can see the X ribbon.