Sharepoint workflows from a list: email to multiple users

Posted on 2009-04-23
Last Modified: 2012-05-06

1 custom list with a lookup field. The lookup field is displaying user names from another list. The user may select multiple people from this list.

1 workflow. The workflow is simply supposed to send email to the user or users selected through the lookup field.

The problem:  if I use Name(display) in the lookup, the workflow sees those names as strings without any related information (such as their domain name or email address).  If I use Name (by itself), the workflow works properly because it sees "domain\username". However this is not a good solution for the users as they don't know the "username" of the users; They know them by their full name or Name(display)
Question by:Iammontoya
    LVL 16

    Expert Comment

    If you can not build a mapping logic in the workflow, perhaps you can try to have two columns in the lookup lost. One is the username, one is the display name. In your workflow, you can try to manipulate them into a format which can be sent correcly with display name.

    LVL 21

    Accepted Solution

    Here's another approach. We had a similar situation and what we did was using the name, do a search in AD (assuming you are using integrated authentication) to get the user's login name and then their email using the SP object.
    LVL 19

    Author Closing Comment

    Giving you the points. This is actually what I ended up doing, although I believe there has to be another choice out there.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
    The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now