Assigning a value to a dropdown selection

[Jakegolden]

Hello,

I am currently trying to create a method that will basically add up all my drop down boxes that have "yes" selected.

I have about 25 dropdown boxes that contain the choices of (Yes, No, N/A) I need the ability to capture all the "yes" and assign it to a value. So if theres 15 boxes with "yes" I need an output that will display 15.

Is this possible?

Thanks!

[WarrenBelz · Accepted solution]

Hi @Jakegolden ,

You would need to hard-code this

0 +
If(
   Dropdown1.Selected.Value = "Yes",
   1
) +
If(
   Dropdown2.Selected.Value = "Yes",
   1
) +
If(
   Dropdown3.Selected.Value = "Yes",
   1
) + . . . . .

and so on for the rest.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps