Answered

Change font color based on specific text | HTML table in email

(0) Share

Report

Posted on by tfernandes

Hello!!

I am recreating an excel table in power automate to be sent by email. I already have my table, however I want that font Color of the 'column 3' to change to Green when the word "GREEN" is found and red when the word "RED" is found. I tried several different things and nothing works.

Final table that I have now and I want to change the color of the word GREEN to green and the same for red in the third column..

Essentially I need the code to conditionally format the text when the email is sent out.

Thank you in advance!!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tfernandes ,

I've made a test for your reference:

replace(replace(body('Create_HTML_table'),'Red','<span style="color:red;">Red</span>'),'Green','<span style="color:green;">Red</span>')

Best Regards,

Bof

Was this reply helpful? Yes No
tfernandes 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply but I need to know where I should add this steps, because I already have my flow working and also my own "create html", "compose", etc functions. In witch step I have to insert the initialize variable and the other too? I tried several different ways without success. I will send you my flow detailed.

Was this reply helpful? Yes No
bensat2 75 on at

Like (0)

Report
Copy link

Link copied!

i have similar requirement , in power automate desktop if the html output in the outlook has the word "NotMatched it should be in red and if it is Matched it should remain black.

Was this reply helpful? Yes No