Power Platform Community Forum Thread Details

I've been working on a proof-of-concept application that stores documents and relations regarding applications and servers, with the idea being that each application / server has its own SharePoint library/folder that contains related documents and attachments. To implement this in an App with pages based directly on the Dataverse table, I followed this video's instructions: https://www.youtube.com/watch?v=jRMwBBVO8EE. I had enabled SharePoint integration and made my connections in Advanced Settings > Document Management, and modified the Forms for these tables using a Subgrid, enabling related records, and selecting "Documents (Regarding)".

However, I want to know if it's possible to do something similar using Custom pages developed in Model-driven apps? There doesn't seem to be a subgrid option that allows you to display related records for Custom Pages as there is for Dataverse table-based pages and I'm not sure if there's other ways to do this.

PowerApps Form with SP Integration Example.png

PowerApps Form with SP Integration Example 2.png

Categories:

Building Power Apps

Since you are not able to embed a custom page to the form in a model-driven app, you might want to check out the embedded canvas app on a model-driven form.

From that canvas app, you can query the list of Documents using FetchXML query either by calling a cloud flow or by building a PCF control.

Here is the sample FetchXML to retrieve the list of SharePoint documents for a particular record in Dataverse and you can update the link-entity part with your application/server table, and replace the GUID with the dynamic value (current record ID).

<fetch>
 <entity name='sharepointdocument'>
 <attribute name='documentid' />
 <attribute name='sharepointdocumentid' />
 <attribute name='fullname' />
 <attribute name='relativelocation' />
 <attribute name='filetype' />
 <attribute name='absoluteurl' />
 <attribute name='editurl' />
 <order attribute='relativelocation' descending='false' />
 <filter>
 <condition attribute='isrecursivefetch' operator='eq' value='1' />
 </filter>
 <link-entity name='account' from='accountid' to='regardingobjectid' alias='bb'>
 <filter type='and'>
 <condition attribute='accountid' operator='eq' value='62060750-ab16-eb11-a812-000d3a6aa8dc' />
 </filter>
 </link-entity>
 </entity>
</fetch>