cancel
Showing results for
Did you mean:
New Member

## Select and Change Text Color based on a Date value

The Requirements

Create an HTML report from selected data and change the text of the report based on a date value

For example

If the CAC expiration date is <= 90 days change the text of that item to red

If the CAC expiration date is > 90 days change the text of that item to green

Proposed Solution:

Expression

If (empty(item()?['CAC_x0020_EXPIRATION_X0020_DATE']), "",

if(item()?['CAC_x0020_EXPIRATION_X0020_DATE'] <= addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 90, 'yyyy-MM-dd'),

"<font color= "Red">item()?['CAC_x0020_EXPIRATION_X0020_DATE']</font>" , "<font color= "Green">item()?['CAC_x0020_EXPIRATION_X0020_DATE']</font>"))

The issue:

It always says the expression is invalid

If the expression is taken I would then clean the HTML using a compose with this formula

replace(

replace(

replace(

replace(

replace (

body('Create_HTML_table'), '&lt;', '<'

),

'&gt;' , '>'

),

'&amp;', '&'

),

'&#39;', '"'

),

'&quot;', '"'

)

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

Hi @jbloom ,

There are some syntax errors in your expression.

``````If (empty(item()?['your column name']), '',

Best Regards,

Wearsky

3 REPLIES 3
Solution Sage

Hi @jbloom ,

Can you try using the alternate approach to calculate difference between two dates using below url :

https://sympmarc.com/2021/02/22/calculate-the-difference-between-two-dates-in-power-automate/

Thanks

Community Support

Hi @jbloom ,

There are some syntax errors in your expression.

``````If (empty(item()?['your column name']), '',

Best Regards,

Wearsky

Frequent Visitor

Hi

My input to the Create HTML is based on items expiring in 45 Days. I would like my output to reflect:

items expiring in 30 Days = Orange
items expiring in 20 Days = Red
Everything else outside this date range = Green

I have the following expression working great but only for items expiring 30 days (orange). How do I include additional script in this expression to capture items expiring 20 days (red)?  Not having much luck.

If (empty(item()?['EndDate']), '', if( lessOrEquals( item()?['EndDate'] , addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 30, 'yyyy-MM-dd')),
concat('<span style="color:orange">', item()?['EndDate'], '</span>'),
concat('<span style="color:Green">', item()?['EndDate'])))

I really appreciate your help with this,

Thanks
Rob

Announcements