Hello, Is it possible to conditionally format email content that is generated from a SharePoint workflow? I have a field (# of Workdays) that I would like to highlight in the Workflow email based on the value. For values less than 5 = Red, values greater than 5 and less than 13 = yellow and greater than 13 = green. Is there a method to accomplish? Thank You

SharePoint workflow has a condition option, we could use this to do the logical operation. Define a workflow number variable to get the workdays column value. Define a workflow string variable as the body of the email. Judge the number value and set the email body of different color. If the response is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Formatting Content in Workflow Email

Accepted answer

Amos Wu-MSFT 4,051 Reputation points

2021-03-03T06:40:41.557+00:00
SharePoint workflow has a condition option, we could use this to do the logical operation.

Define a workflow number variable to get the workdays column value.

Define a workflow string variable as the body of the email.

Judge the number value and set the email body of different color.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Amos Wu-MSFT 4,051 Reputation points

2021-03-08T03:00:11.707+00:00

Hi @Randal Flinn ,
I am checking to see how things are going there on this issue. Please let us know if you would like further assistance.
You can accept the helpful post as the answer to help other community members find helpful information quickly.

Amos Wu-MSFT 4,051 Reputation points

2021-03-11T03:15:55.23+00:00

Hi @Randal Flinn ,
Do you have any update on this issue?

Randal Flinn 311 Reputation points

2021-03-18T20:30:31.73+00:00

Hello @Amos Wu-MSFT ,

Sorry for the delayed response.

I'm curious how I incorporate this with the workflow I use to send the email. Do I merely add additional Steps (are they in series with these steps or a parallel operation)?

Thanks

Amos Wu-MSFT 4,051 Reputation points

2021-03-19T07:23:36.263+00:00

The general idea is to use the workflow condition option to splice different HTML sentences according to the value range and control the font color, and finally put the spliced sentence in the email body, and the font color of that part will change after the email is sent.
Just finish the string splicing before the send email action.
Sign in to comment

Formatting Content in Workflow Email

0 additional answers