Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Export Duplicates Detection job results to Excel

(0) ShareShare
ReportReport
Posted on by 2,655

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,655 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans