web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Group rows according t...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I need my collection to look like this -

but it currently looks like this in powerapps -

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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" ) )

Best Regards,

Charlie Choi

Was this reply helpful? Yes No

Join the conversation