Power Platform Community Forum Thread Details

Pre-filter the out-of-the-box list based on a query string

Hello,

What I have:

I have an out-of-the-box list component (Audits). When the user clicks on a list item, they are taken to the (Audit) Details Page. This page has the id={Audit Guid} in the query string URL, and I'm showing some Audit data on this page.

What I want:

To add an out-of-the-box list component (Resources) to the Audit's details page. This list should be dynamically pre-filtered to include only items (Resources) that are related to the page's specific Audit (in other words, filter the list based on the page query string).

BTY, I don't want to use the Model Driven APP's related item subgrid as a form in this page, because I want the Resources list item to also be clickable and allow drilling down to a details page for a Resource.

What am I missing?

I was hoping to use the FetchXML filter in the Metadata Filter section of the List component on the Power Pages Management app, but it seems that its purpose is a user-defined UI filter.

I also saw some examples of achieving this with FetchXML + Liquid, but from what I understand this approach involves rendering the list html by myself and not being able to leverage the out-of-the-box List component, with its immediate advantages like sorting and filtering.

So, am I right to understand that there is no easy way of pre-filtering the out-of-the-box List component?

Thank you for your help!

Gil

P.S.

The same question also applies to the new modern Card Gallery, that I was hoping to be able to pre-filter dynamically.

Categories:

Design & build

Hey Gil, so youre not overlooking something big here. That metadata filter on the regular list setup is mostly for when users pick filters themselves through the interface, it does not automatically narrow things down just from having id equals some guid in the page url. At least not without extra setup to connect it to url parameters or something like that.

I guess the simplest path keeps using the out of the box list, where you still get sorting and searching without hassle. Basically set up a list filter that pulls from a query string parameter. This way the list stays standard with paging and all that, but it can react to a url like with auditid equals a guid, or maybe even reuse the id parameter if that fits better.

In the portal management or power pages app, first check that your resources table links back to the audit one, say with a field like crx auditid.

Then make a dataverse view for resources, nothing special, just pick the columns and sort order you need.

Open up the entity list for resources and add this filter thing, set it to lookup type, point it to that auditid field on resources, and name the query string parameter auditid, or id if you prefer sticking with what you have.

Put the list on your audit details page, and make sure the url there passes the parameter. If its auditid, then the link ends up like slash audit details with id equals audit guid and auditid equals the same guid. Or if you go with id for the filter, just the single id parameter works fine.

This whole pattern of filtering lists through url parameters comes up a lot in power pages stuff, it seems reliable enough.

Now if you want the filtering to happen without any filter controls showing up, there are a couple ways people handle that. One is to add some css or js to hide the filter ui, so it runs in the background and feels automatic even though its still using the lookup and parameter setup.

Quick Links

Subscribe to this forum!