Unanswered

[Power Automate Desktop] Conditional formatting on cell value based colours in HTML table in email

(0) Share

Report

Posted on by Douglas2

Hey guys.

I'm building a flow that extracts content from the SQL database, converts it to HTML and sends an email, but I want to change the cell color according to the situation. A simple IF would solve the problem, but I'm facing a syntax error.

%HTMLTable%
<tr>
<td style=\"border: 1px solid black; background-color: #f2f2f2; text-align: center;\">%CurrentItem[0]%</td>
<td style=\"border: 1px solid black; background-color: #f2f2f2; text-align: center;\">%CurrentItem[1]%</td>
<td style=\"border: 1px solid black; background-color: #f2f2f2; text-align: center;\">%CurrentItem[2]%</td>

<td style=\"border: 1px solid black; text-align: center; %IF(CurrentItem[3] > 4, 'background-color: #ff0000;', '')%\">%CurrentItem[3] %</td>

In this example, I want to insert a condition into CurrentItem[3].
If (CurrentItem[3] > 4, background-color = 'red', nothing), like this.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Douglas2,

Please find the below proposed follow with another example:

You cannot include if condition inside the variable instead follow the below approach.
Considering the current item 3, we modified the color while appending the table row.

code:

# Fetch Queryresult from SQL and if query not returns 0 rows then write HTML table for results and embedded that table in outlook message IF QueryResultCount > 0 THEN SET HTMLTable TO $'''<table style=\"border: 1px solid black;\"> <tr> <th style=\"border: 1px solid black; padding: 8px; text-align: left; background-color: hashtag#f2f2f2;\">SL No</th> <th style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">Application</th> <th style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">Login</th> <th style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">STATUS</th> <th style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">ERROR</th> </tr> <tr> ''' LOOP FOREACH CurrentItem IN ExcelData SET HTMLTable TO $'''%HTMLTable% <tr> <td style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">%CurrentItem[0]%</td> <td style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">%CurrentItem[1]%</td> <td style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">%CurrentItem[2]%</td> ''' IF CurrentItem[3] = $'''UP''' THEN SET HTMLTable TO $'''%HTMLTable% <td style=\"border: 1px solid black; background-color: #008000;\">%CurrentItem[3]%</td> <td style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">%CurrentItem[4]%</td> </tr> ''' ELSE SET HTMLTable TO $'''%HTMLTable% <td style=\"border: 1px solid black; background-color:hashtag#FF0000;\">%CurrentItem[3]%</td> <td style=\"border: 1px solid black; background-color: hashtag#f2f2f2;\">%CurrentItem[4]%</td> </tr> ''' END END SET HTMLTable TO $'''%HTMLTable% </table>''' Outlook.SendEmailThroughOutlook.SendEmail Instance: OutlookInstance Account: $'''deenu@microsoft.com''' SendTo: $'''deenu@microsoft.com''' Subject: $'''Fruits stock details''' Body: $'''Hello, Hope your are doing good. Application current status details: %HTMLTable%''' IsBodyHtml: True IsDraft: False ELSE # Fetch Queryresult from SQL and if query returns 0 rows then send email without table Outlook.SendEmailThroughOutlook.SendEmail Instance: OutlookInstance Account: $'''xyz@gmail.com''' SendTo: $'''xyz@gmail.com''' Subject: $'''Fruits stocks ''' Body: $'''Hello, Hope your are doing good. Fruits stocks return null today''' IsBodyHtml: True

Hope this helps!!

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Douglas2 11 on at

Like (1)

Report

@Deenuji Thank you very much! You helped me a lot! I'm following you in Linkedin!

Was this reply helpful? Yes No