SharePoint Documents Grid Error in Dynamics CRM

After setting up Server based authentication between SharePoint and Dynamics on several instances we were having issues on certain instances where users would attempt to access the Document grid within CRM and would receive the following error "You don't have permissions to view files in this location. Contact your Microsoft OneDrive owner or SharePoint administrator for access."  The grid ribbon buttons still loaded and if we clicked on the Open Location button SharePoint would open with all the files displaying which told us that the user had the required permissions.

After troubleshooting with a Microsoft tech for a few hours we concluded that the fix was populating the SharePoint Email Address field on the User record for each user within CRM.  Another important thing to note here is that we were using Azure AD account which had an account name of rick@ad.test.com but the email address was rick@test.com (no ad in the domain name).  I had previously found the articles below which gave me the idea that it might be the SharePoint Email Address but i had been using my full domain account rick@ad.test.com and it turned out it needed to be the email address rick@test.com

To rectify the issue on our environments we added the SharePoint Email Field field to the form.  We then created a workflow to copy the Primary Email Address into the SharePoint Email Address field when a user is Created or the Primary Email Address is changed.

Finally one thing still bothers me about all this, the fact that some environments required populating this field while other didn't.  The techs at Microsoft were unable to give a reason for this.

Troubleshooting server-based authentication

Configure server-based authentication with Microsoft Dynamics 365 (on-premises) and SharePoint on-premises

Comments

  1. It's really a great and helpful bit of data that you have shared here. I'm glad that you just imparted this accommodating data to us. Kindly share these types knowledge with us.microsoft 365 audio conferencing pricing

    ReplyDelete

  2. Get reliable, affordable and flexible Off-Site Cloud Connect veeam backup and replication at Sora Solutions Services. Reach out today for the best service and the best price. +41432338888

    ReplyDelete
  3. Are you looking for guidance on finding the Best Gift For 6 Years Old Girl? Look no further as we're here to help. This post will walk you through finding the best gift for 6 years old girl so that you can give it to her and put a big smile on her face.

    ReplyDelete
  4. Very interesting post. This is my first-time visit here. I found so much interesting stuff in your blog especially its discussion. Thanks for the post!
    buy gmail pva accounts

    ReplyDelete
  5. This information is so useful and informative which you have shared here. It is beneficial for beginners to develop their knowledge. It is very gainful information. Thanks for sharing Crowdstrike Competitors and Alternatives.

    ReplyDelete
  6. Nice Information, You provided valuable data for us. I am thankful to you for providing this kind of information.

    ReplyDelete
  7. The techs weren't sure either?

    ReplyDelete

Post a Comment

Popular posts from this blog

Add User As Local Administrator On Domain Controller

Calling Dataverse Web API in PowerShell using Client Credentials

Windows Server 2008R2 VMs Shut Down After 1 to 2 Hours