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

[mozzerellagoril]

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 😕

[v-yujincui-msft · Accepted solution]

Hi @mozzerellagoril ,

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