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:


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:


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 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:


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.


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

HOW TO: Virtual Entities in Dynamics 365 Release Wave 2 New Feature: The Columns Button HOW TO: Search a date field in Microsoft Dynamics The Relevance Search COMING SOON to Power Apps Portals HOW TO: Manage Your Dynamics 365 Database Size (Video Included) Dynamics 365 Marketing vs ClickDimensions It’s time to pause, reflect and acknowledge a new era of inclusivity and collaboration. Part 2 - How to get the most from a Technology Expert – Asset Management Hub Property & Asset Management Hub Part 1 – Balancing CRM and Asset Management Scopes - Asset Management Hub Creating a Multi-Lingual PowerApps Portal How to Set Up a Microsoft Teams Site Using DocDrive365 Microsoft Teams - Adding a Microsoft Teams URL to a Dynamics Appointment Dynamics 365 Marketing – Customer Voice Survey Not Appearing In Emails? Using SQL Management Studio to connect to the Dynamics DB Calling a Power Platform AI Builder Model via oData How to use DocDrive365 to integrate permissions between Business Units in Dynamics with Sites in SharePoint Getting started with the Power Platform AI Builder. 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
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

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