Support Portal ContactGet in touch

DocDrive365 - Day One – Accounts in Dynamics, Folders in SharePoint

   Words by Paul McQuillan

   on 11/11/2019 10:00:00

Once we have the DocDrive App installed into our Tenant of Dynamics 365, we can open the App and start exploring how this integrates Dynamics with SharePoint.

image_thumb2

If we open an Account Record in the App, this will Open the Record via a simple Dynamics Form.

This Form contains the DocDrive Panel, this will ‘peek’ into SharePoint to show the list of Documents for this Account.

DocDrive365 will create the Document Location in SharePoint for the Account when this Panel is first viewed, or when the Account Record is added to Dynamics, whichever comes first.

This ‘peek’ into SharePoint can be viewed in one of two views - first, the DocDrive Panel itself:

image_thumb5

Second, the standard view of viewing Documents from SharePoint in Dynamics:

image_thumb8

Both ways offer the option to open the SharePoint Location directly, and this will Open SharePoint to show how the Documents for that Account are being stored:

image_thumb11

This tells us the SharePoint Location that has been created for the Account.

The initial configuration for DocDrive that comes as from the wizard will create a new Document Library in SharePoint for ‘Client Documents’ and a Folder per Account Record based on the Account Name - a simple default configuration of DocMan.

This configuration can be viewed or edited from the DocDrive365 Configuration element of the App.

image_thumb14

Within here, we would visit the DocDrive Entities Area and open the ‘Account’ Entity Record here:

image_thumb17

This record in the DocDrive App defines how Account records should interact with SharePoint - from the more obvious Entity Settings under Core Actions, to the Rules for what Document Location should be created for an Account.

Here we can see four types of DocDrive Rules for each Entity:

(1) The Record Rule that defines a new Document Location per Record in Dynamics - whether this be a new Folder, Document Library or Site in SharePoint for each Record.

For the initial default config, we can see a Rule here to create a new SharePoint Folder per Record, and name this Folder after the ‘name’ field of the Account Record.

(2) The Bucket Rule that defines a parent or fixed location in SharePoint for the Record Rule to make use of - this could be a Fixed Document Library, a Library based on another field on the Account, or a Parent Folder based on a Fixed or Flexible Field.

In our initial config this is a simple Document Library based on a Fixed ‘Client Documents’.

(3) The Parent Rule that sets whether this Entity should use a Parent Document Location based on a Lookup Field in Dynamics - this allows Document Hierarchies to be built based on the Relationships in CRM.

The initial default for Account does not have a Parent Rule but we will see this later when we look at Contacts, Opportunities or Cases.

(4) The Site Rule that informs which SharePoint Site (from the list defined in Dynamics) should be used.

Leaving this option blank will default to the SharePoint Site ticked in Dynamics as the Default Site.

This gives a walkthrough of how the the initial configuration of DocDrive now services a Record Folder and Bucket Document Library when creating a new Account or viewing the DocDrive Panel for an existing Account.

However these rules are entirely flexible and we can define any set of rules for an Entity in Dynamics that we want to integrate with SharePoint.

We will see this in Day 2 when it comes to looking at the Contacts and Opportunities that relate to an Account.

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

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 Why Teams matters to CRM?
  • "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.