Support Portal ContactGet in touch

Presenting DocDrive365 at Future Lawyer Week

   Words by CRM Consultancy

   on 03/06/2019 11:01:00

imageWe were pleased to demo DocDrive365 at the Future Lawyer Week in May 2019, and covered how we think Apps in the Microsoft Cloud will increasingly become the basis of Corporate and Legal Solutions.

Both Apps built internally by Citizen Developers, Consultants and PowerApps working together -  and Commercial Apps built by Developers such as ourselves to provide specific functionality to the Cloud.

In our case, using the DocDrive365 for Dynamics App to integrate Dynamics 365 and SharePoint using no-code Configuration.

We demonstrated how this could be done using DocDrive365 working with Dynamics and SharePoint in the Cloud, covering several areas of DocDrive365 functionality:

  • Making Document Management simple to promote self-governance

  • Easy Drag and Drop of Documents into particular Content Types and Folders

  • SharePoint Sites mirroring the Hierarchy of a Dynamics Group Account

  • Tracking Documents between Clients, Engagements and Legal Matters

  • Keeping Data in our Security Envelope - Sharing Documents internally and externally via Links and not Attachments

  • Integration with Email to avoid searching your Inbox and getting Attachments into Managed Storage.

This then focused on how we can configure DocDrive365 in real-time using no-code configuration – looking at how we could take a Custom Entity for Project and configure this to work with SharePoint using Modern Team Sites  and Subsites.

The following guide details how was done and gives further information on this configuration within DocDrive365.

Configuring Projects in Dynamics to work with DocDrive365

Say we have a new Entity that we have created in Dynamics to track Projects, and we want to store and manage Documents in SharePoint for our Projects.

Our first step would be to navigate into our Configuration of DocDrive365 and define how Projects would work with SharePoint.


Creating a New Metadata Entity in DocDrive365

We can then define what we want to happen in SharePoint when we add a new Project in Dynamics:


Defining how the Project Entity should work with SharePoint

This allows us to define:

  • Parent Map [Symbol] Which SharePoint Site should be used for storage of Documents for Projects

  • Lookup Map [Symbol] Should we ‘look-up’ to a Parent Record such as a Client Account to configure hierarchy storage.

  • Bucket Map [Symbol] Should we have a Category or ‘Bucket’ Site, Library or Folder to help divide types of Project.

  • Dynamic Map [Symbol] The Site, Library or Folder that should be created for the Project.

In our example, we want three main rules here:

  • Use a particular SharePoint Instance for Project Documentation that is entirely separate from our Client Documentation – so we use a Parent Map to establish this.

  • Ensure we have a new Team Site for each Type of Project we work with – so we use a Bucket Map to create a Team Site per Project Type

  • Ensure we have a Subsite for each new Project – using a Dynamic Map to create a new Site per Project.

We can see how this is defined in the following two rules for the Bucket Map and the Dynamic Map:


This defines that we will have a New Team Site / Site Collection per Type of Project added to Dynamics – as defined by the ‘crmcs_projecttype’ Dropdown Field we have in CRM.

Location Type as ‘Modern Team Site’ – this defines that we will have a new Team Site per Project Type, and so use SharePoint in the Cloud to work with Microsoft Teams.

Template / Fixed Value as {0}{strip} - DocDrive365 will take this field, strip the spaces and use this as the URL of the SharePoint Site Collection

Location Title as {0} – DocDrive365 will set the Title of the Site Collection as the Project Type.

Location Description as ‘Project Type Area’ – this defines the Description for each Team Site.

This defines our we want each Project Type to work within SharePoint, and we can then turn to each Project in the Dynamic Map:


This defines that we a New Site for each Project added to Dynamics:

Location Type as ‘Site’ – this specifies a Site per Project created.

Template / Fixed Value as {0}{strip} – specifies the URL of the Site as the ‘crmcs_name’ of the Project with spaces stripped.

Location Title as {0} – specifies the Title of the Site as ‘crmcs_name’ including spaces.

Location Description as ‘SharePoint Area for Project Documents and Collaboration’ – specifies a fixed description for each Site created for a Project.

This builds our configuration for the new Project Entity in a relatively simple fashion, and crucially involves no-code to allow Citizen Developers to configure and control how Dynamics integrates with SharePoint.

With this in place – we can start seeing this in action!


Creating a New Project Record in Dynamics

With each Project we add into CRM, we can now navigate into Documents and start working with Documents stored in SharePoint from within CRM.


We can then see how this has worked by clicking the LOCATION button to navigate into SharePoint:


The Site for the Project – with the option to click up into the Site Collection for Commercial Law as the Project Type


The Site Collection for the Project Type – with connection to Microsoft Teams as required.

This results in the right combination of Sites, Libraries and Folders alongside Teams to best suit how we want to work with Documents alongside Dynamics CRM.

We demoed this Configuration to Solution at the Future Lawyer Week in London as our showcase of DocDrive365 – for further detail, please do not hesitate to get in touch to arrange a demo with one of our team.

If you attended the #FLW2019, then thank you for your time in our demo, we hope it was useful in showing what Apps in the Microsoft Cloud can do for Legal Tech, and hope to see you there next year!

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
M1 6EQ

London Office
CRM Consultancy London
Grosvenor Avenue

Content © CRM Consultancy.