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..
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
88 | |
52 | |
37 | |
33 | |
28 |
User | Count |
---|---|
75 | |
66 | |
50 | |
47 | |
42 |