Power Platform Community Forum Thread Details

In my model-driven app I have a table called Price Change. It has a field called Product ID.

On the form used to create a new Price Change record I would like to display a readonly sub-grid with all existing Price Change records (ie records from same table) where Product ID matches the value I have entered as I am creating the new record. I have tried numerous ways using javascript function triggered from when the Product ID field is changed but I cant find a way to dynamically filter the subgrid. Does anyone know how I can do this?

Categories:

Power Apps Pro Dev & ISV

I found a working solution using this method to update the data in the subgrid

      const subgrid = formContext.getControl("PreviousPriceGrid");

   // Define filtered FetchXML
   const fetchXml = `
   <fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
     <entity name='cr123_pricechange'>
       <attribute name='cr123_productid'/>
       <attribute name='cr123_productname'/>
       <attribute name='cr123_effectivefrom'/>
       <attribute name='cr123_newprice'/>
       <order attribute='cr123_efffectivefrom' descending='true'/>
       <filter type='and'>
         <condition attribute='cr123_productid' operator='eq' value='${productId}'/>
       </filter>
     </entity>
   </fetch>`;
 console.log("Applying custom view to subgrid...");
 try {
     if (!subgrid) {
         console.log("Subgrid 'PreviousPriceGrid' not found.");
         return;
     }
     subgrid.setFilterXml(fetchXml);
     subgrid.refresh(); // Refresh to apply the filter
     console.log("Filter applied successfully.");
 } catch (e) {
     console.error("Error applying filter:", e);
 }