help with CDS 2.0

[antonio_piernav]

I have an application that collects truck license plate numbers in my CDS 2.0 database, do I need to count the number of entries on the same license plate? I can not do it in any way

ejem.

1111abc

2222acc

3333ccc

1111abc

1111abc

1111abc = 3

[v-monli-msft · Accepted solution]

Hi @antonio_piernav ,

Did you mean that you want to count how many records have the same value in PowerApps? If so, you can use the GroupBy function to group your table by that variable, and then use the CountRows function to calculate the number of items on each group. You could first collect the data to a collection. 

For example, the collection is called 'coll', and the name of the column that has the sample data is 'Name', then the expression below will give you a table that has a column for the name and another with the count of items of that name.

AddColumns(
    GroupBy(coll, "Name", "ByName"),
    "Count",
    CountRows(ByName))

Regards,

Mona