Integrating SharePoint with Dynamics 365 lets you store, access, and manage documents directly from CRM records while keeping files in SharePoint’s dedicated storage rather than consuming Dataverse capacity.
The integration adds version control, compliance features, and folder-level organisation that Dataverse file attachments do not provide. Combined with Power Automate, it also supports workflow automation triggered by document changes, such as contract approval routing.
This article covers how the integration works in practice and where it adds value across storage, security, collaboration, and process automation.
Associate SharePoint documents with Dynamics 365 records
Forms for standard entities, such as Accounts, Leads, and Contacts, allow you to upload documents. These files can be hosted in Dynamics 365/Dataverse, but SharePoint has advantages.
Using SharePoint via Dynamics improves accessibility. You can upload and view documents directly within the Dynamics interface or through a business SharePoint site. It also uses SharePoint’s robust security and version control features for better data management. Each file can also be placed into a folder for effective document organisation.
By selecting Open Location on the command bar menu, you can open a browser tab that directs you to the specific SharePoint folder for that record. When creating new records, SharePoint can automatically create an associated record folder on the site.
The SharePoint view lists documents associated with the current Dynamics record. It displays basic metadata information, such as when it was created and by whom.
Storage Optimisation
Using SharePoint with Dynamics can reduce storage consumption on your Dataverse tenant.
SharePoint has dedicated storage and is hosted in its global data centres using Azure. SharePoint is optimised for larger libraries of documents (typically 25TB per site), which can reduce consumption demand on your Dataverse tenant. We’ve discussed the data storage limits for Dynamics 365 in a previous article, and it’s a consideration that needs to be carefully addressed.
Compliance and Security
SharePoint provides advanced compliance and security features, ensuring uploaded documents adhere to regulatory requirements and are protected against unauthorised access.
Its capabilities include solutions for regulatory compliance, audit trails, risk mitigation and enforcement of consistent policies.
Version Control
SharePoint ensures that people always have access to the latest document versions while maintaining a history of changes.
Only the latest version of the documents will be shown in Dynamics, but earlier versions of each document can be accessed in SharePoint.
Enhanced Collaboration
By linking SharePoint’s document management capabilities with Dynamics 365 sales, service and other teams can efficiently access the documents they need.
Retrieving document information quickly on a unified interface is beneficial. You can access hosted documentation and efficiently navigate to other information within Dynamics. This helps maintain productivity by removing the need to switch browsers and begin a new search process on a different system.
Workflow Automation
The integration supports workflow automation, allowing processes that trigger based on document changes or updates within SharePoint.
For example, you could create a Power Automate flow whereby a notification is sent when a SharePoint file is updated or created. Another scenario could be when an account needs to go through a contract approval process.
The flexibility of these services when working together assures businesses that solutions are always available for their unique process requirements.
The steps for workflow automation, which include SharePoint and Dynamics working together, could look like the following:
Trigger: When a new contract document is uploaded to a specific folder in SharePoint.
Action: Power Automate triggers and retrieves the document metadata, such as contract details.
Condition: Check if the contract amount exceeds a predefined threshold that requires additional approval steps.
Approval Flow
If Yes (requires additional approval): Notify designated via email.
If No (standard approval): Automatically route the document for approval to the appropriate manager or team member.
Approval Decision
Approved: Update the corresponding Dynamics 365 record (e.g., Opportunity or Contract entity) with the contract details, status, and approval date.
Rejected: Notify the uploader and update the SharePoint document status accordingly.
Notification and Updates
Send notifications to relevant stakeholders (e.g., contract owner, sales team) about the approval status.
Log approval actions and updates in SharePoint for audit and tracking purposes.
By utilising workflows like the above example, Dynamics and SharePoint work together. The integration offers a valuable tool to business operations, especially at scale. It facilitates compliance by maintaining an audit trail and adhering to regulatory requirements.
Automating these tasks in the same way each time ensures they are scalable and prevents human error and discrepancies. SharePoint and Dynamics 365 workflows are also efficient, and reduces the need for manual intervention and speeds up approval times. This ultimately decreases costs or helps increase revenues in many scenarios.
When to consider this integration
If your organisation already uses SharePoint, connecting it to Dynamics 365 is a straightforward step that puts documents where your CRM users can reach them without switching systems.
The technical overhead is low because both products sit within the Microsoft ecosystem and the integration is well established.
If you are implementing Dynamics 365 for the first time, building SharePoint into the project from the start avoids the document management limitations of Dataverse-only storage and gives you compliance and version control capabilities from day one.
How we help
ServerSys has configured SharePoint integration across many Dynamics 365 projects, including automated approval workflows using Power Automate.
Whether you need to connect an existing SharePoint environment or set one up alongside a new Dynamics 365 implementation, contact us to discuss your requirements.
