Handle SharePoint Lookup Columns in Sharepoint 2010

How to Handle SharePoint Lookup Columns in Sharepoint 2010


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.

Connect

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.

SharePoint List

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.

Lookup Data

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

Proejct

Step 4: Compare and synchronise the List

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

Complete

Complete

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? Contact our support team and we'll personally get back to you as quickly as we can.