Displaying SharePoint Documents in a D365 CE Form

Tuesday, 17 November, 2020

Displaying SharePoint documents for an entity in Dynamics 365 CRM/CE has been a common requirement for a long time. For many years, the go-to fix was using an embedded IFrame on the form, pointed at the document relationship. However, this was always unsupported and was sure to break at some point…

It turns out it finally did. If you follow along with the original approach, seen here on Jason Lattimer’s blog, you’ll find that the ‘Upload’ functionality now breaks if your organization has transitioned to the Unified Interface.

The New Approach

It turns out, Microsoft has finally introduced a way to add this functionality out of the box. However, unless I’ve missed something, they haven’t really talked about it anywhere. Hopefully, that’s where this blog post comes in.

Steps

Before starting, it is important to note that this only works on D365 CE online instances that have transitioned to the Unified Interface.

I also assume that you have already set up Sharepoint Document management for the entity in question.

  1. Navigate to https://make.powerapps.com, and open the entity form that you want to add documents to.
  2. Add a subgrid of ‘related records’ only, pointing at entity type ‘Documents (Regarding)’

Alt Text

  • Important note: this subgrid can only be added using the new form editor. The ‘Documents’ entity will not be available in the legacy version.

After adding the subgrid, save and publish your form, and open it in the Unified Interface.

You should now see a new Documents sub-grid, with the same contents as under the —> Regarding —> Documents tab. Alt Text

Happy documenting! ✍


Andrew Robilliard

Written by Andrew Robilliard who lives and works in Wellington, New Zealand. You should follow me on Twitter.