Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
SQL Server Transparent Data Encryption Alternative - Free Webinar
 

SharePoint Designer Workflow Emails - Tips and Tricks


By:   |   Last Updated: 2011-07-19   |   Comments   |   Related Tips: > Sharepoint

Problem

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.

Solution

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


Last Updated: 2011-07-19


next webcast button


next tip button



About the author





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools