Subgrid Metadata filter

(0) Share

Report

Posted on by psreek

323

Hi,

I have enabled the 'Edit' item action and noticed a "Filter Criteria" attribute. What does this do and what is the syntax for the filter? Can we use this to enable/disable the 'Edit' option on an item in the subgrid?

I noticed that the below documentation does not mention the "Filter Criteria"

Configure basic form subgrids for Power Pages | Microsoft Learn

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Fubar 8,528 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
It allows you to put a simple FetchXML condition which if it matches will show the button/link if not will hide it. e.g. you can have 2 Edit buttons, one for Status Reason is A and another for Status Reason is B and only show one button or none based on the Status Reason of the record in the List/Grid

Think this is still true, for a List you can get away with just the Filter part of the FetchXML, for a Subgrid need to include a full fetch statement.

<filter type="and"> <condition attribute="statuscode" operator="eq" value="1" /> </filter>

Was this reply helpful? Yes No
psreek 323 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much. We tested and yes the Subgrid Item Action filter needs the entire FetchXML.

Was this reply helpful? Yes No
oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I have a blog post on this one that might help: Power Apps Portals – Entity List: Conditional Action – Oliver Rodrigues (oliverrodrigues365.com)

Was this reply helpful? Yes No
psreek 323 on at

Like
a
(0)

Report
Copy link

Link copied!
It worked and now it doesn't. So, it worked for the first subgrid where we enabled the 'Withdraw' button only when the Approval Status is not equal to 'Withdrawn'.

Next up we wanted to disable the Edit option in the Contact subgrid when the Relationship Type = Focal Point and enable otherwise. We followed the exact same steps and yet the Edit option is still available -

<fetch version="1.0″ output-format="xml-platform" mapping="logical" distinct="false"> <entity name="contact"> <filter type="and"> <condition attribute="customertypecode" operator="ne" value="452950001" /> </filter> </entity> </fetch>

Was this reply helpful? Yes No
oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Can you try your fetch like below, removing the additional attributes from the fetch tag:

<fetch> <entity name="contact"> <filter type="and"> <condition attribute="customertypecode" operator="ne" value="452950001" /> </filter> </entity> </fetch>

Was this reply helpful? Yes No