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.

srosenbloom
Frequent Visitor

Ahh! Perfect! Thanks!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,675)