A list of choices in a column and totalling number of times a choice has been chosen

(0) Share

Report

Posted on by Learnean

I have a choice column with model names of printers. I want a simple list where you can see:

Model / Number of times chosen

C257 / 3

C259 /10

I tried getting this to work for hours but no luck. It should be fairly simple for anyone experienced, I would appreciate any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Learnean

The GroupBy function in Power Apps to group your choice column by the model names and then count the number of records in each group. You can then display the result in a gallery or a table.
Assume that your choice column is named Model and it is in a data source named Printers.
Create a collection named ModelCount using this formula:
ClearCollect( ModelCount, GroupBy(Printers, "Model", "Group") )
To count the number of times each model has been chosen, you can add another column to the collection using this formula:
AddColumns( ModelCount, "Count", CountRows(Group) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Learnean 15 on at

Like (0)

Report
Copy link

Link copied!
I get "Invalid number of arguments: received 2, expected 3 or more"
GroupBy('Lists metadata', "Model", "Group")

This is what my sharepoint list looks like:

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Learnean

Based on the documentation the code should work https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-groupby#group-records.

Do you have a screenshot of the code? In the formula bar, so I can have a better look why it gives a error.

Was this reply helpful? Yes No
Learnean 15 on at

Like (0)

Report
Copy link

Link copied!
That error went away but now: "The specified column "Model" does not exist.
ClearCollect( ModelCount, GroupBy('Lists metadata', "Model", "Group") ); AddColumns( ModelCount, "Count", CountRows(Group) )
It clearly does exist. I changed it to a column with text and it worked then. but not Mode which is choice?

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please check the column schema name of Model and adjust it to that.
Model may be the name of the column but Powerapps use the column schema name.

Was this reply helpful? Yes No
Learnean 15 on at

Like (0)

Report
Copy link

Link copied!
Ok, so the name should be field_7. When I changed it to that, I get "Expected a text, numeric, boolean, or date/time value."

ClearCollect( ModelCount, GroupBy('Lists metadata', "field_7", "Group") ); AddColumns( ModelCount, "Count", CountRows(Group) )

Was this reply helpful? Yes No