How to add column that is "groupby" inside the grouped sub table

[Anonymous_Hippo]

Hello Everyone !

This seems like an easy task but for some reason i am not able to figure this one. How can i add a column that i am grouping by inside the grouped sub table.

I would like to add the column Product inside the grouped by table called "PrdGroup"

Here is the items property of my gallery

Sort(
    GroupBy(
        Filter(
            '2021 Worldwide RA Milestone Dashboard',
            (Len(VarFranchise) = 0) || Franchise = Label10.Text
        ),
        "Product","PrdGroup"
    ),
    Product
)

I would like to add the "Product" column displayed here inside PrdGroup

Thank you !

[WarrenBelz · Accepted solution]

Hi,

Slightly different name, but the value will be there

Sort(
  GroupBy(
      AddColumns(    
         Filter(
            '2021 Worldwide RA Milestone Dashboard',
            (Len(VarFranchise) = 0) || Franchise = Label10.Text
         ),
         "Product2",
         "Product"
      ),    
      "Product",
      "PrdGroup"
   ),
   Product
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps