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.
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.
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.
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
Step 4: Compare and synchronise the List
Then once we synchronise this data the lookup is automatically connected.
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.