Forum Discussion

WilliamAzevedo's avatar
WilliamAzevedo
Copper Contributor
Nov 23, 2021

Show additional column in lookup field

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

 

Thank you in advance!

Lists
Microsoft Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    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.

  • Pol_Van_Dingenen's avatar
    Pol_Van_Dingenen
    Brass Contributor
    Nov 24, 2021

    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.

     

    • WilliamAzevedo's avatar
      WilliamAzevedo
      Copper Contributor
      Nov 26, 2021
      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?
      • ganeshsanap's avatar
        ganeshsanap
        MVP
        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.

  • fjpc87's avatar
    fjpc87
    Copper Contributor
    May 31, 2023
    Hi. I have the same issue. I think I need to use Power Apps.

Share

Resources