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

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.

Eddie
list-1.bmp
Eddie_1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nuno RogadoCommented:
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
0
Eddie_1Author Commented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eddie_1Author Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.