+15

Dynamic sub-grid with contextual awareness using FetchXML

5 years ago • updated by 9 months 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:

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.

Vote

Replies 6
Oldest first
- Newest first
- Oldest first

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!

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).

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 years 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.

2 years 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.

9 months 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