Forum Discussion
Show additional column in lookup field
- Nov 26, 2021
WilliamAzevedo You cannot extend (show as additional field) the lookup column in lookup settings. Only below column types are supported in lookups:
Supported Column Types
- Single line of text
- Number
- Date and Time
Source: Create list relationships by using unique and lookup columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
I've tried that, but the field is not listed. And I forgot to mention: that field which is not listed it's also a look up. May that be the problem?
WilliamAzevedo You cannot extend (show as additional field) the lookup column in lookup settings. Only below column types are supported in lookups:
Supported Column Types
- Single line of text
- Number
- Date and Time
Source: Create list relationships by using unique and lookup columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- MichaelDanoFeb 15, 2023Brass Contributor
ganeshsanap , WilliamAzevedo Pol_Van_Dingenen
A work around to this:
Create an additional column, type Calculated. Make it equal to Choice column to get the value. Set The data type returned from this formula to "Single line of text".Example:
If you have a column "Status" as a choice of the values "Not started", "In progress" and "Completed" you add a new Column "New Status" that point to the "Status" column:The New Status will be available in the lookup column in your other list.