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

(0) Share

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 (1)

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