cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srosenbloom
Frequent Visitor

Lookup Column Return Column other than the Primary Name Column

Hey All,

 

I've got a lookup column in a table, that is looking to another table where the NON-Primary Name Column, which is a multiline text column, is the one a want to show. Is this possible, or can it ONLY return the Primary Name Column. If that's the case, can the Primary Name Column be set as a multiline text column?

 

Thanks,

Scott

1 ACCEPTED SOLUTION

Accepted Solutions
cchannon
Super User
Super User

Primary column cannot be multiline text and the primary column is always the display name of the lookup. What you can do is change the View that the Lookup uses, so when users are searching for a match, it displays whatever other column(s) you want them to search on.

View solution in original post

2 REPLIES 2
cchannon
Super User
Super User

Primary column cannot be multiline text and the primary column is always the display name of the lookup. What you can do is change the View that the Lookup uses, so when users are searching for a match, it displays whatever other column(s) you want them to search on.

View solution in original post

srosenbloom
Frequent Visitor

Ahh! Perfect! Thanks!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,687)