SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created a SharePoint 2010 workflow using SPDesigner2010. This workflow sends out a html formatted email using several combined dynamic strings whenever someone publishes a blog post. The dynamic "live" data pulled using lookup and displayed in the final email is: Title, Created By, Category.

My problem is that when I use lookup for created by, the information pulled is the employee ID number. I would like to be able to use their full name instead of their respective ID number. When I check the list where the posts are stored, in the created by column the values are full names.

Summary: How can I have the full name of an employee appear instead of their ID number when using the lookup "created by" in a "Extract substring from index of string"?

Being able to do this would allow me to create a notification email for a sharepoint blog using the Title, Full Name and Blog Category.

If anyone could point me in the right direction it would bve very much appreciated.

share|improve this question
up vote 2 down vote accepted

Use a Set workflow variable action to create a new string variable called fullName. In it, set the value to be the Current Item, Created By field returning Display Name. Then use that variable in your subject.

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.