
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 😕
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