How to access LookUp Column of Sharepoint in Uipath

@radu_bucur Hi , went through your Sharepoint Package and it was way too handy.i have already built a workflow which accesses the normal text column. I want to access the lookUp column. Help will be appreciated.test.xaml (11.5 KB)

Hi @shishirshetty2701, I’m glad the package is of use to you. In order to access Lookup values, please do the following:

  • make sure the Microsoft.SharePoint.Client dll is included in the Imports tab:
    image

  • simply loop through the list items retrieved with the ReadListItems activity and access the lookup values in the following way:
    image
    image

Here is the line of code above in case you want to copy-paste it:
CType(item(“LookupTest”), Microsoft.SharePoint.Client.FieldLookupValue).LookupValue + “;” + CType(item(“LookupTest”), Microsoft.SharePoint.Client.FieldLookupValue).LookupId.ToString

@radu_bucur Thanks alot it worked. i will revert back if i have any queries

1 Like

@radu_bucur i have a query, what if there are many lookups. For eg, i have a look up table like SupplierName, SupplierCode under Parent Supplier. How can i access both of them . I have attached the image

Response here: https://forum.uipath.com/t/re-how-to-access-lookup-column-of-sharepoint-in-uipath/151669/2?u=radu_bucur :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.