Help formatting text colour in an email based on SharePoint values

[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

[ekarim2020]

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

[Wozza]

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

Much appreciated.

Wozza

[Wozza]

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

[fnanfne · Accepted solution]

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>

[Wozza · Accepted solution]

Hi Fnanfne,

Thanks heaps. I'll check it out.

[CVannest]

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.