Get Microsoft.SharePoint.Client.FieldLookupValue[] type items from Sharepoint

[tejashwini.chilmakuri (TejashwiniC)]

Hi,

I need to get value of a lookup type form Sharepoint list. I am using UIPathTeam.Sharepoint.activities Get List Items activity in UIPath.
But i am getting the list column value as “Microsoft.SharePoint.Client.FieldLookupValue”. Can you please help me convert it to a value?

Regards,
Tejashwini

[carmen]

Hi @tejashwini.chilmakuri .

Here is the link where you can get the documentation that will help you with the sharepoint activities.

SharePoint Custom Activities Package - RPA Component | UiPath Marketplace

Let us know if was useful.

[Palaniyappan (Palaniyappan P)]

@tejashwini.chilmakuri

Microsoft.SharePoint.Client.FieldLookupValue

Hi

Welcome to UiPath forum

Have a view on this for clear example

How to access LookUp Column of Sharepoint in Uipath

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.FieldLookupVal…

Cheers @tejashwini.chilmakuri

[tejashwini.chilmakuri (TejashwiniC)]

HI @Palaniyappan ,

Thanks for your quick response.
I am able to get the values of Microsoft.SharePoint.Client.FieldLookupValue
However, I have a column with type Microsoft.SharePoint.Client.FieldLookupValue
I believe it is of type “array of fieldLookupValue” I am not able to get the values from this type. I tried using CType(item[/ColumnName],Microsoft.SharePoint.Client.FieldLookupValue).FieldLookupValue
but it is not working for FieldLookupValue

This is the sample dictionary format of FieldLookupValue,
“ColumnName”,
FieldLookupValue[1]
{
FieldLookupValue
{
LookupId=123,
LookupValue=“abc”,
TypeId="
{
*****asbahsd;
}",

and the sample dictionary format of FieldLookupValue,
“ColumnName”,
FieldLookupValue
{
LookupId=1234,
LookupValue=“xyz”,
TypeId="
{
#jwehjs;
}",

Thanks,
Tejashwini

[tejashwini.chilmakuri (TejashwiniC)]

Hi @carmen ,

Thanks for sharing the document.
I have an issue in converting Microsoft.Sharepoint.Client type values.
I believe i couldn’t find the exact solution for this issue there.

Thanks,
Tejashwini

[supermanPunch (Arpan)]

Hi @tejashwini.chilmakuri ,

I think the Conversion can be done as below :

If you have to take the First Value from the FieldLookupValue[], then you can access it using the index method

CType(item("ColumnName"),Microsoft.SharePoint.Client.FieldLookupValue())(0).LookupValue

[tejashwini.chilmakuri (TejashwiniC)]

Thanks @supermanPunch !
It worked…

Tejashwini.