Solved! Go to Solution.
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
)
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.
@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."
Thanks for the reply.
It just needs to work for these values
If textbox1 > 80 and/Or textbox2 > 120
Hi @sienna28
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.
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."
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
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
252 | |
248 | |
85 | |
36 | |
31 |
User | Count |
---|---|
330 | |
260 | |
123 | |
69 | |
44 |