Answered

Hide the Submit Button based on Multiple conditions

(0) Share

Report

Posted on by golfnutt82

1,362

Hello,
I have two Yes/No fields
I have part of the issue solved where I can show the Submit button if either Yes/No field is true but I am not able to hide the Submit button if both Yes/No fields are true.
I also have a label that shows when both Yes/No fields are true.

In the buttons Visible property I have the following:

I even tried this without success:

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@golfnutt82

Your Visible property is using an OR, meaning that if either one is true, then the control will be visible. As I understand you, you want it to be visible only if both are true.

Please consider changing your Visible Formula to the following:

DataCardValue8.Value && DataCardValue9.Value

You don't need all the redundant true's and false's in the formula or the If statement. The above will evaluate to either true or false already - which is all that is needed.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@golfnutt82

Also, just re-read - perhaps you are saying you want it hidden if both are true.

If so, then change the formula to:

!(DataCardValue8.Value && DataCardValue9.Value)

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

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,
This worked.
Thank you again for a learning experience.
Why the !() vs. not using it in your first example? They look to be the same expect for the exclamation point and parens.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@golfnutt82

The ! is a NOT function. The parens around it are so that we perform the logical AND and then take the NOT of that.

So, breaking the Boolean out.

For : DataCardValue8.Value && DataCardValue9.Value

DataCardValue8 DataCardValue9 Result (Visible)

false false false

true false false

false true false

true true true

For : !(DataCardValue8.Value && DataCardValue9.Value)

DataCardValue8 DataCardValue9 Result (Visible)

false false true

true false true

false true true

true true false

You can see in the last on, the results are just the logical NOT of the first table.

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

Like
a
(1)

Report
Copy link

Link copied!

Very awesome!
Thanks again!

Was this reply helpful? Yes No