Subgrid Metadata filter

[prathyoo]

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

[Fubar]

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>

[prathyoo]

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

[OliverRodrigues]

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

[prathyoo]

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>

[OliverRodrigues]

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>