Pages

Tuesday, April 24, 2012

SharePoint 2010 - How to change the approval workflow e-mail messages with SharePoint Designer

In SharePoint Designer 2010 you have the option to attach and customize an approval workflow to a list or library. The workflow will send out multiple e-mails to initiator and approver(s). These e-mails can be modified. Let’s take a look!

The following e-mail is send to the approver of the workflow:

 












Customers are often not happy with the text of the e-mail because they want to make it more personal. I agree with this so we often change it. In the article I want to show you how this works.

In my example I attached an approval task to a document library:

image

Click at Approval:

image

Now you have the option to change the configuration of the approval workflow! Not only the e-mail messages but you can also create multiple outcomes. To change the e-mail to the approver you have to click at Change the behavior of a single task:

image

Click at Current Task:Assigned To:

image

Do you recognize the text? This is the e-mail message send to the approver! We can start changing the text. Let’s make it more personal. Delete all the text above To complete this task and create the following text:

Dear “Full name of the approver”,

You are assigned by “Full name initiator” to approve the document: “Name document”.

Let’s start building this new e-mail.

Full name of the approver
Click at Add or Change lookup and a pop-up will appear:

image

You can now look for a value you want to use in the e-mail, in our case we want to show the display name of the Approver. Let’s select the following:

image

Instead of Display Name you can also pick e-mail address or login name but display name is more user friendly.

Full name initiator
Click at Add or Change lookup and select the following:

image

“Name document”
Click at Add or Change lookup and select the following:

image

The e-mail send to the approver contains a button Open this task. This will open the following menu:

image

It can happen this form won’t open so I always like to add a link to the SharePoint URL to open the form in the browser. You have to do the following:
Click at this button image and:

image

The e-mail will contain a hyperlink to the online approval form:

image

Pretty cool right? You can also change the look and feel of the approval form with InfoPath. Go the the Forms section of the workflow settings and change this. I will show this in another article.

You are now ready to publish the workflow and you can test the changes by uploading a new document and check the e-mail.

We only changed one e-mail but there are many more:
  • Approval e-mail to the approvers
  • Cancellation of the task
  • Completion of the task
To change these you have to go through the the following options:

image

My advice is to first receive one of these e-mails and then look for them in an e-mail action in one of the options of the screenshot!

Edit
Also check out my follow-up article:

http://www.jasperoosterveld.com/2012/10/sharepoint-2010-workflow-remove-or.html

27 replies:

always_asking_why said...

Have you written the other article to change the other emails?

Thanks
Kim

Jasper Oosterveld said...

Hi Kim,

Thanks for your reply. I have not but please let me know what you need to know so I can try to help you.

Ryan said...

Howdy! Thanks for writing this - great article!

Do you happen to know how to maintain approvers in a sharepoint list and 'query' by job title?

Thanks a bunch! Ryan

Jasper Oosterveld said...

Hi Ryan,

Thanks :-)

Could you be a bit more specific in what you are trying to achieve exactly?

CRJAngel said...

Wow this was great! Little things count for a lot! Thanks!

Anonymous said...

hi,

I am working on the same functionality as mentioned in this article.But i am getting an issue while implementing it.

The issue is : I am not getting online approval form in the window .The window opens with some sharepoint links but does not render infopath approval form.

Can anyone help me in this ?

Priya

Jasper Oosterveld said...

Hi Priya,

What window do you mean exactly? Can you explain all the steps you did? That is a bit easier to troubleshoot for me.

Dorothy said...

Hi guys,do you know how can i change the auto reply sent to the initiator as well?

-----------------------------------------------------------------------
Approval has started on ***.
Participants are ***
Due by None
Each person will receive a task to approve ***. The tasks will be assigned one at a time for participants shown above.

__________________________________________________
View the status of this workflow.


Please help!!
Dorothy

Jasper Oosterveld said...

Hi Dorothy,

I don't have SharePoint Designer in front of me but you have to click at the Approval action. You get this screen:

http://lh6.ggpht.com/-gKvFtyXR0q0/T5Y9OuC9TnI/AAAAAAAAA1E/EJqSC9ua_ek/s1600-h/image16.png

Click at one of the three links under Customization. Look for an e-mail action and compare your e-mail. This is an easy way to find the e-mails that are send. You are now able to change the e-mail lay-out.

Dorothy said...

Thanks Jasper! I have one more query... once an approval workflow is approved, is it possible that the uploaded document could be frozen that no one could modify?

Jasper Oosterveld said...

No problem at all. I am thinking of the following options:

1. Use a condition that checks if the approval workflow is approved. Use the Declare Record action to freeze the record.

2. Add an impersonation step and check if the approval workflow is approved. Use the Remove List Item Permissions actions to set it at read only.

Worth a shot :)

Dorothy said...

it sounds great!!! is it possible that you could write me some detailed steps, i am a green hand... not that familiar with sharepoint.Thanks!

Jasper Oosterveld said...

E-mail me at Jasper.Oosterveld@wortell.nl and we can try to work something out.

Markus said...

Hi Jasper,

Great article!

I've recently changed the "When a Task Expires" email, but I'm still receiving the original one when an old task expires. Is it the case that it wont update for tasks created before the change?

Thank you!

Jasper Oosterveld said...

Hi Markus,

Thanks :-)

You are correct, the new changes only take affect with new workflow instances.

Huiqiang Han said...

Hi,
Have you written something about approval email content that contains current task 'Description' field ? I want the content of current item description to be showed directly in the approval email not a link like 'Review task_title'.

Many thanks!

Jasper Oosterveld said...

Hi Huiqiang,

Could you describe in more detail what you are looking for exactly?

John Richardson said...

Jasper,

Great article and it helped me to validate that I was doing things properly.

I have tried (and sadly failed) to take things a little further with my emails - specificaly I wish to use a company logo/graphic in the responses.

I'm aware that the default emails are not rich format and after some 'google-ing' I found that you can edit them in HTML to achieve the result.

However, I just can't get this to work - transfering the HTML across into SharePoint Designer, just creates a mess.

Do you have any experience of editing these email templates in HTML/Rich Text?

Or is there a better way to achieve the same result?

John.

Jasper Oosterveld said...

Hi John,

Thanks for the nice compliment.

Unfortunately I have no experience with HTML and the replies. Sorry about that.

Alexandru said...

Hi Jasper,

Cool article - I am trying to customize the email that goes out to approvers now for a pending task. Is there a way to include one of the page's column values in the email? (Apart from Title). I am trying to flag some pages as being important - and I have a choice column for this in the pages content type.

Sandi

Jasper Oosterveld said...

Hi, thanks :)

Can't you use the lookup option to the pages library?

Anonymous said...

Hi Jasper,

I was planning to write something like that but i found this as a Very Good article and well explanation on each part. I love it. I am going to share this at http://www.facebook.com/groups/SharePointExpert . You can join in this group and provide the Latest post link there so that my group can be beneficial from your Article.

Thank You
MJ Ferdous

Jasper Oosterveld said...

Thanks for the compliments! You can share the article :-) no problem at all :)

Anonymous said...

Hi Jasper,

I see your brilliant article is about SharePoint 2010 but is it possible to do the same thing in SharePoint 2007 as well?

TT

Jasper Oosterveld said...

Hi TT,

I am not sure, did you try to follow the steps? I don't have SPD2007 anymore and don't work with SP2007 at all. Sorry!

Anonymous said...

Hi Jasper,

Thanks for a great article on how to do this. My other question is do you know how I can set it so that the attachments on my infopath form are included on the workflow notification email? It used to just do it in SP 2007 but I don't know how to do it with 2010.

Thanks

Jasper Oosterveld said...

Hi,

Unfortunately I have no experience with this. Sorry!

Post a Comment