1. General
  2. Ideas
+15

Dynamic sub-grid with contextual awareness using FetchXML

Niels 4 years ago • updated by Ruben 1 month ago • 6

A great feature of the Common Data Service (current environment) List Records action in Power Automate is that you can use dynamic FetchXML queries. E.g. you can create a FetchXML query and use variables to dynamically update the query in the context of the flow:

Image 40


It would be great to have a similar feature for sub-grids on forms. E.g. the Account form it would be nice to be able to show hierarchically related opportunities in the context of the selected Account. 

Jonas Rapp has a method where a plugin is used to achieve that. I have absolutely no idea if this is even possible to achieve using PCF but it would great if it is. 

+3
Jonas Rapp 4 years ago

The trick I guess is just creating a neat subgrid, how to populate it should be completely customizable with any kind of FetchXML (and a layout definition for the columns).

Like the idea!

Andrew Ly 4 years ago

I had a similar request, but with charts instead of subgrids.  Currently it's not straight forward to inject fetchxml into a model driven chart, and the client doesn't want to fork out for PowerBI (for 5000 users).

Niels 4 years ago

I would be happy to help, if anyone with the knowledge and skills to create such a control, would be interested. I am not a developer, so it would probably mainly be testing I can do.

+2
Don Schiavone (DS Google) 12 months ago

HI Niels,.  I got frustrated waiting for this so I built one myself.  Presenting FetchXml DetailsList. donschia/FetchXmlDetailsList (github.com). This Custom (PCF) Control that takes a FetchXml query and column list and produces a read only subgrid for Model Driven apps.  Not sure if you are still needing something like this, but if so I hope this helps you.

+1
Niels 12 months ago

Hi Don Schiavone,

This looks great!

This seems exactly what I was looking for three years ago - and still is today 🙂 


I will give this a spin and submit any feedback I might have. 


I have also shared the link to your GitHub in this thread on idead.powerapps.com where lots of people are looking for the same. 

Ruben 1 month ago

Hi All,

You can try also this control.


https://marketplace.bevercrm.com/pcf-controls/6

I'll highly appreciate your feedback, regarding what can be improved.

Customer support service by UserEcho