SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

时间:2022-09-05 18:53:59

OverView

In this post,I want to show u how to add a look up column in my list or library that looks up data which comes from a list or library of another site.

I have to say,it is a awesome Function and easy for sharepoint end users.So,Let me guide you through this .And,more remarkable,as long as you must stay in the same site collection.You can create a lookup Site Column that will be used to get information from list which is available in a parent site.The Site Column must be created in the same site as the referenced list/library.

So Let's go ahead.

Step by Step-> Create Lookup Site Column in a parent site(root website)

  • Go to Site Action then Site Settings
  • Click on Site Columns in Web Designer Galleries

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Click on Create and Create a new Site Column

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Type in a Distinguished name and Select the type in this column is Lookup

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Put this site column into Existing group.for example Custom Columns

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Select a List/Library as information source

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Check it Whether Exist in Custom Columns Group

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Add my Site Column to any list/library you would like to use it with.Just Click on List Settings on Ribbon Menu.

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Click on add from existing site columns

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Select site columns form custom columns

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Success.Look up column looking for values of a list/library on another parent site.

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Just click on the hyperlink as shown in below and finally pop up a dialog to show information.

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

  • Pop up a dialog to show relevant information.

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

Note:When you click hyperlink . Unfortunately get a error "List does not exist.The page you selected contains a list that does not exist. It may have been deleted by another user".

SharePoint 2013 Step by Step——How to Create a Lookup Column to Another Site(Cross Site)

To Fix this error,just install the latest update of sharepoint and the bug will disappeared.