Missing column in list 1 from list 2. How can this be added

Posted on 2014-08-11
Medium Priority
Last Modified: 2014-09-07
Good morning experts.

I have 2 lists as follows:
List 1 is a form with a column pulling a multi selection lookup from list 2
List 2 is simply a list of domain user names.

In list 1 I want users display name instead of their email address. I have a column in list 2 called Display Name but list 1 offers only Created, Email, ID, Modified, and Version columns as choices. I've attached a screen shot from Designer 2013.
Can you guide me in the right direction to make this happen?

My environment is SharePoint 2013 Standard.

Question by:Eddie_1
  • 2

Expert Comment

by:Nuno Rogado
ID: 40296875
Hi Eddie,

You should go back to "List 1" settings and edit the lookup field, then below "Get information from: " "List 2" you can choose if it's the email or the DisplayName that appears or you can even add a second field selecting a new column on "Add a column to show each of these additional fields:".

Best Regards,
Nuno Rogado

Accepted Solution

Eddie_1 earned 0 total points
ID: 40298259
Thanks Nuno.

I was able to figure it out last week. I ended up creating a new contact list with a display name and email column for list 2. In list 1, I chose a multi-selection lookup for the display name in list 2. Then, I set the workflow to send emails to the selected display name and pulling the email addresses from the email column in list 2. This has been a long but rewarding experience. Trial and error does have it's place. Thanks again Nuno.

Author Closing Comment

ID: 40308372
The applied solution resulted in a workflow that pulled multiple selections from list 1 and then used the email column in list 2, a new contact list, to send email for the multiple selections in list 1.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
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
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Integration Management Part 2
Suggested Courses

862 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