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

(0) Share

Report

Posted on by Anonymous_Hippo

1,247 Super User 2024 Season 1

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 !

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
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

Was this reply helpful? Yes No