How to access LookUp Column of Sharepoint in Uipath

[radu_bucur]

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:
  

  

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

  

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