Nested Groupbys

(0) Share

Report

Posted on by Dorinda

1,512

I have nested galleries and I need to do a filter where only the Equipment is displayed for the current logged in user.

Currently this is my GroupBy code on the Parent Gallery, I want to group also by Year, which is a field in my SharePoint list. However, I do not know how to do the second groupby and how to use it in the child gallery.

 GroupBy(
 AddColumns(
 Filter(
 colEquip,
 User().Email=CurrentUser.Email),
 "EmpName",EmployeeName),
 "EquipmentType",
 "Data")

Any help would be appreciated.

Categories:

Building Power Apps

All responses (9)

Answers (2)

Sort by

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dorinda ,

That gallery would be

GroupBy( Data, "YourGroupedField", "Data2" )

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
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz I thought I had to do a nested groupby on the first one in order to do the filter. Are you saying i add that second groupby directly in the child gallery?
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Dorinda ,

Yes - the "child" gallery Items is normally ThisItem.Data, so you can further filter/group in there.

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
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz I am sorry but I am having a brain cramp I do not understand how to do this? Can you please tell me how to filter the User and Year?
Verified answer

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dorinda ,

It would be same format as normal - you are just grouping Data

AddColumns( GroupBy( Filter( Data, User = . . . . & Year = . . . ), "YourGroupedField", "Data2" ), "YourAddedColumn", AddedColumnValue )

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
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz so this appears like it would go on the Parent Gallery not the child just making sure where I need to put this?
Verified answer

Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz

Took me awhile but on the Parent Gallery I put this
GroupBy( AddColumns( Filter( colEquip, User().Email=CurrentUser.Email), "EmpName",EmployeeName), "Purchase_x0020_Year", "EquipmentType", "Data")
and got the result I was looking for not exactly pretty but it works
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

Well heck almost worked

it is not breaking it completely apart. I was so close, so I guess I need more help 😞
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz disregard it helps if you refresh all of your data. Thank you for your help!