Unanswered

Conditional Formatting of dates in power automate

(0) Share

Report

Posted on by prasannaamle30

I am trying to make HTML table from excel sheet in automate, I have converted number date into date format using this expression

if(empty(item()?['Customer Due Date']),null,addDays('1899-12-30',int(item()?['Customer Due Date']),'yyyy-MM-dd'))

Now I want to apply conditional formatting like if date is less than currentUTC then color should be red, otherwise green.

how to achieve this in HTML table ?

Categories:

General topics

All responses (3)

Answers (0)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @prasannaamle30,

Try something like a style tag in your Select action.

Below is an example

Value field in the Select

<p style="color:@{if(less(item()?['CustomerDueDate'], utcNow()), 'red', 'green')}">@{if(empty(item()?['CustomerDueDate']), null, item()?['CustomerDueDate'])}</p>

Output with a couple of replace functions in the Send an email v2 action

replace(replace(replace(body('Create_HTML_table'),'<','<'),'"','"'),'>','>')
prasannaamle30 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for your help but problem is dates are in number format and I want to convert that numbers to dates and at the same time I want to add conditional formatting, If I try to convert numbers into dates in compose and then pass that output for conditional formatting then it is showing as an error. How to resolve this ?
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @prasannaamle30,

My example was just to show how you could use HTML in a Select. You could also use the expression you used earlier in that same type of setup.

I have adapted my example to use your number expression instead. Also updated it to use a concat function as well (makes copy/pasting into the expression tab a bit easier)

Can you try the below in the Select instead? (add via expression tab)

concat('<p style="color:', if(empty(item()?['Customer Due Date']),null,if(less(addDays('1899-12-30',int(item()?['Customer Due Date']),'yyyy-MM-dd'), utcNow()), 'red', 'green')), '">', if(empty(item()?['Customer Due Date']),null,addDays('1899-12-30',int(item()?['Customer Due Date']),'yyyy-MM-dd')), '</p>')