Power Platform Community Forum Thread Details

Good morning,

I am building a gallery that has a GroupBy function to aggregate records by Product field. I also want to call in the Category field within the Gallery and use that field to add a filter for the Combobox.

My gallery Items is currently set as:

Search(GroupBy(AddColumns(Filter('Available Furniture Catalog','Approval Status'.Value="Request Approved"),"ProductText",Product.Value),"ProductText","Data"),TextInput2.Text,"ProductText")

I have both fields in the Gallery as Items: ThisItem.ProductText and would like to have the highlighted field in my attached photo show the Category of the Product from my data sharepoint list 'Available Furniture Catalog' and use it for the combobox filter mentioned above. If anyone can help me, much appreciated!

Categories:

Building Power Apps

@katelynmodolo -

One example using First:

Search(
 AddColumns(
 GroupBy(
 AddColumns(
 Filter(
 'Available Furniture Catalog',
 'Approval Status'.Value = "Request Approved"
 ),
 "ProductText",
 Product.Value
 ),
 "ProductText",
 "Data"
 ),
 "Column1",
 First(Data).'Field 1',
 "Column2",
 First(Data).'Field 2'
 ),
 TextInput2.Text,
 "ProductText"
)

Another example using LookUp:

Search(
 AddColumns(
 GroupBy(
 AddColumns(
 Filter(
 'Available Furniture Catalog',
 'Approval Status'.Value = "Request Approved"
 ),
 "ProductText",
 Product.Value
 ),
 "ProductText",
 "Data"
 ) As temp,
 "Column1",
 LookUp(
 'Available Furniture Catalog',
 Product.Value = temp.ProductText,
 'Field 1'
 ),
 "Column2",
 LookUp(
 'Available Furniture Catalog',
 Product.Value = temp.ProductText,
 'Field 2'
 )
 ),
 TextInput2.Text,
 "ProductText"
)