December 04, 2015

How to extend capabilities of lookup columns – Part 3

1043 Views

Wiki Pages are simple to create, is their reference also as easy?

Wiki pages are the simplest kinds of pages in the world (at least I want to believe that), and simple to refer when just using the URL. But ever thought about referencing a wiki page sitting in a wiki library from any other list/library on the site? It isn’t that straightforward!

And did you just think why would you ever want to refer to a wiki page from any other library…aah…not again – can there ever be an end for wishes!

So, when you just stumble against a requirement where you have just immense data and you wish that somehow you had just another column that could look up to a wiki library that has all additional data, you know here’s the perfect place to begin.

This blog is just another step in our lookup series and hence we follow the same nomenclature to term all those lists (or libraries) as Dependent Lists that look up to their sibling on the same site.

With experience from the ancestors of this series, we already know that we follow an approach of manipulating data.

Get set go…

There’s a slight addition that first needs to be made on the wiki library to be able to capture the page name as a Single line of text column named as Wiki Page Name and then using this column in the dependent list.

s1

How does this column get values?

The SharePoint Designer is the first thing that comes to my mind for a lookup rescue.

Create an SPD 2010 workflow to fill up this column as wiki pages are created or modified. Hence trigger the workflow to start when items are created or updated. In the given example, I’ve named the workflow as the column name Wiki Page Name.

This is a simple single step workflow as illustrated in the following screenshot.

s2

If the wiki library already contains some pages, modify item property for all existing pages so that the workflow gets started for the condition ‘when item is changed’

s3

Once done, value in column Wiki Page Name for all pages gets updated.

s4

The finishing act

This is the last stage where everything that was built now needs to be used.

How to couple the wiki library with Dependent Lists

Modify the Dependent List to create a lookup column on the wiki library. This column will now be able to read the custom column Wiki Page Name that is setup from the workflow.

s5

And below is an example of how the wiki page reference starts to work on the Dependent List.

s6

Read the other posts from this series:

3 Replies to “How to extend capabilities of lookup columns – Part 3”

Leave a Reply

Your email address will not be published. Required fields are marked *