Skip to main content

Notifications

Dynamics 365 general forum
Unanswered

Export Duplicates Detection job results to Excel

Posted on by 2,651

Hi all,

Looking for a way to export the results of a duplication detection job for Leads to Excel, including the critical GUID, Checksum, and Modified On fields so that the unwanted records can be more easily removed and then the resulting set of records can be re-imported to update the entity.  The idea being I would add data in an otherwise unused field for the unwanted dupes and I would then be able to use bulk delete to get rid of the unwanted dupes based on that field containing data.

  • AriaConsulting Profile Picture
    AriaConsulting 2,651 on at
    RE: Export Duplicates Detection job results to Excel

    Yeah.  There's a dedupe app in the toolbox, but the results from it don't align with the dupe check in 365.  But the data in that job run is persistent, which means it has to "persist" somewhere. I'm hoping someone knows where and then maybe I can use Excel or toolbox or power query or something to get at it.  I've got about 500 dupes to work through and if you've ever tried using the OOTB UI for it, you know that it was some sick sadist at MS that designed it!

  • edmunch Profile Picture
    edmunch on at
    RE: Export Duplicates Detection job results to Excel

    I do not think there is a way to perform this action OOB, not even using Advanced Find.  Have you looked at options using XRM Toolbox?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans