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. The information which you have provided is very good and essential for everyone. Keep sharing this kind of information. Thank you. microsoft teams support houston tx

    ReplyDelete
  2. 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
  3. Stubsondemand's california pay stub generator creates pay stubs online. This easy paystub generator that handles calculations automatically for you.

    ReplyDelete

  4. 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
  5. 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
  6. Sora Solutions Services brings the complete project management for app development to the table for customer application development and planning.

    ReplyDelete
  7. 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
  8. 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
  9. I am very obliged to you for sharing this essential knowledge. This information is helpful for everyone. So please always share this kind of information. Thanks once again. Digitrac Tractor

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

    ReplyDelete
  11. The techs weren't sure either?

    ReplyDelete
  12. These projects are accessible on the web, and you are simply expected to transfer the PDF document that needs change. pdf-png.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Add User As Local Administrator On Domain Controller

How to Create SharePoint Items with Power Automate Desktop

Calling Dataverse Web API in PowerShell using Client Credentials