Unanswered

Conditional Text Color in HTML Table

(0) Share

Report

Posted on by DeliD

I've built a flow that queries a SharePoint List for information, then builds an HTML table and sends a filtered view via email. I'd like to highlight the status fields with different colored font (or cell color) based on what is in these fields (Blocked/No Issues/At Risk).

I've watched some videos and tried some if(equals...) coding, but the most recent version results in the font color always being the same (bright green), even though the logic states it should be red.

The high-level view of my flow is:

- Get Items (filtered list)

- "Select" action to build the table (this is where I've used the following to try the conditional font color)

- This is the logic I'm using in the fxn below: if(equals(item()?['OverallStatus']?['Value'], 'Blocked'),'red', 'green')

This is the resulting table:

I plan to use the same logic in the remaining status fields, but am trying to dial it in with Overall first.

Any help would be GREATLY appreciated!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Hi @DeliD ,

From your screenshot, when the value of OverallStatus is Blocked, the expression returns false, please check whether this expression can get the value of OverallStatus.

item()?['OverallStatus']?['Value']

Or can you tell me the type of column?

Could you please show the entire flow?

Best regards,

Rimmon

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @DeliD

HTML formatting in a Select data operation is treated as text.
In other words, you wouldn't get the actual colour even if you created an HTML table from the Select.

Instead, you would get the following text in the Overall Status column:
<font color='red'>Blocked</font>

How are you getting an actual colour in the Excel file?
Is there another action after the Select?

Was this reply helpful? Yes No
DeliD 5 on at

Like (0)

Report

Thanks for the responses, I'm adding more details to hopefully help.
Here's the overall flow, at least the section in question:
I use the output of the Select action as the input and basis to build the HTML table.
Then via a Compose action, I format the table using some modifications to the styling from Ryan MacLean's blog post:
https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/

My thought is that yes, the expression is coming back false, but even if I use orange and purple as the colors, the "Blocked" font still shows up as that bright green in the emailed table.

Thank you for the help!

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
@DeliD

Can you simply output the value of OverallStatus in the select (no if statements).
Then I'm guessing your Compose action that's applying the styling after the Create HTML table action, is something like:
replace(body('Create_HTML_table'),'<table>','<table border=1>')
...and maybe more.

Could you post the possible outcomes of OverallStatus and also post the code you have in the Compose that's formatting the HTML table?

Was this reply helpful? Yes No