Introduction

Dynamics 365 is able to store attachments on records. This is obviously already useful but was made even more useful when Microsoft added the ability to search within documents (more info).

Unfortunately, the amount of free storage you get within Dynamics is quite low, and the cost per GB is expensive. This means that storing documents such as quotes & invoices quickly becomes expensive.

One of the methods that can be used to reduce the cost is to store the documents in Microsoft SharePoint. SharePoint is a collaborative platform and has a vastly reduced cost per GB than Dynamics.

A downside is that the search functionality for Dynamics cannot check within documents stored on SharePoint. Due to this, it may be worth having some documents stored in SharePoint & some in Dynamics.

Security

An important thing to keep in mind is that security roles do not get copied automatically. There are some 3rd party tools that can do it, and it may be possible to create your own solution, but out of the box, you will need to manage this manually.

Due to the structure of the SharePoint folders, it will be easier for people to navigate around the folders. This means that someone may be able to easily see documents for an opportunity that they do not have permission to see in Dynamics.

This means that you will want to take care when enabling the integration and make sure that you’re happy with the permissions. I would recommend testing the permissions from a range of user permissions.

Setup

The environment during this demo is a Dynamics 365 Free 30 day trial. The trial also comes with a trial version of SharePoint.

The first step to enable Dynamics 365 SharePoint Integration is to go to Settings -> Document Management and from within there select Document Management Settings.

Document Management Settings option is shown under the Document Management setting area
Document Management Settings

A new window will open. In this window, you will be able to select the entities to enable Document Management on. You will also be able to enter the SharePoint URL (in my example I have made a site specifically for CRM documents).

Window allowing the user to select entities & site URL
First Window showing the entities that can be enabled & the site URL

The second page will then allow you to confirm the URL entered & select the folder structure. In my case I have selected to base it on the account entity. This means all the files will be stored under the account folder – each entity will get its own subfolder.

The second page allows the user to select the folder structure. It also provides the option to confirm that the URL is correct
Selecting the folder structure

Selecting next will allow the system to create the top-level folders in the SharePoint site.

Interestingly, even though I have selected to have a folder structure based on an entity, each entity will still get an individual top-level folder. The folder structure will still be honored though, so any opportunity documents are added under /account/AccountName/opportunity/

The folders will then be created on the SharePoint site
Folders are created on SharePoint site

Usage

The documents are then accessible from within a record using the navigation menu at the top for related entities using the Documents link.

Navigation Menu shows Documents under related Items
Navigation Menu shows Documents under Related Items

It is not possible to add a subgrid for SharePoint Documents to the page out of the box. I have create another post which shows how you can use an IFrame to achieve this.

View of the documents from within Dynamics
The view from within Dynamics
The same document but viewed from within SharePoint
The view from within SharePoint

Summary

The Dynamics 365 SharePoint Integration is easy to setup & can help reduce costs. You will need to consider how you implement the security, but this should be manageable.

You will also receive the added benefit of version control & SharePoint workflows, which can help with document management.

The ability to search within documents in Dynamics will be lost, but it is possible to search with SharePoint. This is something that you will have to decide if it is worth it or not. It is possible to have some documents in Dynamics & some in SharePoint

This Post Has One Comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Close Menu
%d bloggers like this: