Count Items in Choicec Field

(0) Share

Report

Posted on by 007Test007

Hi, I created a field from datatyp choices.

Now I want to look up how many choices where selected.

How can I do this?

What I do .. but doesn`t work:

I want to make a calculated field from datatyp decimal number, but if I want to calculate, I cant find the choices field.

Thank you so much for your help

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @007Test007 ,

Assuming you used a ComboBox for this, you can get the number of selected items using the below formula:

CountRows(YourComboBox.SelectedItems)

In this you'll have to change YourComboBox with the actual name of your combobox control.

Was this reply helpful? Yes No
007Test007 10 on at

Like (0)

Report
Copy link

Link copied!

Hi BCBuizer,
do I have to do this with a flow or can I use a calculated field?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @007Test007 ,

No need to use a flow, this code will return the count of the selected choices in a combobox. You can, for instance, use it to set the Text property of a label to display it, or include it in a Patch function to save it to a data source.

If you can advise what you want to do with the value, we can have a look at how to incorporate this code.

Was this reply helpful? Yes No
007Test007 10 on at

Like (0)

Report
Copy link

Link copied!

Hi BCBuizer, I want to put the result in a separated field, because I want to use the result in a calculated field.

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @007Test007,

What control are you looking to use for that?

Perhaps a Label to show the value by using the code in the Text property:

Was this reply helpful? Yes No
007Test007 10 on at

Like (0)

Report
Copy link

Link copied!

Hello @BCBuizer,
I try to describe my problem more detailed.
I`m in a table with a column called "number". The column "number" is from data type "Decimal Number". I select calculated.
I have another column called "fruites" from data type "choices".
Now I want to put the number of selected choices from the column "fruits" in the column "number".
But if I want to make a calculation in the column "number", I cant find the column "fruits".
I hope It helps a little bit more about where is my problem.

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @007Test007 ,

Are you talking about SharePoint or PowerApps? Since this is the PowerApps community I assumed you were asking about PowerApps.

Was this reply helpful? Yes No
007Test007 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @BCBuizer ,
so I think I`m in Power Apps ... isn`t it?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @007Test007,

Seems more like Dataverse: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields

From what I can see, in the documentation, there is no support for any kind of Count function as a calculated column. However, you can still perform this function at your input (Canvas App/SharePoint) to update the column with an automatically calculated value.

Was this reply helpful? Yes No
007Test007 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @BCBuizer,
sorry but I don`t know how I can do this .. I´m a totally newbie.
I have a modeldriven App.

Was this reply helpful? Yes No