
Announcements
Edit: Now solved, I kept the original colour change on the Fill but also changed the Visibility settings. This can be closed.
Hi All,
Im looking to change the fill of a label if the date that has been entered into it has now been and gone, this I can do:
If(ThisItem.EnteredDate < Today(), Color.Red, Color.White)
The issue I'm experiencing is putting in the caveat that if the label is empty / blank, if it is I need it to also be white.
I tried numerous If statements and put an "Or(" in there but Im not getting the right mix.
Can anyone help?
TIA 🙂
Hi @MiniMe_83 ,
my workaround for this situation when i'm showing the date in a label is usually something like that
If(ThisItem.data >= Today() || Text(ThisItem.data) = "" , Color.White, Color.Red)
Hope it helps.
Francesco