Email Formatting Output

Question

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 '' + ToString([Value]) + "%" + "" Then I work my way into a table tool > layout > email tool The output is a mess. Need your help please ☺

jrlindem · Answer

Reading though your ask and the above comments...  Wondering if the HTML or conditional formatting is absolutely necessary?

If you needed conditional formatting in an excel output, then you can build that into the template file and simply write the data into that file and the formatting should be retained.  Alternatively, if you're just needing to send a small table of values that are directly placed into the email body, then flagging those values and filtering seems like a simpler approach?  Otherwise, if you need both "acceptable" and "unacceptable" values in the same output table and the formatting isn't possible, then simply flagging the values might be an alternative idea.

I've also created separate output tables and attached them into emails a separate objects instead of all in one.

Rambling now, but "thinking out loud" on other ideas to get your need moving along without holding strictly to your "most desired" outcome.  Hope this helps,  -Jay

KGT · Answer

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.

dreldrel · Answer

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