web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps need to group by galle...

Power Apps

Answered

need to group by gallery based on the emp name

(0) Share

Report

Report

Posted on by Raj2014

70

I need to group by Requestor name into the gallery and I need to show the sum of total No of hours into gallery

gallery items properties I'm using search and dropdown filter
SortByColumns(
Search(
Filter(
KRCAllRequest,
IsBlank(Dropdown1_3.Selected.Value) || IsEmpty(Dropdown1_3.Selected.Value) || Status.Value=Dropdown1_3.Selected.Value),
txtSearch.Text,
"Activity","BU","QualityTask","Name"),
"ID",
Descending
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Raj2014 ,

Please check out this video that provides a tutorial that may help you using the GroupBy function and the use of nested galleries: https://www.youtube.com/watch?v=MDhIjM08u-w
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Raj2014 ,

Maybe you could try:

AddColumns( GroupBy( SortByColumns( Search( Filter( KRCAllRequest, IsBlank(Dropdown1_3.Selected.Value) || IsEmpty(Dropdown1_3.Selected.Value) || Status.Value=Dropdown1_3.Selected.Value ), txtSearch.Text, "Activity","BU","QualityTask","Name" ), "ID", Descending ), "Requestor Name", "NewGroup" ), "SumHours", Sum(NewGroup,'No.of hours') )

Best Regards,

Bof

Join the conversation