cancel
Showing results for
Did you mean:
Helper V

## How to use And/Or

How can I perform an And/or check behind a button

This one works fine

If(Value(Blood1.Text) >= 120 && Value(Blood1.Text) <=129  && Value(Blood2.Text) < 80 ,Set(colorset,"#ffff1a");Set(txtval,"ELEVATED"));

But what if I want to check two text box values using an and/or calculation?
If textbox1 > 80 and/Or  textbox2 > 120

Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

I know what the issue is... I needed to invert the order displayed on the chart when coding it, lol.

``````If(
Value(Blood1.Text) > 180 Or Value(Blood2.Text) > 120,
Red,
Value(Blood1.Text) >=140 Or Value(Blood2.Text) >= 90,
RedOrange,
(Value(Blood1.Text) >= 130 Value(Blood1.Text) <= 139) And (Value(Blood2.Text) >= 80 Value(Blood2.Text) <= 89),
Orange,
(Value(Blood1.Text) >= 120 Value(Blood1.Text) <= 129) And Value(Blood2.Text) < 80,
Yellow,
Value(Blood1.Text) < 120 And Value(Blood2.Text) < 80,
Green
)``````

13 REPLIES 13
Super User III

If(Value(Blood1.Text) >= 120 Or Value(Textbox2.Text) > 120&& Value(Blood1.Text) <=129  && Value(Blood2.Text) < 80 Or Value(Textbox1.Text) > 80,Set(colorset,"#ffff1a");Set(txtval,"ELEVATED"));

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Super User III

@sienna28
Can you please clarify what you want to do with this code?  I don't understand having both the AND and the OR.

If textbox1 > 80 and/Or  textbox2 > 120

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helper V

Thanks for the reply.

It just needs to work for these values

If textbox1 > 80 and/Or  textbox2 > 120

Super User III
@sienna28
I guess what i am asking here is do you want the condition to be AND or OR for your code above: it cannot be both.
Helper V

Please see attached for explanation.

If you notice the second value is where the And/Or is done

Super User II

In your example, the And is irrelevant.  If either value is outside of the range, the result will be flagged. I would just go with the Or condition.

Super User III

Based on your image I would set your conditions like this.

``````If(
Value(Blood1.Text) >= 180 Or Value(Blood2.Text) >= 120,
Set(colorset,"#ffff1a"),
Set(txtval,"ELEVATED")
)``````

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helper V

Hi

That looks like it could be it, but I am not sure how it reads.

Could you please explain that logic to me....does the 180 value come into it?

Many thanks

Helper V

I've attached a better graphic which shows what I am trying to do.

Using the Or condition only in the last option triggers the one above it.

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

#### Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

#### Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (44,995)