NOTE: Solution for insert in the post: How to retrieve value of the column instead of Microsoft.SharePoint.Client.FieldUserValue - #7 by Airun
In my company, we use Sharepoint list to request services to teams like IT, Marketing, HHRR, Quality and so on…
I want to automate some of those requests and, a very useful thing could be to obtain all the open requests form data without opening physically each list item so I’m trying with a “Get List Item” activity. But, for some of our forms data I’m getting “Microsoft.SharePoint.Client.FieldUserValue” so impossible to interact with it.
Sometimes I need to extract the name of the requester, or assign the request to someone by insertig the name of the employee on the field “ASIGNEDTO”. Sow can I do it?
How can I convert this data into a simply Generic Value or into String, Boolean, Int32…?
This is our Sharepoint List Item form:
This is what I get with the Get List Item Sharepoint activity if I write it on an excel, for example:
I’ve tried to convert this value to string, with an Invoke Method activity without success, by using sentences like “row(“REQUESTER”).ToString” or “row(“REQUESTER”).Value.ToString” without success. And, at the same time, I have no idea about how to insert a name (as Nuria Santos Carbonell" on "ASIGNEDTO field who’s type is FieldUserValue and not String.
I’vo found two or three topis about it on the forum but I can’t find a solution for my issue on any of them.