Forum Discussion

ogoret's avatar
ogoret
Copper Contributor
Jan 07, 2023

Lookup column in library

Hi,

 

I have created a content type, which inherit from "document". So it has a column "name" inherited.

I would like to add a column to link elements between them. So i add in my new content type a lookup column to this new content type itself.

It works but when i choose which data to show in the list of choices for the user to set the link, i see some columns but not the "name" column, inherited from the document content type. For the user, to select an id or else is not significant.

My question is : why i can't choose the name column ? And how tu fix this ?

Thank you !

Document Library
  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Jan 09, 2023

    HI ogoret 

    You can set it using PNP Powershell.

    $ListName="Documents"
$LookupFieldName="RelatedDocument"

# Add the field to the list
Add-PnPField -List $ListName -Type Lookup -DisplayName $LookupFieldName -InternalName $LookupFieldName -AddToDefaultView
# Set the lookup list for the field and set the lookup field to "FileLeafRef"
Set-PnPField -List $ListName -Identity $LookupFieldName -Values @{LookupList=(Get-PnPList $ListName).Id.ToString(); LookupField="FileLeafRef"}


    The "name" field you need to reference is internally called "FileLeafRef".
    It is a special field, perhaps that is why you can't select it using the UI.

    Best Regards,
    Sven

     

Resources