<img height="1" width="1" src="https://www.facebook.com/tr?id=730305433807073&amp;ev=PageView &amp;noscript=1">
Book a Demo

Advent Calendar Door 16: Cross-site lookup columns in SharePoint Online.


Posted by Adis Jugo - 16 Dezember, 2017

Cross-site lookup columns in SharePoint Online

In today’s skybow Advent Calendar cookie, we are solving one of the most required features in SharePoint: Cross-site lookup columns in SharePoint Online! The use scenarios of cross-site lookup fields are various – from connecting data sources spread across different site, to structuring your business process in multiple subsites. All those use cases are valid, and – not supported by SharePoint out-of-the-box features.

Still, this is very easy to achieve with skybow Solution Studio.

You need to switch to the “Things in background” section of the list where you want to add a cross-site lookup field, and to click the “Add cross-site lookup” link on the bottom of the screen.

Things in the Background skybow Solution Studio

In cross-site lookup creation dialog, you will have to enter the column name and description, path to the site where target list is stored (it needs to be inside the same site collection!), and then select a list and a column from that list. And that is that.

cross site lookup.png

After clicking on the „Create“ button, the new field will appear in the fields list just as any other field, where you can set its properties, and even perform background calculations.

change column

When you run a new or edit form with that field, it will behave just as any other lookup field in your list.

lookup field in list.png

And there it is, in less than 30 seconds, we have created a fully functional cross site lookup, by using skybow Solution Studio.


Topics: Office 365, Sharepoint, SharePoint Online, cross-site lookup

Recent Posts

9 Hidden Costs of Power Platform

read more

Do you already work modern? (Part 5 of 5)

read more

5 years skybow - what a journey

read more