SOLVED

Show additional column in lookup field

%3CLINGO-SUB%20id%3D%22lingo-sub-2998653%22%20slang%3D%22en-US%22%3EShow%20additional%20column%20in%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2998653%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20with%20a%20lookup%20field%20where%20I%20would%20like%20to%20show%20an%20additional%20column%20from%20it's%20source%20list%20when%20creating%20a%20new%20item.%20I'll%20try%20to%20illustrate%20the%20problem%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22This%20is%20my%20main%20list.%20The%20highlighted%20field%20is%20a%20lookup.%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328998iD0158AD17BADDE47%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Anota%C3%A7%C3%A3o%202021-11-23%20162804.png%22%20alt%3D%22This%20is%20my%20main%20list.%20The%20highlighted%20field%20is%20a%20lookup.%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThis%20is%20my%20main%20list.%20The%20highlighted%20field%20is%20a%20lookup.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22This%20is%20the%20source%20for%20the%20lookup.%22%20style%3D%22width%3A%20867px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328999i2B0C69DADD0E8960%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Anota%C3%A7%C3%A3o%202021-11-23%20163126.png%22%20alt%3D%22This%20is%20the%20source%20for%20the%20lookup.%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThis%20is%20the%20source%20for%20the%20lookup.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22When%20creating%20a%20new%20item%20on%20my%20main%20list%2C%20I%20would%20like%20the%20data%20on%20the%20second%20column%20on%20the%20lookup%20source%20to%20appear%20here.%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329002i555F966916DA09BB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Anota%C3%A7%C3%A3o%202021-11-23%20163356.png%22%20alt%3D%22When%20creating%20a%20new%20item%20on%20my%20main%20list%2C%20I%20would%20like%20the%20data%20on%20the%20second%20column%20on%20the%20lookup%20source%20to%20appear%20here.%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EWhen%20creating%20a%20new%20item%20on%20my%20main%20list%2C%20I%20would%20like%20the%20data%20on%20the%20second%20column%20on%20the%20lookup%20source%20to%20appear%20here.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2998653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3000801%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20additional%20column%20in%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3000801%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1210158%22%20target%3D%22_blank%22%3E%40WilliamAzevedo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20achieve%20this%20you%20will%20have%20to%20navigate%20to%20the%20list%20settings%20where%20you%20are%20using%20the%20lookup%20column.%20In%20the%20list%20settings%20menu%20you%20can%20see%20all%20the%20columns%20you%20are%20using%20and%20you%20can%20click%20on%20them%20to%20go%20to%20the%20settings%20of%20the%20column%2C%20here%20you%20would%20have%20to%20navigate%20to%20the%20lookup%20column%20you%20are%20referring%20to.%3C%2FP%3E%3CP%3EWhen%20there%20you%20can%20scroll%20down%20a%20bit%20to%20the%20additional%20column%20settings%20and%20you%20can%20see%20all%20the%20columns%20from%20your%20original%20list.%20Just%20check%20the%20columns%20you%20would%20like%20to%20add%20and%20this%20should%20achieve%20what%20you%20are%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lookup.png%22%20style%3D%22width%3A%20324px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329113iF478D0C0EEA0D5DC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lookup.png%22%20alt%3D%22lookup.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3008489%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20additional%20column%20in%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3008489%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20tried%20that%2C%20but%20the%20field%20is%20not%20listed.%20And%20I%20forgot%20to%20mention%3A%20that%20field%20which%20is%20not%20listed%20it's%20also%20a%20look%20up.%20May%20that%20be%20the%20problem%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello.

 

I have a list with a lookup field where I would like to show an additional column from it's source list when creating a new item. I'll try to illustrate the problem:

 

This is my main list. The highlighted field is a lookup.This is my main list. The highlighted field is a lookup.This is the source for the lookup.This is the source for the lookup.When creating a new item on my main list, I would like the data on the second column on the lookup source to appear here.When creating a new item on my main list, I would like the data on the second column on the lookup source to appear here.

 

Thank you in advance!

3 Replies

@WilliamAzevedo 

To achieve this you will have to navigate to the list settings where you are using the lookup column. In the list settings menu you can see all the columns you are using and you can click on them to go to the settings of the column, here you would have to navigate to the lookup column you are referring to.

When there you can scroll down a bit to the additional column settings and you can see all the columns from your original list. Just check the columns you would like to add and this should achieve what you are looking for.

 

lookup.png

Hi!

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?
best response confirmed by WilliamAzevedo (Occasional Contributor)
Solution

@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

SourceCreate 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.