Hi @Anonymous5,
You need to change the condition of the original expression of the article, the structure is similar to the following:
if(and(greaterOrEquals(variables('Number'),0),lessOrEquals(variables('Number'),20)),variables('varStyle').rowStyleLowValues,variables('varStyle').rowStyleHighValues)
It means if the number is greater than or equals to 0 and less than or equals to 20, return a low value, or return high value.
And the value you can set in the variable shows in the article.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous5,
If you want to change three colors, you could use another if expression to instead of the third parameter of first if expression.
if(and(greaterOrEquals(variables('Number'),0),lessOrEquals(variables('Number'),20)),variables('varStyle').rowStyleLowValues,if(and(greater(variables('Number'),20),lessOrEquals(variables('Number'),40)),variables('varStyle').rowStyleMiddleValues,variables('varStyle').rowStyleHighValues))
If the Number is not greater than or equals to 0 and not less than or equals to 20, perform the second if expression.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous5 , Is this been resolved? I am too looking for some what similar. Want to sent in email.
Example i have table with column name status. If status is risk then red color, if safe then green color, if warning then yellow .
can you share screenshot of your solution..
Hi @Anonymous5,
I had the same problem but I managed to solve it.
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |