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.
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!
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?
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,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148