Unanswered

Conditional Formatting with Dates

(2) Share

Report

Posted on by JC-15041439-0

Hi, I am trying to conditional format a gallery depending on the dates of an item. As of now, it is formatting every element as if it is < Today(). I am using the following formula:

 
If(
    CurrentTarea.Fecha2 < Today(), Color.Red,
    Color.White
)
 
 
I have tried using both data types DateTime and DateOnly and using Today() and Now() but it is the same result. Any idea why this happens or if I am using the condition wrong?
 
Edit: The condition is not the issue (or not yet) but CurrentTarea only references the selected Item. ThisItem does not seem to be recognized on my app.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report
HI @JC-15041439-0

Make sure you are formatting correctly

like

DateValue(Text(DateValue("3/11/2025"), "dd/mm/yyyy")) < DateValue(Text(DateValue(Today()), "dd/mm/yyyy"))

Also is this UTC?

make sure your months and days are in the right order, or it will fail and do what its doing to you now

Was this reply helpful? Yes No
JC-15041439-0 51 on at

Like (0)

Report

Hi @Michael E. Gernaey, I think I found out the reason it is not working is because CurrentTarea only references the selected Item rather than check each Item for the condition. I believe I should be using ThisItem, but PowerApps doesn't seem to be recognized. Any idea why this happens?

Was this reply helpful? Yes No