web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Counting Choice Field ...

Power Apps

Answered

Counting Choice Field Dropdowns If Values Are Present

(0) Share

Report

Report

Posted on by mkusler

237

I have 5 dropdown boxes in my PowerApp which are connected to a choice column in my SharePoint List. Within SharePoint the options that can be selected are: 0,1,2,3,4, N/A.

Is there a way within the PowerApp I can easily count how many of these boxes have values 0, 1, 2, 3 or 4 in them? I wouldn't want to count BLANK or N/A

For example:

Choice 1: N/A

Choice 2: 4

Choice 3: BLANK

Choice 4: 1

Choice 5: 2

Result: 3

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Here is one way to do it with 3 dropdowns, and 2 possible choices that will return no count

Sum( If(And(test1.Selected.Value<>"", test1.Selected.Value<>"N/A"),1,0), If(And(test2.Selected.Value<>"", test2.Selected.Value<>"N/A"),1,0), If(And(test3.Selected.Value<>"",test3.Selected.Value<>"N/A"),1,0))

In this example it will not count anything with a "" as the result (assume this is what you mean by blank as a dropdown always has something selected and cannot technically be blank) you can change that to "BLANK" if you meant the actual word, or anything with "N/A" as its selection

Was this reply helpful? Yes No
mkusler 237 on at

Like
a
(0)

Report
Copy link

Link copied!

Now that I see that, it makes complete sense and is simple! Thank you so much. I think I overthink this stuff sometimes.

Was this reply helpful? Yes No

Join the conversation