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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,449)