Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Alert an admin if data was exported to excel

Posted on by 873

Hello,

Will it be possible to set an alert or trigger a workflow if a user tried to export data through Excel from CRM and notify the managers through email?

If it is not possible, can we restrict access to the export excel feature on the table level?

Please provide some examples of the possibilities.

Any help is highly appreciated.

Best regards,

EBMRay

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Alert an admin if data was exported to excel

    Hello,

    If my reply (or replies) answers your question take a minute and verify the answer. You can do it by clicking "Yes" at the top of the reply (or replies) under the label "Does this answer your question?"

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Alert an admin if data was exported to excel

    You can start here - learn.microsoft.com/.../tutorial-write-plug-in

    Here is ParentContext property I mentioned - learn.microsoft.com/.../microsoft.xrm.sdk.ipluginexecutioncontext.parentcontext

    Here is MessageName property I mentioned - learn.microsoft.com/.../microsoft.xrm.sdk.iexecutioncontext.messagename

  • EBMRay Profile Picture
    EBMRay 873 on at
    RE: Alert an admin if data was exported to excel

    Hello a33ik ,

    It is easier by restricting users from Export to Excel, but that will prevent it from all tables.

    The plugin approach you suggested is the best one.

    Would you be able to give me a small example of where I can get started?

    Thank you Andrew!

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Alert an admin if data was exported to excel

    Hello,

    Isn't it easier to disallow users to export the data?

    pastedimage1665071103786v1.png

    There is a privilege for it.

    The only solution that I see is to develop a plugin that will handle "RetrieveMultiple" message, check the ParentContext's message, and if it is "ExportToExcel" - throw an exception.

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