Change Text Color based on 3 Date values in Power Automate

(0) Share

Report

Posted on by robayala

Requirements:

Create HTML Report from items that are expiring in 45 days and change the text color based on 3 date values.

Example:

Items expiring in 45 Days = Green.

Items that are expiring 30 Days = Orange

Items that are expiring 20 Days = Red

Issue:

The following Expression is working for two items. Can't seem to capture items expiring in 20 days. Need help on expanding this expression to include items expiring in 20 days (red)...Thanks

If (empty(item()?['EndDate']), '', if( lessOrEquals( item()?['EndDate'] , addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 30, 'yyyy-MM-dd')),
concat('', item()?['EndDate'], ''),
concat('', item()?['EndDate'])))

All responses (2)

Answers (1)

robayala 6 on at

Like (0)

Report

Re: Change Text Color based on 3 Date values in Power Automate

@ManishSolanki
That worked! Awesome! Thank you so much for this and your quick reply. Have a great weekend.
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: Change Text Color based on 3 Date values in Power Automate

Hi @robayala

Please use the below expression:

If (empty(item()?['EndDate']), '', if(lessOrEquals( item()?['EndDate'] , addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 20, 'yyyy-MM-dd')),
concat('', item()?['EndDate'], ''),if( lessOrEquals( item()?['EndDate'], addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 30, 'yyyy-MM-dd')),concat('', item()?['EndDate'], ''),concat('', item()?['EndDate']))))

Please let me know if you face any problem & remember to give a 👍 and accept my solution as it will help others in the future.

Thanks