I'm using a Basic Form for my Report table in Power Pages. Within this form, I have an Editable Subgrid for Report Details records, rendered using the Power Apps Grid Control.
The Report Details table includes:
A lookup column to the Product table.
I've added related columns from the Product table (e.g., Category, Color, Size) to the subgrid via this lookup.
A Quantity column, which users can update as the subgrid is editable.
I've configured the subgrid metadata to use the Code Component as the control style.
I'm encountering the following issues:
Search Functionality: The built-in search bar of the subgrid (provided by the Power Apps Grid Control) fails to search text within the related columns from the Product table. It only seems to search columns directly on the Report Details table.
Sorting Functionality: Sorting on the subgrid column headers does not work for the related columns from the Product table. I can only sort by columns directly from the Report Details table.
Image Display: A related image column from the Product table, when added to the subgrid, does not display the image. Instead, it shows an empty field.
The subgrid’s built-in search only works on columns that physically exist on the primary table (in your case, Report Details). Unfortunately, related columns from lookups (like Product.Category) aren’t indexed for search in the grid control.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.