Email Formatting Output

[DeanLascota]

Hi,

I am creating a simple workflow that sends a table for specific users based on my output data. Unfortunately, I am unable to send a screenshot here as I am working with sensitive data. what I am doing is creating conditional formats on my cells with values that are based on specific thresholds. I am using HTML tags on the values. 

Apparently, the email output tool only detects each tagging as plain text hence my table output has the tags added within the field instead of it formatting each field accrodingly.

Thank you in advance.

Workflow Example: 

Formula Tool (conditionally add html tags into each cell value based on threshold)

• If [Value] > 0 then '<td style="background-color: #50C878;">' + ToString([Value]) + "%" + "</td>"

Then I work my way into a table tool > layout > email tool

The output is a mess. Need your help please ☺

[dreldrel]

Maybe you could use control containers to decide each email tool to send to different specific users. Hope this helps

[KGT]

I don't have the time to dig out the methods or test them, but I can comment some things to look for and research. The way that the element is constructed is important as the tools then construct their own pieces out of the data. Use of <htmlpassthrough> is important, as you are trying to pass html to the relevant tool without it trying to wrap on the way. And I think you want to use a layout in the body of the email, so make sure that is the field you're passing to the body.

I had a quick search, and this workflow looks promising, but you may need to adjust/play with it as it's 5 years old and a specific purpose.