RE: Duplicate Contacts in Dynamic Marketing List
Hi,
Thank you for your query.
I assume when you say "Duplicates", you have multiple contact records with same email address.
If that is the case, you can't remove duplicates (based on a certain field like email) from a marketing list.
To fix this problem, you have to clean your data.
Either merge duplicate contacts or remove the wrong ones.
If for any reason, you need to keep both, add a flag on the contact entity, for example, IsDuplicate.
Then write a script/ETL package to update every duplicate contact and set this flag to Yes.
Then in the Marketing list, add a filter to remove contacts (where IsDuplicate equals Yes).
For example:
- Contact 1:
- Name: John Doe
- Email: jd@example.com
- Is Duplicate = false
- Contact 2:
- Name: Joe
- Email: jd@example.com
- Is Duplicate: = true
However, I strongly suggest to work on your data, you can merge the duplicate contacts:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/merge-duplicate-records-accounts-contacts-leads?view=op-9-1
Also setup Duplicate Detection Rules to avoid such issues:
https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
