Filtering a list dynamically on power pages

(2) Share

Report

Posted on by sid25

So I have two tables HandoverRequests and ADCL_list. There is a one to many relationship between those two tables, the column handoverrequestid which is a lookup on ADCL list. So there can be more than one ADCL details for one handover request.

On power pages I have a list of handoverequests and when I click on ADCL details for a particular record it should take me to another page with ADCL List.

Expectation is this page should filter the rows and only show the ones with selected handoverrequestid.

This is what is passed when clicked on ADCL details :

/ADCL-Details/?id={{ record.p045_handoverrequestid | url_encode }}

The entity list does not filter with given guid.

I tried forms and used subgrids they do filter as per the guid but then subgrids records cannot be edited. Editable grids work on Model drivern app but not on power pages.

List can be edited but then they dont filter.

Does anyone have any work arounds or solution to this issue.

Thanks in advance.

Categories:

General

All responses (3)

Answers (0)

Suggested answer

surya narayanan 24 on at

Like (1)

Report

Filtering a list dynamically on power pages

Hi,

Please find the solution in the attached file.

Solution approach...
Suggested answer

Ajlan 191 on at

Like (1)

Report

Filtering a list dynamically on power pages

Hello

Please refer to this amazing blog by Gary Harrison

https://www.encorebusiness.com/blog/power-apps-portals-entity-list-to-entity-list-with-filtering-parameter/

Cheers! 🎉
PG- Assistant Techn... 4 on at

Like (2)

Report
Filtering a list dynamically on power pages

Hi

Step 1: Open List Settings

In Power Pages Studio, select the List component you added to your web page.

Step 2: Enable the New Experience

At the top of the List Settings panel, toggle ON:

“Try the new and improved version of this component.”

This gives you access to enhanced UI features like built-in filtering, search, paging, etc.

Step 3: Add Filters (Field Filtering)

Once you've enabled the preview experience and selected a data view:

Save the list

Go to the live Power Pages site

You’ll see: A search bar

A filter panel (if your selected view supports it)

You can optionally use column headers to filter/sort