Unanswered

Conditional background formatting in HTML Table based on cell values

(0) Share

Report

Posted on by harshjoshiD

Hello,

I'm new to Power Automate and I need to apply a conditional formatting in HTML Table based on cell values. I have an excel file in Sharepoint from which the Table is fetched and an email is sent Daily by converting the table from excel to HTML Table. The scenario is we have certain workitems (IDs) which are in 'Active' state highlighted in 'Red' background. And when the 'IDs' are 'Resolved' they are highlighted in 'Green' background. Sharing below the screenshots:

Now I have created a flow which sends this Table as an email daily.

I get the below output

Is there any way I can apply Conditional Formatting to the Table... If State = 'Active' Then Background = 'Red' Else Background = 'Green'. I want 'Active' background to be Red and 'Resolved' background to be green.

It would be really helpful if any of you can help here 🙂

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @harshjoshiD ,
please refer to the following post:

https://powerusers.microsoft.com/t5/Using-Flows/Conditional-color-formatting-html-table-column-Possible/m-p/642302#M16680

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
harshjoshiD 11 on at

Like (0)

Report

Using below expression did the trick:
if(equals(toUpper(item()?['State']),'ACTIVE'),'<span style="backgroundcolor:#FF0000" onLoad="this.parentElement.style.backgroundColor=red";>Active</span>','<span style="background-color:#00FF00">Resolved</span>')

Was this reply helpful? Yes No