Raja.G
(Mr.RPABot)
February 22, 2023, 8:22am
1
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
Microsoft.SharePoint.Client.FieldUserValue
Please anyone help me for this.
Regards,
Raja G
kali
February 22, 2023, 8:34am
2
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
mahamud
(mahamud)
February 22, 2023, 8:36am
3
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
Raja.G
(Mr.RPABot)
February 22, 2023, 8:52am
4
Hi @mahamud ,
No im not saved “Microsoft.SharePoint.Client.FieldUserValue” into a variable
Im using list variable and output get to Datarow
Regards,
Raja G
Raja.G
(Mr.RPABot)
February 22, 2023, 1:26pm
5
@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.
Hi, there!
The SharePoint CSOM is rather complicated. But here is how you can do it.
First, make sure you are using the latest version of the UiPathTeam.SharePoint.Activities package. Should be 1.5.2 or later.
Next, you won’t be able to get the value from the DataTable. You’ll have to get the list using the Dictionary option. So for the Get List Items activity, use the Items(Dictionary Array) option.
Then you can get the value by doing something like:
CType(OutputDict(0)("REQUESTER"), Micro…
Also provide us your current implementation as to how you are accessing the value.
Raja.G
(Mr.RPABot)
February 22, 2023, 4:21pm
7
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’
Regards,
Raja G
@Raja.G ,
Could you provide the implementation done as mentioned before ?
Raja.G
(Mr.RPABot)
February 23, 2023, 5:25am
9
Hi @supermanPunch
Working fine, Thanks.
That error i used assign in above “Sharepoint Application scope in Get list item” activity so only.
Regards,
Raja G
1 Like