United Kingdom +44 (0) 1424 863 450   hello@simego.com

Handle SharePoint Lookup Columns in Sharepoint 2010

How to Handle SharePoint Lookup Columns in Sharepoint 2010


3 December 2012

Step 1: Understand Sharepoint 2010 Lookup Column feature

The SharePoint 2010 (Client API) Provider has an inbuilt feature to automatically match and link Lookup Columns based on the value associated with the List.

image

In this example we have created an Orders list and added one column that is a multi-value column that will contain the “Products” that relate to this Order.

image

Step 2: Set up the lookup Data

To handle the lookup data we simply need to provide the name of the lookup value separated with a semi-colon(;) i.e. here we created an Excel file with the order details.

image

Step 3: Connect the lookup source (Excel here) to the the source and Sharepoint as the Target

We then simply create a DS Project to Map this to our Orders List

image

Step 4: Compare and synchronise the List

Then once we synchronise this data the lookup is automatically connected.

image

image

During the Synchronisation we download the list items from the related SharePoint List and index into this list to get SharePoint’s internal identifier number to assign to the item being linked. Therefore items must be an exact match and they must exist for the link to be successfully created.

If your Lookup is simply a single item then you just need to return the Name/Title of that item.


|
Can't find the answers you're looking for?