A common SharePoint request is to create a lookup field from a list in another site. This is possible so long as the sites are within the same site collection, but it does require some customization.<\/p>\n
Since I am dealing with a single-server farm, I was able to do this fairly quickly in PowerShell:<\/p>\n
# Set the source web to the web where the source list exists # Set the destination web to the web where you wish to add the lookup # Set the source list to the list in which the field exists # Set the source field to the field you wish to perform lookups on # Get the collection of all fields in the destination list # Add a lookup field to the fields collection # Get the newly-added lookup field # Set the lookup field to the internal name of the source field # Update the lookup -- without this the previous changes won't be saved # Dispose of the SPWeb and SPSite objects A common SharePoint request is to create a lookup field from a list in another site. This is possible so long as the sites are within the same site collection, but it does require some customization. Since I am dealing with a single-server farm, I was able to do this fairly quickly in PowerShell: # … Continue reading SharePoint 2010 Cross-Site Lookup using PowerShell<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[180],"tags":[228,211],"class_list":["post-854","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2","tag-powershell","tag-sharepoint-2010"],"_links":{"self":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/comments?post=854"}],"version-history":[{"count":11,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/854\/revisions"}],"predecessor-version":[{"id":1049,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/854\/revisions\/1049"}],"wp:attachment":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/media?parent=854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/categories?post=854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/tags?post=854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}# Set the site collection in which the source and destination webs exist
\n$site = Get-SPSite(\"https:\/\/mysite\/path\/\")<\/p>\n
\n$sourceweb = $site.OpenWeb(\"sourcepath\")<\/p>\n
\n$destinationweb = $site.OpenWeb(\"destinationpath\")<\/p>\n
\n$sourcelist = $sourceweb.Lists[\"List Name\"]<\/p>\n
\n$sourcefield = $sourcelist.Fields[\"Field Name\"]<\/p>\n
\n$destinationfields = $destinationweb.Lists[\"List Name\"].Fields<\/p>\n
\n# See the SPFieldCollection AddLookup(String,Guid,Guid,Boolean) method
\n# For details: http:\/\/msdn.microsoft.com\/en-us\/library\/ms430950.aspx
\n$lookupname = $destinationfields.AddLookup($sourcefield.Title,$sourcelist.ID,$sourceweb.ID,false)
\n# The above produces an error: Missing expression after ','. At line:1, char:83
\n# Right--in Powershell, $false is False.
\n$lookupname = $destinationfields.AddLookup($sourcefield.Title,$sourcelist.ID,$sourceweb.ID,$false)<\/p>\n
\n$lookup = $destinationfields.GetFieldByInternalName($lookupname)<\/p>\n
\n$lookup.LookupField = $sourcefield.InternalName<\/p>\n
\n$lookup.Update()<\/p>\n
\n$sourceweb.Dispose()
\n$destinationweb.Dispose()
\n$site.Dispose()<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"