Help formatting text colour in an email based on SharePoint values

(0) Share

Report

Posted on by Wozza

Hi Everyone,

Please redirect me if this has been answered before...many searches, no luck yet!

I have a SharePoint list that I use to formulate emails using Power Automate.

What I need to do is have some text change colour/weight based on the values selected from the SP list.

An example, I'd like text to show something like this in the body of the email:

- This example is HIGH RISK

- This example is Medium Risk

- This example is Low Risk

- This example is Adequate and regular

I can display this using the switch function using its corresponding PowerApp, and I can conditional format the SP list, but I'm not sure how to do this in the body of an automated email using Power Automate.

I hope that makes sense!

Does anyone know of a solution?

Kind regards, Wozza

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

You will need to send the email as HTML, using blocks of text (in variables or compose operations) to construct the email:
See: Send Custom HTML Email Notification with Power Automate Outlook Connector
Ellis

Was this reply helpful? Yes No
Wozza 29 on at

Like (0)

Report

Thanks Ellis - I'll take a look and see how I go.
Much appreciated.
Wozza

Was this reply helpful? Yes No
Wozza 29 on at

Like (0)

Report

Hi Ellis,
Thank you, but it's not exactly what I was after.
As suggested, I created a Compose, chose the specific Dynamic Content and tried using an expression to change the colour based on its value.
Researching further, it seems that you cannot use expressions to change colour (I think it used to be in the expressions.
That's a shame. Now, it seems I am limited to 'hardcoding' a colour for the Dynamic Content, rather that being able to have it change colour based on its value.
☹️
Does anyone know of a different solution?
Kind regards, Wozza

Was this reply helpful? Yes No
Verified answer

fnanfne 260 on at

Like (0)

Report
Hey Wozza

I've been looking for a way to do this as well and found a working solution via an HTML table. However, I wanted to get it working within the Send Email V2 action editor itself, here is the code for the expression I used...

if(equals(outputs('Get_item')?['body/Result/Value'],'Fail'),'red','green')

The above is for a SharePoint list colum called "Result". If this field equals "Fail", the text will be shown in red, otherwise, it will appear green.

Below is a flow I made using three different options; using a variable, using the Compose action, and using the Html to text" action, all these work.

The code in each of the three options is as follows (this is for one column, in this case, one called "Result")

<span style="color:@{if(equals(outputs('Get_item')?['body/Result/Value'],'Fail'),'red','green')}">@{outputs('Get_item')?['body/Result/Value']}</span>

Was this reply helpful? Yes No
Verified answer

Wozza 29 on at

Like (0)

Report

Hi Fnanfne,
Thanks heaps. I'll check it out.

Was this reply helpful? Yes No
CVannest 150 on at

Like (0)

Report

fnanfne,

What if your sharepoint list has 4 options and each option has a color in the list? I have several columns each with the same set of answers and each color code is the same for the columns (Red/Yellow/Green/Light Red)

On the email, I would like the formatting of those colors to come through so we don't have to attach an auxiliary document.
Drop Down Options are:
Red = Observed process not followed
Yellow = Observed process followed at times
Green = Observed process always followed
Light Red = Did not observe

As you can see in the flow, I've created the email format to have 'tables' for the responses under each area. The responses need to be color coded according to what's in the sharepoint list.

Was this reply helpful? Yes No