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

Posted on 2014-08-11
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
    LVL 4

    Expert Comment

    by:Nuno Rogado
    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

    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

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    734 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

    19 Experts available now in Live!

    Get 1:1 Help Now