SharePoint Designer Workflow Emails - Tips and Tricks

By:   |   Comments   |   Related: > SharePoint


Creating efficient SharePoint Designer Workflow emails can be tricky. There are a couple of salient points you need to know in order to leverage this to its full extent. In this article we will discuss these points.


You can visit this MS post in order to get familiar with the basic features. In this article, I would like to discuss some advanced features here that make SharePoint workflow emails more efficient.

  • Showing dynamic list/library values in email: When you open the "Define Email Message" window, you will see the "Add Lookup to Body" button at the bottom left corner. If you click on that, it opens a "Define Lookup" window which can be used to add dynamic values. You can do the following:
    • Current Item - Choosing this source will enable you to add attributes to the current items of the list to which the workflow is attached.
    • Workflow Data - This will display all the dynamic variables which you have declared in the current workflow.
    • All available Lists and Libraries - You can choose a particular list/library to access its fields values.
    current item
  • Show direct document/list links in the body of email: In order to show a direct link to a document or list item (of current item), you need to provide a lookup value for list/library columns (especially the ID). See the example below. You can use the source attribute to add the redirect URL too.
  • sample list
  • Dealing with Blank values: On the SharePoint server, SP1 blank values shows as ";;;;;". This might look crude to users. In order to get rid of these, create a variable and set this to "Blank", "NA", "None" or some other meaningful value if the column value is empty. And if the column value is not empty then set its value to the variable. Then use this variable instead of column in the email. In order to use variable select "Workflow Data" as source in "Define Workflow Lookup".
  • conditions
Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Ved Mishra Ved Mishra

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms