Link SharePoint lists from different sites
Today I want to share a cool trick with you, which you can use to organize your SharePoint sites. For most of the operational types of sites, I am sure you will build some sort of Hub Navigation. However, let’s say you also have sites that are temporary in nature that you only use for a period of time. I am talking about Project Sites, Legal Case Sites, Client Sites, etc. Something with a definite start and end date. You might have tens or even hundreds of these sites. Creating links on the global Hub Navigation is not practical, as the drop-down navigation menu will be impossible to manage and navigate. Luckily, we have an alternate way to organize such links via a Hyperlink column on a Custom List. Show Step 1: Create a Custom ListThere are many different ways to create a custom list in SharePoint. Please reference this post to learn about all the options. For my example, I created a list to track Projects, so I created the following columns:
Step 2: Create a Hyperlink column on a Custom ListWe now need to create a Hyperlink column that will capture the URL of a Project site. Here is how to do this:
A SharePoint list is a collection of data that gives you and your co-workers a flexible way to organize information. Follow the steps mentioned below to migrate a list from one site collection to another. Step 1: Export the list
Step 2: Export list to another site collection
Step 3: Uploading the list to a new site collection.
To ease your SharePoint migration process, try using ManageEngine SharePoint Manager Plus. Using this tool, you can run the migration process for both SharePoint On-premises and Sharepoint Online when it's convenient for your users to make sure the everyday functioning of your organization isn't affected, and end users have uninterrupted uptime.
1. Introduction Cross-Site Lookup creates relationships among lists between different sites, looking up information from SharePoint lists in other sites. This tutorial will demonstrate how does Cross-Site Lookup work and how to create it in a SharePoint list. Supposed there are two SharePoint lists, Product and Purchase Orders. Product – List of all products names and their relevant information. This list locates in site Marketing Center. Purchase Orders – List of all purchase orders from these products. And this list locates in another site Sales Center.
2. Create a Cross-Site Lookup Column a. Go to the List you want to create a lookup for, here we go to Purchase Orders list. b. Click the Create Column button under List tab. c. In the Name and Type section, specify a name for the column and choose Cross-Site Lookup. d. In the General Settings section, select a site and source lookup list. Supported Source Column types: Single Line Text, Number, Date and Time, Calculated (single line output text), ID, Modified, Created, Version e. In Advanced Settings section, select the checkbox of Enable creating new item in the source lookup list option. This option will enable users to add new item in the source lookup list with the “Create new item…” link. There are other options in the Advanced Settings: Filter by view - checking the box creates a filter for the Cross-site column. This means if a data is selected, the column will only display items that are related to the selected data. Folder mode - activating this feature means only lists with folders will be visible Display only one instance of duplicate items - items with same name will not be duplicated f. Click OK button to save the settings, and then there is a column named Product in the Purchase Orders list.
3. Work with Cross-Site Lookup in Item After creating a Cross-Site Lookup in the list, we can now create an item and get information from a list in a different site. a. In the Purchase Orders list, click new item to create a new item. b. In Product column (which lookups from Product list), we can select a product name from the drop-down list as following.
4. Enable Cross-Site Lookup work with Microsoft Office Applications By default, SharePoint only can manage out of the box column data in Microsoft Office applications. Cascaded Lookup 4.0 provides a new Data Adapter Web Application feature that enhances the functionality of SharePoint with the ability to manage Cross-Site Lookup columns in Microsoft Excel, Microsoft Access, Microsoft Word and SharePoint Workspace. a. To activate the Cascaded Lookup Data Adapter feature, go to the Web Application Management module of SharePoint Central Administration. b. Click the Activate button on the Cross Site Lookup Data Adapter feature in the feature list. |