Export Duplicates Detection job results to Excel

(0) Share

Report

Posted on by AriaConsulting

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.

Categories:

Integration with Other Products

Dynamics 365 Administration

Other Functionality

All responses (2)

Answers (0)

AriaConsulting 2,651 on at

Like (0)

Report

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 on at

Like (0)

Report

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?