Support Portal ContactGet in touch

Defining DocMan Entities with multiple potential Parent Relationships

   Words by Paul McQuillan

   on 28/01/2019 08:00:00

DocMan supports a definition of a Parent Map for each Dynamics Entity we want to integrate with SharePoint.

This Parent Map allows us to define the Folder or Document Location for a child record (say a Contact) in relation to a parent record (say the Company associated to that Contact), so we can benefit from the Hierarchical nature of SharePoint for managing our Documents.

But what if we have the scenario where a Record could have several different types of Parent?

If we take the example of a Custom Entity added to Dynamics for a ‘Decision’ and that this Decision could have a Child-to-Parent relationship with a number of other entities:

  • The Decision could be linked to a Parent Investment
  • Alternatively, the Decision could be linked to a Parent Agenda Item
  • Or the Decision could be linked to a Parent Action

This would involve either the Decision being defined as a Custom Activity Entity in Dynamics with the Regarding Object relationship that can relate to many different types of Entity – in which case, DocMan can handle this in the way we handle other types of Activity.

But if Decision is not a Custom Activity Entity then we will find ourselves with 3 different Relation / Lookup Fields in Dynamics:

  • Lookup to Investment
  • Lookup to Agenda Item
  • Lookup to Action

And we need DocMan to read the right Relationship to determine which should be used as the right Parent Record Type for the Decision.

To do this, we need multiple Parent Maps for our Entity.

We can configure this arrangement in DocMan by browsing to the DocMan Configuration Area, into the Entity we want to configure, and then stepping through the following steps:

1. Remove the Primary Parent Map - First of all, removing the Default Parent Map field so this is blank.  This removes the idea of a Primary Parent Map in favour of a decision tree for which Parent Map to use for a Decision.

image

2. Multiple Parent Maps – each Entity Definition in DocMan has a number of Maps or Rules connected with that Entity.  In this list, we can add multiple new Parent Maps, one for each Relationship/Lookup Field in CRM that we want as a potential Parent Relationship.

image

Here we can add Mappings to define the logic for how we want the Entity to behave based on the Fields populated in CRM.

3. Add Additional Parent Maps – We can add new Maps here to define what Lookup Fields will be examined and which Entity to then Lookup to.

image

image

This then defines our logic which we can test by adding Decisions to Dynamics.

4. Decision connected with an Investment – where we have a Decision linked to an Investment, this then adds the Folder to store Documents on the Decision to the existing structure defined for that Investment Record:

image

/sites/dynamics365docs/Investments/abraaj financial technologies holdings limited/Decision C

With the bold portion of the SharePoint Address being derived from the Investment, and the final Folder from the Decision.

5. Decision connected with an Agenda Item – where we have a Decision linked to an Investment, this then adds the Folder to store Documents on the Decision to the existing structure defined for that Investment Record:

image

/Management Committee/Committee Documents/2019/mc-25-2019/05.00 - crm training/Decision for Agenda Item

This allows the same Entity Type in CRM to hook into different SharePoint structures depending on the Type of Parent Record involved – and can be useful for keeping our Documents well organised for types of records that may be related to multiple types of record in CRM.

This can work well in environments where we have multiple SharePoint Sites or even different SharePoint Instances as doubles up with DocMan’s ability to connect more than one SharePoint Site into Dynamics.

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.