Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Sharepoint workflows from a list: email to multiple users

Posted on 2009-04-23
Medium Priority
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:Montoya
LVL 16

Expert Comment

ID: 24224192
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

66866 earned 2000 total points
ID: 24224555
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

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Loops Section Overview
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

577 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