Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Deduplication check that is organisation wide

Posted on by 505

Hello community,

OOTB duplicate detection only looks for similar records within the reach of the logged in user's security role. That is if a user has visibility only on records within his/her BU then the duplicate check will also be done only on records within that BU. What I need is a check that goes beyond the logged in user's reach. Any ideas on best way to do this?

Regards

CRMYogi

  • cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Deduplication check that is organisation wide

    Hi CRMYogi,

    Please let me know whether you have any doubt or question to the method.

    Another method is also impersonation but it could perform by javascript code, which would be easier than deploying backend plug-in.

    (your crm version is required to upper than 2016 to support the feature)

    I'm waitting for your thought.

    Thanks.

    Regards,

    Clofly

  • cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Deduplication check that is organisation wide

    Hi Partner,

    There is a method in plug-in which could Impersonate a user to execute action.

    https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/impersonate-a-user#during-plug-in-execution

    In your scenario, you could build a plug-in(custom workflow when record is created),

    it will impersonate sysadmin to query all records in CRM, if any duplicate record was found,

    then throw an error to tell client user that the record has existed in whole organization,

    so you should run the it at organization level.

    You could read article below for details:

    https://ashwaniashwin.wordpress.com/2013/09/15/crm-2011-plugin-to-show-alert-for-duplication-with-impersonation/

    Due to we just need input parameters as filter to retrieve records in crm, so it's up to you to use fechXML or queryExpression.

    Regards,

    Clofly

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans