Dynamics 365 to SharePoint Integration for Sales Users


You are a Dynamics 365 online sales user. You want to quickly and easily store and access files related to sales opportunities, accounts, quotes, contacts, etc. It could be a contract, quote, proposal, image, whatever. If this is you, read on.

The enlightenment you seek is Dynamics 365 to SharePoint integration. It is one of my three no-brainer integrations for Dynamics 365 sales users. Why? Because:

  1. It’s easy to learn.
  2. It is easy to store and find what you need.
  3. Files get backed up.

Prerequisite

If it’s not turned on already, ask your admin or a power user to enable the connection between Dynamics 365 and SharePoint. It’s a native integration and takes less than 5 minutes to set up. 

How to use it to manage documents

We’re going to work this from the Opportunity record. Let’s say you have a prospect called Wonderful World, and you’re working on their big opening order. You are moving through your sales cycle, generating documents such as NDAs, specs, proposals, estimates, images etc. You want a place to store this stuff, so they get backed up, are easy to get to, easy to work on and share within your organization. 

Microsoft Dynamics 365 to SharePoint Integration Opportunity Sales Process

Note the Files tab outlined in blue. Click that little guy, and two beautiful things happen in the background. 

  1. A new folder gets created in SharePoint–a place to store all the files related to the opportunity. 
  2. The opportunity folder is nested within a new Wonderful World account folder. 

The empty new opportunity folder looks like this. Here, I have the option of creating a new document, uploading a file from my device, or changing SharePoint locations. We’ll keep it simple and upload three documents from my laptop: an image, a PDF and a Word doc. 

Dynamics 365 to SharePoint Integration

Click on Upload, and you’ll see an Upload Document dialog box.

Microsoft Dynamics 365 Upload Documents SharePoint Integration Choose File Dialog Box

Choose the files from your PC (or OneDrive even).

Dynamics 365 to SharePoint Integration

Here’s what you see now in the Dynamics 365 opportunity record, under the Files tab. There are links to the files stored in SharePoint. Click, and they open up. You can work on these files too. For instance, I can open the Word doc, edit it and save it. If you need to upload a file larger than 50 MB, or open the actual SharePoint folder, click the ellipse. 

MS Dynamics 365 Opportunity Record Files Tab Links Files Stored in SharePoint

Now you’re in SharePoint. You can see the three files within the opportunity folder. And you can see the opportunity folder nested in the Wonderful World account folder. Piece of cake. The other nice thing about this–SharePoint users can access these files. They don’t have to have a Dynamics 365 license. In other words, other members of your org can collaborate on these documents if needed.

Dynamics 365 to SharePoint Integration

The next level

Taking this to the next level, you can create sales documents and save them in SharePoint. But that’s for another day. If you want to tackle the setup yourself or share the instructions, click here.

Don’t be scared. Contact us!

By Mark Abes, Vice President, Dyn365Pros, Microsoft Dynamics 365 Customer Engagement Partner, Los Angeles, Orange County, San Diego, Southern California