Support Portal ContactGet in touch

DocDrive365 Day Five: Cases and Template Folders

   Words by Paul McQuillan

   on 26/11/2019 10:00:00

We’ve seen three types of Rule within DocDrive’s integration from Dynamics to SharePoint – Record Rules to create a Location per Record, Lookup Rules to build hierarchies in SharePoint from the relationships in CRM, and Bucket Rules to establish common parent folders or Libraries.

An additional element we can configure is the ability for a new Record in Dynamics to automatically create a number of additional folders, libraries or even sites in SharePoint for that record.

This can be useful in certain scenarios where we have one concept in CRM that may have multiple channels of documents to store.

Say if we have an Opportunity to Tender, this may involve tracking information from the prospect, alongside our proposal

In the initial configuration of DocDrive, we can see this in the Case Entity.

So when we first create a new Case – this will result in the following structure:


New Case in DocDrive365’s Default Configuration with Three Automatic Sub-Folders

Our user can then drag and drop documents in each of these four folders to build up the Documents and Files we store for this Case.


Dragging Files and Documents into each of the Sub-Folders for the Case

This can be useful to help sub-divide documents into a logical structure within that single record in Dynamics 365.

We can see how this is implemented in the configuration area of DocDrive365 under the Case Entity.


The default Dynamics-to-SharePoint configuration for the Case Entity in DocDrive365

Initially here we see the core Location Rules for new Records of the Case Entity – which doesn’t tell us about the Child Locations created alongside the Case.

However if we click into the Mappings & Rules Tab of the Configuration Screen, this will show us the additional rules configured for Documents with Cases including any Child Location Rules:


The supporting Mappings & Rules for the Case Entity

We can add new Child Location Rules into this list, or edit/remove the exsisting rules.

These changes will take affect immediately for new Cases added to Dynamics.

(no Cases will be affected retrospectively, as DocDrive will commit the Document Location Records to CRM based on these Rules upon creation of the Case – and will rerun the logic unless the Document Location Records in Dynamics are deleted)

We can see an example of this if we add a new Child Location Rule to create a 4th Folder with each New Case.


Adding a New Child Location Rule to add a Sub-Folder for each Case based on the ‘customerid’ field in Dynamics

This Rule can result in a Fixed Folder such as ‘References’, or create a Folder based from Fields on the Case record.

The example above asks DocDrive to add a Sub-Folder based on the Customer Name for the Case, but this could be any Field in Dynamics if required.

Similarly Conditions can be attached to the Sub-Folder so this is only created when Fields on the Case meet certain values, which this guide will look at when we come to how Rule Conditions are applied for Lookup, Bucket, Record or Child Rules.

With this Rule in place, when we next create a Case, we will see the following:


Folders are often everyone’s starting point for organising documents, as the functionality resembles the traditional network share, but Metadata and Content Types in SharePoint can give us a more powerful and flexible ways of organising our files.

Our next guide in this series will look at configuring Content Types between DocDrive365, SharePoint and Office 365.

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.