Hi everyone,
I imported data in Dynamics 365 using Excel templates
Although the Name field is a primary key but I still had duplicates that were added?
Do you have any idea how to avoid duplicates?
Hi everyone,
I imported data in Dynamics 365 using Excel templates
Although the Name field is a primary key but I still had duplicates that were added?
Do you have any idea how to avoid duplicates?
Hi Loic,
Yes, you can use XRM toolbox and then the Duplicator tools,
Just you must click on Load entities, select your match field and then clieck on Find duplicates.
You can also export the duplicates records on Excel file.
Another solution, you can export your records in Excel and then create filters in your Excel file.
Please mark the answer as verified if that's helpful for you.
Thank you,
Can I find out the list of duplicate records in Dynamics ?
Hi Loic,
Two solutions you can use :
1. You create a duplicate detection rule from Data Management in Advanced settings and you add all the criterias that you want.
2. You add a key from make.powerapps.com > Your table > Key
I hope tha's helpful for you.
Please mark the answer as verified if that's help you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,252 Super User 2024 Season 2
Martin Dráb 228,089 Most Valuable Professional
nmaenpaa 101,148