Visibility based on value

(0) Share

Report

Posted on by Marty_Dub

121

Hi team,

I have a value being returned based on the average of 7 other values throughout my app. The average value will always be between 0 and 3.

I have 3 symbols which I am wanting to show or hide depending on this value. My intention is for a "smiley face" to be visible if the average value is equal to or greater than 2. An "unsure face" if the value is greater than or equal to 1 but less than 2, and a "sad face" if the value is greater than or equal to 0 but less than 1.

For the visible parameter of the "smiley face", I have: If(AverageResult>=2,true,false)

I am stuck however on how to phrase the code for the "unsure" and "sad" faces, since I essentially need 2 arguments for greater than or equal to and less than.

I hope this makes sense and that someone out there has a better mathematical brain than me.

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Hi @Marty_Dub ,

Please try:
unsure visible parameter:
If(And(AverageResult>=1,AverageResult<2),true,false)
sad visible parameter:
If(And(AverageResult>=0,AverageResult<1),true,false)

Best Regards,
Dezhi

Was this reply helpful? Yes No