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'])))

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
robayala 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No