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

Salvete! In one of my custom lists, I want to add a user-account column (where you display properties of a user or group) to display a user's username, but I also need to display the user's email address from his account information. I know that if I add a second user-account column, I can choose to display the "work e-mail" field, but that necessitates entering the user's name twice - once for the user's username and once for the email.

Is there any way to use the username gotten from the first user-account column to fetch the email for me? Maybe there is some third party solution?

This post seems relevant.

share|improve this question
up vote 1 down vote accepted

Salvete! I would suggest that you use a workflow which is automatically started when an item in your list is created or updated. The workflow would look at the field with the user's name and from that lookup the user's email. The workflow would then update the listitem's field and complete.

share|improve this answer
Ah! I suppose folks think this is the only way! I like to accept answers to all my questions, but I also like to get several answers to choose from! – bgmCoder Oct 8 '12 at 20:00

For username , I would use Infopath: Create a single text field. Then in Infopath, select the field. Double click the field name from right, select "function sign" in right side of default value, choose insert function, choose user , username() function, then Ok. ok.

For email , full name , etc I would create a workflow, find the condition, in the list, who created the item, [created by], then there is a field return type, I would choose, email, full name, string, etc whatever I need.

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.