Set Condition for an answer

(0) Share

Report

Posted on by Quincy_Chan

Hi All,

I would be pleased if I could get some help here.

I created a form with 80 questions included, and each of them has its own "Not Meet Condition"

The fields <SLY>, <HLY>, <TJPY>, <ANY> and <EEY> are number fields, default value is blank;

<QuestionNumberLabel> is a dropdown list with the Question Number Listed;

For question 8, I want to show "Not Meet"

when <SLY>/ <HLY>/ <TJPY> / <ANY> /<EEY> are not blank (That means someone filled with value)

and the value of either one of them is <1.

However, when I use this formula, it works only for <SLY> but not for the rest of the fields.

Would you please let me know what is missing? I appreciate your help!

If(

(Value(QuestionNumberLabel.Selected.'Question Number') = 8 && (((!IsBlank(SLY.Text)) && Value(SLY.Text) <1) || ((!IsBlank(HLY.Text)) && Value(HLY.Text) <1) ||

((!IsBlank(TJPY.Text)) && Value(TJPY.Text) <1) ||

((!IsBlank(ANY.Text)) && Value(ANY.Text) <1) ||

((!IsBlank(EEY.Text)) && Value(EEY.Text) <1))),

"Not Meet", "Meet")

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @Quincy_Chan

can u try this:

If( Value(QuestionNumberLabel.Selected.'Question Number') = 8 && ( (!IsBlank(SLY.Text) && Value(SLY.Text) < 1) || (!IsBlank(HLY.Text) && Value(HLY.Text) < 1) || (!IsBlank(TJPY.Text) && Value(TJPY.Text) < 1) || (!IsBlank(ANY.Text) && Value(ANY.Text) < 1) || (!IsBlank(EEY.Text) && Value(EEY.Text) < 1) ), "Not Meet", "Meet" )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Quincy_Chan 27 on at

Like (0)

Report
Copy link

Link copied!

Thank for your prompt reply, but it is not working.

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

do you recieve any error msg? if yes please share what it says

Was this reply helpful? Yes No
Quincy_Chan 27 on at

Like (0)

Report
Copy link

Link copied!

Hi @mmbr1606
No, but I expected that when I input value "2" in <HLY>, the result should be "Meet", not it works only for <SLY>

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
can u try this approach:

If( Value(QuestionNumberLabel.Selected.'Question Number') = 8 && ( (!IsBlank(SLY.Text) && Value(SLY.Text) < 1) || (!IsBlank(HLY.Text) && Value(HLY.Text) < 1) || (!IsBlank(TJPY.Text) && Value(TJPY.Text) < 1) || (!IsBlank(ANY.Text) && Value(ANY.Text) < 1) || (!IsBlank(EEY.Text) && Value(EEY.Text) < 1) ), "Not Meet", "Meet" )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Quincy_Chan 27 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, it is still not working 😞

Was this reply helpful? Yes No