Unanswered

Power Pages list filtering based on URL Parameter

(1) Share

Report

Posted on by gburner

Hello,

I have a Power Page with a Home page and a Permit Page. The Home page contains a list of Accounts associated to the user, with a details link to the Permit Page that contains a List of Permits associated to the user.

I need the list of Permits to be filtered by the accountid url parameter (the account that was clicked on from the Home page). I'm looking for a way to do this with OOB Power Pages functionality.

Javascript does not work well, since it filters out the permits that should be hidden, but that leaves pages with different numbers of permits. I'm not aware of a way to paginate, without using a huge amount of custom code.

Typically I would use fetchXML or the WebAPI to get the records I need then build the HTML list with JS, and that is still an option, but wanted to exhaust all native capabilities first.

Thanks for any help you can provide!

Categories:

Design & build

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Fubar 8,344 Super User 2025 Season 2 on at

Like (0)

Report

If your Permits have a Lookup to Account (would also work for an N:N), then create an Account form that has a Subgrid for its Permits, and add that form to a new Web Page, then open that Web Page from either a List or from a Url passing the id of the account to the Web Page.

In theory using Liquid you may be able to do something with a Lists View, but you need to have enabled and configured correctly Metadata filtering on the List (via Portal/Power Pages Management App) and then pass the correct filter into the View (but there is very little documentation on this) see the 'metafilter' under the entityview Parameters

https://learn.microsoft.com/en-us/power-pages/configure/liquid/dataverse-liquid-tags#parameters-4

Was this reply helpful? Yes No
Suggested answer

Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Please follow the below:-

Step 1: Enable Filtering on the Permit List

Navigate to the Permit Page in your Power Pages site.

Find the Permit List that you want to filter.

Go to the list's Advanced Settings.

In the Filter section, check the option that allows the list to be filtered by query string parameters.

Specify the query string parameter that you want to filter by. In your case, it would be something like accountid.

Step 2: Pass the accountid from the Home Page

On the Home Page, where you list the accounts, update the Details Link for each account to include the accountid in the query string.

The link should look something like this:

/PermitPage?accountid=<accountid_value>

When a user clicks on the details link, they are taken to the Permit Page, and the list is automatically filtered based on the accountid parameter passed in the URL.

Thanks!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No
Kenneth Leong 6 on at

Like (0)

Report

Got a question on the metafilter. When we're using the fetchxml metadata filter to put conditions on related entities, the conditions we put in the fetchxml are displayed as checkbox in the filter panel. can we put conditions on multiple attributes?

Was this reply helpful? Yes No