Answered

Expected Record Value

(0) Share

Report

Posted on by AP1979

Hi all,

I have 6 dropdown boxes that should automatically update a Combobox, where for the dropdown boxes I have 0,1 and NA the same for the combobox. For the dropdown boxes, i want that if 2 or more are answered with 0 the combobox is automatically updated to be 0, otherwise 1 and I also want the default to be NA.

Thus far I have tried doing a variable and in the default of the combobox doing the following if statement:

If(
CountIf(questionValuesList, "0") >= 2,
"0",
If(
CountIf(questionValuesList, "0") = 0,
"NA",
"1"
)
)

however I keep getting an error where its stating Expected Record value and I am truly not sure where I am going wrong. Any assistance will be truly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @AP1979 ,

May I ask what is "questionValuesList" in your formula?

Let us assume it is the collection of the results of six dropdowns.

Items of Combo Box:

DefaultSelectedItems:
If( CountIf(questionValuesList,Value = "0") >= 2, ["0"], If( CountIf(questionValuesList,Value = "0") = 0, ["NA"], ["1"] ) )
Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
AP1979 22 on at

Like (0)

Report
Copy link

Link copied!

Hi v-hanytian-msft
the questionValuesList is just the name of my variable.

Was this reply helpful? Yes No