The SharePoint Lookup component allows you to perform a lookup operation on a SharePoint (2007 or later) list from within a data-flow. After dragging an instance onto the data-flow surface and connecting the predecessor component, double-click to configure. The following interface is presented :



The first tab asks you to configure the HTTP connection to the SharePoint server, and the name (or GUID) of the associated list, as well as other connection parameters. Note that if your URL is incorrect and you are trying to access a list contained in a sub-site then you may get a spurious error from SharePoint about the list format being incorrect - lists can be specified in name form as long as the base site URL is correct.

Having configured our connection, the second tab allows us to select the columns that we want to return to the data-flow or filter upon. The columns available include internal system columns as well as user columns.  We can also specify simple equality filters on columns, which can be constant or a reference to a package variable. Only rows that match all equality filters configured will be returned. The name of the returned column will be the same as that in SharePoint by default, but you can adjust this and the column type if required using the 'Edit Name / Data Type...' button.



Here we are looking up the Title of a list entry where the ID is equal to the current value of the ContactId column within the data-flow.

We can also specify no-match and multiple-match error-handling options and caching behavior on the Lookup tab.


Finally the Conditions tab allows you to enter a simple filter condition to determine whether the lookup should be performed, for example in our case [ContactId] != null as there is no point looking up a null entry.