How to apply color to the date field according to the criteria

(0) Share

Report

Posted on by MIA27

My data source is coming from sharepoint list. Which has field called "RenewalDate".

I see the data in the gallery view.

I want to apply color for the following criteria :

If RenewalDate is equal to today date OR less than than today date then apply red color font (this will indicate user that its already expired)

If RenewalDate is greater than today and within the date range of Today+15 days then Blue color font (this will indicate user to prepare as its approaching to expire date)

If this above criteria not there, then let the font color to be blank as normal.

Please guide how to apply this on the gallery data.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BCBuizer 22,535 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @MIA27 ,

In your gallery, select the labels you wish to use this conditional formatting and set the Color property to:

With( { _Renewal: DateDiff( Now(), ThisItem.Created ) }, If( _Renewal < 0, Red, _Renewal < 16, Blue, Black ) )

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

I tried your advised code, as below
In gallery selected the label, and in its color property paste the your advised code, the result is all red, You can note in the data that test records are of 2016 and some of 28/7/2022.

Please advise

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,535 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Hi @MIA27 ,

Apologies, left the wrong column name in the formula while I was testing. Please use:

With( { _Renewal: DateDiff( Now(), ThisItem.RenewalDate ) }, If( _Renewal < 0, Red, _Renewal < 16, Blue, Black ) )

This is how it looks in my test (current date 28/07/2022):

Was this reply helpful? Yes No