Support Portal ContactGet in touch

Using DocDrive365 to integrate Security from Dynamics to SharePoint

   Words by CRM Consultancy

   on 12/10/2018 11:18:00

imageThe security models in Dynamics and SharePoint work under quite different models, and this means there is no out-of-the-box integration to keep Security for Documents in-sync with Security in CRM.

So we often have a common requirement to bring the two systems together and have a manageable security model between the two.

DocDrive365 enables functionality in Dynamics that allows us to synchronise permissions from CRM and publish to SharePoint, for both Users and also for Teams.

The following article shows how to activate this in Dynamics and DocDrive365 , and then look at next steps in how to make use of this functionality.

Step 1 – Choose the Model of Dynamics to SharePoint Security

We can open the DocDrive365 Config Area in Dynamics and specify how we want security managed between Dynamics and SharePoint – the option we are going to look at in this article is ‘Stakeholders from CRM to SharePoint’ and so we set the Permissions Management dropdown to this option.

image

This will by default activate Security for all Document-Enabled Entities in Dynamics.

However if we want to deactivate security for a particular Entity then we can open the DocDrive365 Config for that Entity and set the ‘Set Permissions’ field to NO – this will then deactivate any security synchronisation for Records of that Entity in Dynamics to the corresponding Document Location in SharePoint.

image.

We can now have Security Synchronisation activated for the Entities we want permissions managed between Dynamics and SharePoint.

By doing this, we will then see a Tabbed Format to our Documents Panel within Dynamics – with the default Tab showing our usual Documents Area, and an additional Tab for ‘Access Team’.

image

Step 2 – Setting Permissions by Building the Project Team

With the config in place we can use the Access Group Tab to set the Users and Teams that form the Project Team for this Record in Dynamics, and so should have relevant permissions to the Documents for this Record in SharePoint.

image

This allows us to define the permissions on a Record by Record basis that are then synchronised to the SharePoint Site for this Record in Dynamics.

image

This is great to a point – but ideally we will want some of our Permissions being set from Fields or Workflow in Dynamics rather than forcing a User or Administrator to manually configure the Permissions for each Record.

For this, the logic in DocDrive365 will automatically set certain Users or Teams into the Panel of Permissions for each Record – by default this focuses on the standard Owner field in Dynamics and ensures the Owner is set as a Contributor in SharePoint.

However the list of Users or Teams that are automatically configured (and so shared to the SharePoint Document Location) is configured by either:

  • Configuring ‘Synch-Fields’ in the DocDrive365 Configuration Area to automatically synchronise certain Lookup Fields as Users or Teams shared into the record.
  • CRM Workflow to automatically define the Stakeholder Records, which DocMan will then synchronise through to SharePoint

This then touches upon several other areas between Dynamics and SharePoint Security which will be the focus of follow-up guides:

  1. Configuring Synch Fields for Automatic Permissions beyond just Owner
  2. Unique Permissions for Document Libraries and Folders as well as Sites
  3. Inherited Permissions vs Unique Permissions

    Step 3 – Teams over Users

    As we have seen in the Panel above, we can define both Users and Teams that will have access to the Case in CRM and the corresponding Document Location in SharePoint, however Teams is a far stronger way of managing security between the two systems as this requires less maintenance when New Users join the business or Users leave the business.

    To manage this side, we can define our Teams in Dynamics and view the Publish-to-SharePoint functionality that DocDrive365 introduces:

    image

    Here we can add or remove Users to our Team in Dynamics as we would do normally to define a Team.

    When done, we can check the PUBLIHS Checkbox that DocDrive365 adds to Dynamics.

    This will then publish the Definition of the Team over to SharePoint – defining the Team and so being ready to use in the Sites and Sub-Sites that Dynamics is connected to.

    image

    Using the Team here then gives us stronger maintainability for how security is shared between Dynamics and SharePoint.

    This gives us a useful tool for managing security, however the division of security between Site Collections, Sites and Child Sites then forms a topic all of its own depending on how strict our Security Environment is.

    The following article is focused on Content Types and how these can be defined at different levels in the SharePoint hierarchy, but many of the core concepts also relate to Security in how and where our Security Levels are defined.

    Where’s my Content Type?

    For the moment however we can enable this functionality and begin looking at how this helps us get our Security right between Dynamics and SharePoint, and then look at next steps for more advanced points and automating who is shared on a record or Case.

    Find out more about DocDrive365 here

    Share this Article

    Search Articles

    Filter Articles

    CRM Tech DocMan

    Recent Articles

    CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance Designing and Developing Microsoft Power Apps Portals Thank You for Attending CRMCS’ Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Thank You for Attending Our Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Webinar: Discover How CRMCS Have United Dynamics 365, SharePoint and Microsoft Teams To Create Sales Excellence Ignite your workflow by adding DocDrive365 to Office 365 The CRMCS guide to everything you need to know about integrating Teams with Dynamics 365 Saving Time By Keeping Documents In One Place TDE Database Encryption with On Premise Dynamics The Key to Successful Compliance in 2020 Part 2: Let’s get GDPR Compliant with Microsoft Power Automate Top 3 Essential Tips for Remote Working Dynamics 365 Marketing: Top 5 Best Features Dynamics Day in the Life - Puma Investments Can you use Teams to amplify collaboration in Dynamics? Part 1: Using a Scheduled Power Automate to Trigger Expiry Date Reminders The secrets of successful document collaboration in Dynamics CRMCS launches new AppSource approved DocDrive365 Dynamics Day in the Life - Moneypenny Release Management Add the App to Dynamics DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Building a New Scheduled Process using Flow
    • "Paul has made a real difference to how my team of 24 people record and store valuable customer data and sales opportunities. Highly recommended."

      James, Operations Director

    • "Understanding your business allows us to advise when to implement aspects of CRM and, likewise, when not to."

      Paul McQuillan, Managing Director

    • "Dynamics 365 and CRMCS have made a real lasting difference to our business, allowing us to replace older systems that were holding back our performance."

      Grahame, Chief Operating Officer

    • "James worked well with us to help connect CRM with Outlook and relate how this might benefit our team using CRM for Property Care."

      Natalie, Property Care Supervisor

    • "Matt was really good with helping us run User Testing on the new Compliance Module of our CRM System."

      Tom, Compliance Administrator

    Prefer to go old-school?

    Write to us using the below addresses.

    Head Office
    CRM Consultancy
    61 Oxford Street
    Manchester
    M1 6EQ

    London Office
    CRM Consultancy London
    Grosvenor Avenue
    London

    Content © CRM Consultancy.