Change Icon Color based on Number Value (Simple!)

[zalandoe]

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!

[RezaDorrani · Accepted solution]

Hi @zalandoe 

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

[zalandoe]

Thanks so much! I thought I had tried that solution at one point and dismissed it completely!

[TheRobRush]

[zalandoe]

Woah, that is great. Thanks!

[TheRobRush]

haha oops he beat me to it