Answered

Change Icon Color based on Number Value (Simple!)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My app currently tracks the number of days since we last invoiced our client with a DateDiff function

DateDiff(DataCardValue12.SelectedDate,Today())

I have placed circle icons on my app that I want to change color based on how many days it has been since the invoice has been sent (like a color status update).

A green circle for most recent and red being a very long time.

It seems sooooo easy but I cannot figure it out. Here is my if statement in the fill property of a circle:

If('Number of Days' > 1, Green, LightGray)

*Number of Days is name of the text label where the DateDiff function is found

The error I get is that If statement is expecting a number but I've tried 'Number of Days'.Value and that doesn't work either.

Thanks for the help!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

If(Value('Number of Days'.Text) > 1, Green, LightGray)

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks so much! I thought I had tried that solution at one point and dismissed it completely!
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Woah, that is great. Thanks!
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

haha oops he beat me to it
echodapogi 516 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Reza,

I have same scenario of this problem but i cannot figure it out how to work. Can you also please help?

I have a TextInput box and a rectangle color box, i want to change the color based on the values of the text input.
here is my code. but i cannot work on the between value of between <=0.5 and <=0.9.

If(Value(TextInput2.Text) < 0.5, Red,
If(Value(TextInput2.Text) <=0.5 && Value(TextInput2.Text) <= 0.9, Yellow,
If(Value(TextInput2.Text) >=1, Green,
Black

)))

i need to do color coding in the box based on this formula.
<0.4 Red
<= 0.5 and <1 Yellow
>=1 Green

Thanks in Advance

Echo