Unanswered

How to count dropdown options within a Form

(0) Share

Report

Posted on by JohanSmith-07

Hi, I have a "master form" that consolidates about 35 answers given by users through different screens, I need to count the number of filled questions in my "master form" so that I can calculate a completion rate.

I tried creating a variable called Count_Fields_Filled and use it in the OnChange property of every field:

the datacardvalue589 is a dropdown list within my form.

If(
 DataCardValue589.Selected.Value = Blank(),
 Count_Fields_Filled + 1,
 Count_Fields_Filled
)

Then I used the Count_Fields_Filled in a label, just show the total count but it shows 0 so it is not working.

How could I count if the field has a value selected by the user? I also tried with IsEmpty and IsBlank but still not working,

If(
 IsEmpty(DataCardValue589.Selected.Value),
 Count_Fields_Filled + 1,
 Count_Fields_Filled
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JohanSmith-07

Set(Count_Fields_Filled, Count_Fields_Filled+1)

Was this reply helpful? Yes No
Tony_Bowes_BP 280 on at

Like (0)

Report
It feels like this code would fire in EACH OnChange, so modifying the same variable 15 times would give you a count of 15 when in fact it's only one answer.

A potentially better way to do it would be to simply display the results of a formula that adds up all non-blank answers.
Formula would be something like:
(If(IsBlank(TextInput1.Text),0,1) + If(IsBlank(TextInput2.Text),0,1) + If(IsBlank(TextInput3.Text),0,1) )

Was this reply helpful? Yes No
JohanSmith-07 59 on at

Like (0)

Report

Thanks @Tony_Bowes_BP for some reason, when I delete a response from the form, the result is still counting it, it's like the result keeps on the cache memory or something, the following image should count 1 but as it had a response in 1.1 and then I delete it, it kept the counting. Any alternative to prevent this to happen?

Was this reply helpful? Yes No
Tony_Bowes_BP 280 on at

Like (0)

Report

For combo boxes, try checking against the value of the selected item: Eg: IsBlank(ComboBox1.Selected.Value1)

Was this reply helpful? Yes No
JohanSmith-07 59 on at

Like (0)

Report

@Tony_Bowes_BP I did it but I'm having the same result

Was this reply helpful? Yes No
Tony_Bowes_BP 280 on at

Like (0)

Report
Here's an example of only 1 tex box filled:
Then selecting one of the combobox items:

Then deleting the selection:

Code for the text label on the left is:

Concatenate((If(IsBlank(TextInput1.Text),0,1) + If(IsBlank(TextInput2.Text),0,1) + If(IsBlank(ComboBox1.Selected.Value1),0,1)) , " out of 3")

Depending on your combobox it might not be Value1 but the column name of the droplist options.
Another way to debug would be to link up a TextLabel to the same value that you are trying to compare so you can visually see what the value is.

Was this reply helpful? Yes No