Change fill color based on Date

(0) Share

Report

Posted on by Dorinda

1,512

I have a column that needs to change color based on dates.

For instance:

Due in next 365 days (Green)

Turn yellow if today is past due date by 1 day to 10% over cycle

Turn red if today is past due date by over 10% of cycle

The column name is DUE

Can you help me figure out how to do this?

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you have a field to check those 10% ?

After that is just a condition:

If(

DateDiff(ThisItem.Due, Today(), Days) = 1 && OverCycle = 10% ,

Yellow,

If(

ThisItem.Due = Today() && OverCycle >= 10%,

Red,

NormalColor

)

)

Something like that

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!
@Nogueira1306

No extra column to capture the 10%, but here are the mockup formula from excel if that helps

GREEN
If today is >=J135-365 and <=J135
YELLOW
if today > J135 and< .10(K135*365)
RED
if today is >= J135+.10(K135*365)
j135 EQUALS ThisItem.Due
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Assuming 10% is 36.5,

COlor of Label in this example is set to

If( DateDiff(DatePicker7.SelectedDate,DatePicker8.SelectedDate,Days)<=0,Green, And( DateDiff(DatePicker7.SelectedDate,DatePicker8.SelectedDate,Days)>0, DateDiff(DatePicker7.SelectedDate,DatePicker8.SelectedDate,Days)<36.5), Yellow, Red)

Just change datepicker refs out for your refs
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

And for a fill, just put this in fill instead of color 🙂
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!
@TheRobRush I tried what you gave me and have no YELLOW items they are all showing either red or green. I am not sure we have this right
This is what is on the Fill Property
If( DateDiff(Today(),ThisItem.Due,Days)<=0,LightGreen, And( DateDiff(ThisItem.Due,ThisItem.Due,Days)>0, DateDiff(ThisItem.Due,ThisItem.Due,Days)<36.5), Orange, LightCoral)
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Nevermidn I see it, start date needs to be ThisItem.Due, THEN today(), swap those around its backwards
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

It's always something simple right haha