<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 1: Top-down metadata inheritance for SharePoint items and files

Top-down metadata inheritance for SharePoint items and files

Very often there is a situation where you need to enrich the large number of files of list items with the same metadata set, usually for the search purposes. Imagine this situation: you are uploading photos from an SharePoint event into SharePoint picture library, but those photos have no metadata (metadata which we would like to have is usually located in a list item where the event data is stored), and they are difficult to find later through SharePoint search.


Luckily, there is skybow to the rescue! In the first skybow Advent Calendar cookie, I will show you how to use the Metadata Inheritance feature from skybow Solution Studio to implement this within seconds. The target library or list (that one to which we want to inherit metadata to) either needs to have a lookup field to the “master list” (that list we copy the metadata from), or to be declared as a sublist of a dossier in the solution studio. The target library / list of course has to have the fields of the same type (they don’t have to have the same name), where the metadata will be coped to.

The first step is to open the “target” library or list in the solution elements tree, select the “Things in background” option, and then click on the settings icon besides the field you want to inherit the metadata to.

top down metadata.png

The next step is to click on the “Values” option, choose the “Inherit” Calculation type, and then select the “master” list (list we want to inherit the values from) and chose the field from the master list we want to inherit the value from.
Repeat this step for all fields you want to inherit the values to.  

change column values.png

It will take few seconds for values to be initially copied, since this is an asynchronous background process. If you look at your library or list, you will see that the metadata fields have been properly set. Both lists will be in sync from now on, so each time you change something in the master list, these changes will reflect in the target list.

change master list.png

With skybow Solution Studio, we are done with this in less than a minute! Take a look on the demo video here: https://youtu.be/ef2jBanihEQ

Adis Jugo

Written by Adis Jugo

is Director of Product Technology at skybow, and a software architect with over 20 years of experience. Adis is double Microsoft MVP (Most Valuable Professional) for Office Development and for Office Servers and Services. He first met SharePoint (and Microsoft CMS server) back in 2002, and since 2006 his focus was completely shifted towards architecture and development of productivity solutions, now based on the Azure, Office 365 and SharePoint technologies. Adis is an internationally recognized speaker with over 15 years of speaker experience, speaking at various Microsoft, Community and SharePoint/Office 365/Azure conferences worldwide.