web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Group rows according t...
Power Apps
Answered

Group rows according to ID and counting the number of rows of each ID

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I need my collection to look like this -

mozzerellagoril_0-1664848364585.png

 

but it currently looks like this in powerapps -

mozzerellagoril_1-1664848495337.png

It counts all of the rows regardless of cl_code. 

This is the current formula... 

 

ClearCollect(
Attendance,
DropColumns(
AddColumns(
GroupBy(c_signups,"cl_code","Signups"),
"No. of signups",CountRows(c_signups.cl_code)
),
"Signups"
)
);

 

Not sure how to fix it as I thought countrows would follow groupby 😕

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Maybe you could try the following formula:

     

    ClearCollect(
     Attendance,
     DropColumns(
     AddColumns(
     GroupBy(c_signups,"cl_code","Signups"),
     "No. of signups",
     CountRows(ThisRecord.Signups)
     ),
     "Signups"
     )
    )

     

    vyujincuimsft_0-1664855706537.png

     

     

    Best Regards,

    Charlie Choi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard