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 am working on a work site with SP 2007 on which I have a list item with a Person field available to associate an employee with that item. When looking up an employee to fill that field I get their name. When I reference that field in an email, I get the employee's reference number for the company. What causes this and can I get the actual name to show in the email?

share|improve this question

One possibility is that you may just need to change the field that is shown in your Person field. You might be showing User Name instead of Name? Just go into your list settings and click on the column's name to check out what you have at the Show field: dropdown.

Otherwise, if you have Useful Sharepoint Designer Custom Workflow Activities installed, in your Sharepoint Designer workflow you can use the "Lookup site user property" action:

Lookup this user property for this user , store in Variable

Put ImnName as the 1st this user (property), and choose your Person field in Current Item as the 2nd this user and assign it to a variable that you can then use as a Lookup under Worflow Data in your email.

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.