SharePoint Integration with Microsoft Portal

By | November 19, 2018

 Introduction:

Dynamics 365 upgrades often enfold bunch of exciting features and the latest October release which upgrades your CRM to version 9.1 happens to continue the legacy. Amongst all the new features, the one we are targeting in this blog is the SharePoint’s integration with MS Portal. With the commencement of this feature, it would be of much more convenience to categorize and store documents for respective records from the portal in different scenarios such as when the portal user is a Sales Rep and when logs in to the portal can create, edit or view its list of clients and also attach required documents concerning different clients.

The documents can be Invoices or details of authentication etc.

Pre Requisites:

  • The CRM user needs to be an Office 365 Global Administrator to be able to access the Office 365 Admin center and thus enable the SharePoint integration with MS Portal.
  • There integration between Dynamics CRM and SharePoint should already exists.

Below is the step by step explanation of how to achieve the integration.

1. In the Dynamics 365 Admin Center, navigate to your Portal Admin Center

SharePoint Integration with Microsoft Portal

SharePoint Integration with MS Portal

Please Note: To access the Office 365 Admin Center the CRM user needs to be an Office 365 Global Administrator.

2. Now inside your Portal Admin Center you will find the section “Set up SharePoint integration”

SharePoint Integration with MS Portal

3. As mentioned in the above screenshot click on the button “Enable SharePoint integration” and follow the below steps to successfully enable the SharePoint Integration.

  • Click on the Enable button in the screenshot below

SharePoint Integration with MS Portal

  • It will take some time to process

SharePoint Integration with MS Portal

  • It will then request you to sign in to your Microsoft account again. Use your CRM credentials to sign in.
  • After which it will request you to accept the permissions. Hit the accept button to grant the required permissions.

SharePoint Integration with MS Portal

  • And finally its done and you shall get the message as shown below

SharePoint Integration with MS Portal

4. Now once the integration is done you will need to add the document location subgrid in the CRM form which eventually gets displayed in portal.

SharePoint Integration with MS Portal

Please Note:  To view and add the Document Locations sub grid on the respective entity form, there should be an existing configuration between your CRM and SharePoint and also Document management should be enabled for that respective entity (i.e. contact in our scenario).

5. Now as per our scenario we have logged in to the portal as a Sales Representative who have multiple clients.

SharePoint Integration with MS Portal

6. Now when we open the record to edit there you shall see the document locations as below.

SharePoint Integration with MS Portal

Please Note: To view the document location in portal as shown in the above screenshot.

a. The entity form needs to be in Edit mode.

SharePoint Integration with MS Portal

If it’s not in Edit mode below is how it gets displayed

SharePoint Integration with MS Portal

b. You need a child Entity permission pointing to the entity Document Location as well.

SharePoint Integration with MS Portal

Now regarding the Parent entity permission, it can be any normal entity permission pointing to the entity for which you wish to upload the document. In our case, as we mentioned that the documents will be attached against respective clients i.e. contact so we created a Global entity permission for the Contacts entity as below.

SharePoint Integration with MS Portal

Without the entity permission, the below error message gets displayed.

7. Now to shed some light on the functionality, using the button “Add Files” one can add the documents in SharePoint.

SharePoint Integration with MS Portal

On click of the “Add Files” button you are shown a pop up window from where one can chose the file to upload.

SharePoint Integration with MS Portal

Once you choose the file and upload, a folder gets created in SharePoint’s Contact folder following the convention as “Contact Full Name_GUID”.

SharePoint Integration with MS Portal

And the attached document gets displayed in that folder in SharePoint as below.

SharePoint Integration with MS Portal8. And using the button “New Folder” we can create a folder which eventually gets created inside the parent folder “Contact Full Name_GUID” in SharePoint as below.

SharePoint Integration with MS Portal

SharePoint Integration with MS Portal

And from portal you can go inside the folder and then upload a document which gets uploaded inside the respective folder.

portal

SharePoint Integration with MS Portal

Please Note: Whenever a document is uploaded against a new record, a document location regarding that entity’s record (in our case the entity is Contact) gets created in CRM whose owner is “SYSTEM” in CRM.

SharePoint Integration with MS Portal

Conclusion:

Thus managing and uploading of documents to SharePoint from portal has become quite convenient thus reducing lot of time and effort and also helping in saving a lot of the Dynamics CRM storage.

We have a team of techno-functional developers and consultants with in-depth knowledge of the new technologies like Microsoft Dynamics 365 PortalsPower BICommon Data ServiceMicrosoft PowerAppsMicrosoft Flow and Logic Apps.

To learn more about how we can help you enhance the productivity within Dynamics CRM and make your Dynamics CRM implementation a success, write to us at crm@inogic.com.

Leave a Reply

Your email address will not be published. Required fields are marked *