Answered

Fields visible property not being evaluated unless check box is actioned

(0) Share

Report

Posted on by golfnutt82

1,362

I have a few controls on a form and each of these fields have a formula that evaluates the check box "Budgeted".
If it is checked checked true and the rest of the formula is true then show x controls or if its not true and if it is and the rest of the formula is true then dont show x controls.

<visible property control 1>= If(
chkBudgeted.Value = true && Value(txtTotalAmount.Text) > 9999,
true,
false
) || If(
chkBudgeted.Value = false && Value(txtTotalAmount.Text) >= 1500 && Value(txtTotalAmount.Text) <= 49999,
true,
false
) || If(
chkBudgeted.Value = false && Value(txtTotalAmount.Text) > 49999,
true,
false
)

I have fields that hold a Quantity value and one that holds a Dollar value and if the Total Amount value falls in between the values above then it should show certain fields based on the "Budgeted" checkbox value.

If I check the "Budgeted" check box and then uncheck it, the formula runs and then shows the fields. Ugh 😛

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
You put || between your separate If checks, so if any of them is true, they are true.

Yours is like this:

(If A=1) || (If B=2)

in which case, if EITHER of them are ture, the whole thing equates to true:

(true) || (false) = true

(false) || (true) = true

So you should do them like this instead:

If( chkBudgeted.Value = true && Value(txtTotalAmount.Text) > 9999, true, //else if chkBudgeted.Value = false && Value(txtTotalAmount.Text) >= 1500 && Value(txtTotalAmount.Text) <= 49999, true, //else if chkBudgeted.Value = false && Value(txtTotalAmount.Text) > 49999, true, //else false )

Cheers,

Sancho

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(1)

Report
Copy link

Link copied!

Got it! Awesom! Thank you!

Was this reply helpful? Yes No