Answered

I need help with conditional formatting (colours) and decimal places

(0) Share

Report

Posted on by gsd0475

I am very new to power apps (like 12 hours since discovering it), i have created an app with an excel table. it is basically scores against different areas of focus. I need to colour the datacard figures according to the score i.e score greater than 4.1 it shows green or less than 4.1 it shows red. I also need a couple of them reducing to 2 decimal places. I have attached screens shots and any help would be greatly appreciated. I have tried all sorts from on these forums to no avail.

Categories:

Building Power Apps

2020-02-13.png

2020-02-13 (1).png

I have the same question (0)

All responses (13)

Answers (2)

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

Hi,
For rounding, you can use the Rounding function. More info here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-round

For conditional formatting, you can try to set the Color property of the data cards that display the figures.
If(Value(Label1.Text)>4.1, Green, Red)

This is assuming Label1 is where your numbers are. Also, you might want to factor in what happens if the number is exactly 4.1

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Verified answer

GarethPrisk 2,828 on at

Like (1)

Report
This would be the Fill property of either the Data Card, or the control within the Data Card, such as a the value control.
If you had a DataCard named DataCard, with the standard 4 controls included DataCardValue, then you could:
Set Fill property of DataCard = If(Value(DataCardValue.Text) > 4.1, Green, Red)
Set Fill property of DataCardValue = If(Value(DataCardValue.Text) > 4.1, Green, Red)
The Fill expects a valid color property. This includes the built-in colors, an RGBA value, or a ColorValue value.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @gsd0475 ,
I will call your field StarRating and assume it is a calculated label.
So in the Color properties of StarRating below is an example of the structure only
If( Round(Value(StarRating.Text),2) > 4.2, Green, Round(Value(StarRating.Text),2) > 3.9, Yellow, Round(Value(StarRating.Text),2) > 3.5, Red )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
gsd0475 24 on at

Like (0)

Report

What box would I put the rounding formula in?
The text box already has Parent.Default in

Thank you

Was this reply helpful? Yes No
gsd0475 24 on at

Like (0)

Report

this is what I have.
If(Round(Value(DataCardValue23.Text),2) > 4.10, Green,Red)
The colour formatting works great but i still have this number 3.971123674253.
Any Ideas?
Thank you for all the help so far

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

In the text box, where it states Parent.Default.

Add Round(Parent.Default, 2)

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
gsd0475 24 on at

Like (0)

Report

I get "invalid argument type (Text) expecting a Number value instead"

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

Ok. Add
Round(Value(Parent.Default, 2))

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
gsd0475 24 on at

Like (0)

Report

Sorry no joy. I have attached a screen shot

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like (1)

Report

Wrap that in a Text() function.

Was this reply helpful? Yes No