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

We have a list called employee details, which has client name as one of the columns which is of the type lookup (from another list name columns value). So when the users create a new item in the employee details list, I want a workflow to trigger and an email (with details) to be sent to the employee whose name is selected from the drop down box. Since client name is not a people picker column, how is it possible with OOB? If not any custom solutions?

share|improve this question
up vote 2 down vote accepted

AFAIK, the send email activity will try to resolve the string into a principal and get its email address. Please try giving valid user names and check it.

There is also a OTB condition available in SharePoint Designer which checks if provided value is a valid sharepoint user. You may want wrap sending email under that condition.

UPDATE: I tested that if you specify a string (which let's say is coming from a dropdown or a textbox), send email activity sends email as long as;

  1. the string represents display name of user (like Patel, Ashish) or

  2. Active directory account name (like mydomain\ashish.patel) AND

  3. Email is associated with the user profile.

share|improve this answer
Hi Ashish, do u have link of any article..that does it..Thanks.. – spStacker Jan 13 '12 at 16:51
You need to try, see my updated answer – Ashish Patel Jan 13 '12 at 19:02

Is the email address defined in your employee list at all?

If it is, since you've used lookup columns to define the user, you know the corresponding list item id and can lookup any corresponding field in the list item. If one of those fields is the user's email address, you can store that in a variable and use that as the To: address in your workflow email.

share|improve this answer
Hi Eric..the list does not have an email address coloumn hooked up with it.. – spStacker Jan 13 '12 at 16:52

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.