Answered

Adding background color to HTML table cell based on condition

(0) Share

Report

Posted on by SMiller3

I created a table in an email using HTML code (because it worked better than creating the table with Create HTML Table). Here is the part of the HTML:

that produces this result below the column headers:

Entry	Previous	UPDATE
Quantity	1	2

I need to change the background color of the Quantity UPDATE cell when the quantity changes from previous.

When I create the following formula in a compose and place its output right before output for the update column, it just puts the word yellow before the 2.

if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Quantity'],'yellow',)

How should the expression look to achieve desired result and where exactly should the output be placed in the HTML?

TYIA

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @SMiller3 here is an example about using if as expression

If (true/false,if true,if false)

As you can see you need to provide first a true or false value. How can you get that? maybe using another expression like empty(). For example: If Column is empty then true, if no then false.

If(empty(Column),'ShowBlackColor', ShowYellow)

As you are working on HTML I'll replace the css code with my expression.

so you can try if(true/false,'style='color:black'',style='color:yellow')

Was this reply helpful? Yes No
SMiller3 52 on at

Like (0)

Report
Copy link

Link copied!

I think I have the formula with the condition, but am having trouble placing it in the html.

I made a simpler expression just to get the cell to turn yellow:

style=\"background-color:yellow;

and put it in the html as below:

This is the result:
If placed right before dynamic content, I get this:
And when I placed the style color expression between <td and width=252, I get this:

Does anyone know where to put the expression so it will look like this?

Was this reply helpful? Yes No
Verified answer

SMiller3 52 on at

Like (0)

Report
Copy link

Link copied!

For anyone that's interested, I was able to figure this out.

Based on the original example, I created a compose action with if expression:

In the body of the email, I inserted the outputs from above right before <p class=MsoNormal following the <td for the relevant cell:

Notice (highlighted in yellow) that the space between <p and class needs to be removed and another </p> needs to be added (its initial<p is in the compose action).

The result is:

Was this reply helpful? Yes No