Using DocDrive365 for a Documents Roll-up View in Dynamics

   Words by CRM Consultancy

   on 18/10/2018 11:11:00

RollupWe working with Documents in Dynamics we will want to see not just the Documents connected with a particular Record, but all the Documents connected to that Record or any of the Record’s Child Records – the traditional ‘roll-up’ view.

The most typically example is where we have a Company Record in our CRM and want to see all the Documents connected to any of the Projects or Cases for that Company, and so see this full roll-up view of everything connected to this Company.

In SharePoint this can normally be achieved easily using a hierarchy Folder Structure:

image

Example of how SharePoint could be structured using a simple Hierarchy Folder Structure

But what if we do not want to use Folders, and instead want to bring different areas of SharePoint (and maybe even completely different hierarchies!) together and present as a single view in Dynamics?

In this example we may have a structure similar to the following:

image

Example of a more distributed SharePoint structure that we want to bring together when viewing the Documents within Dynamics

Showing this structure in a single view would normally be impossible to achieve.

However DocDrive365 gives us an option to look at how we want to present Documents from multiple areas – this can be implemented by adjusting the Parameters we supply when adding the DocDrive365 Panel Webresource to our Form in CRM.

We can add the following Parameters to the Webresource to implement this as a ‘read_down’ which will show Documents for the Parent Record plus each of the Child Records for that particular relationship:

read_down_entity=exeia_legalmatter,read_down_lookup=exeia_relatedinvestment,read_down_name=exeia_name,read_down_includeparent=true

read_down_entity The Child Entity we want to show Documents for. new_legalmetter
read_down_lookup The Lookup Field from the Child Entity to the Parent Entity new_associatedinvestmentid
read_down_name The Display Name we want to use when describing the Child Entity Legal Matter
read_down_include_parent True or False – do we want to show the Parent Record at all?  Setting this option to ‘true’ will then only show Documents for the Child Records and ignore this Record altogether.  In our example, this would show the Documents for the Legal Matters connected to the Investment, but not show the Documents directly related to the Investment. True

This will then appear in Dynamics showing the List of Documents grouped by the CRM Record that each Document relates to – in this case, the Investment or Legal Matter Records that the Documents are grouped by:

image

This then gives us the Roll-up view of Documents for both the Investment and the associated Legal Matters – even if the Legal Matters are using a very different set of SharePoint Locations in a different Topology to the Investment.

image

This can be useful when we need to show various different record’s documents in a single consolidated view from a parent or master record.

The view here combines with the security model in DocDrive365 to ensure that any Child Records that the User does not have access to are not shown in the list – and so only Documents for the Child Records that the User is able to view are shown from the Parent Record. (in our example, the user only sees the Documents for the Legal Matters that they have access to – omitting any Legal Matters that might be related to the Investment but the User does not have access to)

This article touches on SharePoint Security and how to manage SharePoint Permissions between different Records in Dynamics – a more detailed view of using DocDrive365 to manage security between Dynamics and SharePoint can be found here: Using DocDrive365 to integrate Security from Dynamics to SharePoint

For further information on DocDrive365 as an App to bring Dynamics, SharePoint, Xperido and eSignature together, our Mini-Site can be of use:

Find out more about DocDrive365 here

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

Power Apps Portal Information Hub DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Part 5 - Power Apps Portals: How To Connect Azure B2C With Linked-In Part 4 – Power Apps Portals: Styling Azure B2C for Power Apps Portals The 3 Phases for Using Multi-Select Option Sets in Flow with Microsoft Forms Part 3 – PowerApps Portals: Azure B2C and Power Apps Portals – User Flow for Signup and Signin Part 2 - Power Apps Portals: New Application Registration in Azure B2C for our Power Apps Portal Part 1 – Power Apps Portals: Creating a New Azure AD B2C Tenant The Automation Bot: Launching Contextual Flow from Teams Creating a New Bot for Teams Debugging your Teams Bot using Ngrok Adding a Microsoft Teams URL to a Dynamics Appointment Using Power Automate to Create a New Channel for a Record in Dynamics Connecting your Docusign Account with DocDrive365 for eSignature in PowerApps Showing or Hiding a SharePoint Metadata Column within Dynamics Running a Quick, Quick Campaign from Dynamics Dynamics for Sales: Use Word Templates to Export directly to PDF Newly Generated Documents in Dynamics or Power Apps do not save into SharePoint Synchronising Dynamics / Power Apps Security with SharePoint Adding the DocDrive Bot to each new Microsoft Team Microsoft Team for each Key Account using Conditional Rules in DocDrive365 Azure B2C–the Subscription is not Registered Using Power Automate to Integrate Microsoft Forms with Dynamics 365 CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance
Contact Us

Want expert advice or a demo?

Get in touch now and see how we can help your business grow.

  • Name
  • Email Address
  • Phone Number
 
Close

Understanding Your Challenges

Our strong understanding of CRM and emerging technologies within the Microsoft environment means we deliver the right solutions for you.

Proven Real-World Solutions

As a leader in the field of Dynamics solutions, our pedigree developing and delivering real-world solutions is unsurpassed.

Long Term Support

We provide support beyond our design, implementation and 'go-live' delivery using Sprints and continual updates to our AppSource apps.

CRMCS | Design by Thinktank Marketing | Citrus-Lime Limited

To improve your experience today and in the future, this site uses cookies. Read our full Privacy Policy & Cookie information here I Understand