How to retrieve data from Sharepoint

Hi Team,

I need to get data from sharepoint but that filed value came like “Microsoft.SharePoint.Client.FieldUserValue”, i want to exact data from sharepoint

If i want extract XXX na that exact name only i want but result came below

Please anyone help me for this.

Raja G

Not sure if understand correctly, are u iterating over a sharepoint list for each row?

u could use assign like this for example depending on column name in ur sharepoint list
row.Fields.Where(function(x) x.DisplayName=“Site”).First.Value.tostring

1 Like

Did you try to save “Microsoft.SharePoint.Client.FieldUserValue” into a variable?
Sometimes data is saved into a complex variables and you need to use that variable to extract specific data you want.

1 Like

Hi @mahamud ,

No im not saved “Microsoft.SharePoint.Client.FieldUserValue” into a variable

Im using list variable and output get to Datarow

Raja G

@supermanPunch Please help me for this

Hi @Raja.G ,

Have you checked the below post, it does seem to have addressed the similar problem. Let us know if the post was not helpful.

Also provide us your current implementation as to how you are accessing the value.

Hi @supermanPunch ,

Yes i tried but i got error below.,

Microsoft.SharePoint.Client.FieldUserValue is not defined.
Option strict on disallow implicit conversions from ‘integer to string’

Raja G

@Raja.G ,

Could you provide the implementation done as mentioned before ?

Hi @supermanPunch

Working fine, Thanks.
That error i used assign in above “Sharepoint Application scope in Get list item” activity so only.

Raja G

1 Like