How to Integrate SharePoint with Dynamics 365 Portal
The SharePoint integration lets portal users work with documents stored in SharePoint, attached to their Dynamics 365 records. You connect a SharePoint site to the portal, then give portal user roles document access and add the SharePoint widget where users should see documents.
The SharePoint integration is included in every plan. See CRMJetty Plans and Feature Availability.
Before you start
- You need access to the CRMJetty admin portal. Only the super admin receives the OTP that opens the Sharepoint settings page.
- You need a SharePoint site in Microsoft 365 (formerly Office 365). If you don’t have one, create it first (see below).
- You need an app registered in Microsoft Entra ID (formerly Azure Active Directory) with SharePoint permissions and a client secret. See How to Register an Entra ID App for Dynamics 365 OAuth.
- Your portal must already be connected to Dynamics 365. See How to Connect Dynamics 365 to CRMJetty Portal.
Create a SharePoint site
Skip this if you already have a site for portal documents.
- Sign in to Microsoft 365 with an admin account. If you use Microsoft Dynamics 365 with admin access, you can use the same credentials.
- From the list of Microsoft 365 apps, select SharePoint. Any existing sites are listed.
- Select Create Site. A panel opens on the right.
- Select Team Site. Team sites are for storing and managing documents together; communication sites are for sharing information broadly.
- Enter the site details, such as the site name, description and permissions.
- Select Next to finish and save the site.
Copy the site URL. You enter it in the portal later.
Turn on SharePoint for your Dynamics 365 entities
The portal shows SharePoint documents only for entities that have SharePoint document management turned on in Dynamics 365. For example, to manage documents for cases and contacts, turn it on for the Case and Contact entities.
- In Dynamics 365, set up server-based SharePoint integration with your SharePoint site, if it isn’t set up already.
- Open Microsoft’s Document Management Settings.
- Select the entities that should store documents in SharePoint, such as Case and Contact.
- Finish the wizard.
For the exact steps, see Microsoft’s documentation on managing document management settings in Dynamics 365.
Note: If you turn on document management for another entity later, it then appears in the Documents section of portal user roles.
Connect SharePoint to the portal
- Sign in to the admin portal.
- Go to Settings → Integration → Sharepoint.
- Enter the OTP sent to the super admin’s registered email address.
- Fill in the fields in the table below.
- Select Test Connection.
| Field | What to enter |
|---|---|
| SharePoint Site | The URL of the SharePoint site to connect to the portal. |
| Environment | The SharePoint environment the portal works with, such as production or development. |
| Application (client) ID | The Application (client) ID of your Entra ID app. The portal uses it to authenticate with SharePoint. |
| Client Secret | The client secret Value of the same Entra ID app. |
If the connection succeeds, a success message appears on the right side of the page. The site then appears in the list of available SharePoint sites, and documents are stored in SharePoint and linked to your Dynamics 365 records.
Important: When the client secret expires, the portal can no longer reach SharePoint. Create a new secret in Entra ID before the expiry date and update Client Secret here.
Give portal users access to documents
Connecting SharePoint doesn’t show documents to anyone yet. Next:
- Set document rights in each portal user role: turn on Document Access to let portal users add files and folders, and Delete to let them delete documents. See How to Create Portal User Roles and Permissions.
- Add the SharePoint widget to the forms or pages where portal users should see documents. See How Portal Users Upload and View SharePoint Files.
Troubleshooting
Test Connection fails: Check that Environment, Application (client) ID and Client Secret are correct, and that the client secret hasn’t expired. If it still fails, ask the person who manages your Microsoft 365 and Entra ID tenant to check the app’s SharePoint permissions and admin consent.
An entity is missing from the Documents section of a role: SharePoint document management isn’t turned on for that entity in Dynamics 365. Turn it on, then check the role again.
You don’t receive the OTP: The OTP goes only to the super admin’s registered email address. Ask the super admin to open the page, and check that SMTP is set up. See How to Configure SMTP Email in CRMJetty Portal.
Related articles
- How Portal Users Upload and View SharePoint Files
- How to Register an Entra ID App for Dynamics 365 OAuth
- How to Create Portal User Roles and Permissions