SharePoint List - get URL columns

[Ferdinand]

I’m using Get List Items to read a list, but columns defined as URLs displays as “Microsoft.SharePoint.Client.FieldUrlValue” instead of the actual URL.

Is there a way to get the value?
When storing the list as Dictionary array the value is stored as an object, but I don’t know how to go from there.

[copy_writes (chethan)]

@Ferdinand

I’m using Get List Items to read a list, but columns defined as URLs displays as “Microsoft.SharePoint.Client.FieldUrlValue” instead of the actual URL

actully with out using dictionary you can use lookup datatable it is another way if the data is stored in the excel
i dont no am giveing a proper answer

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @Ferdinand,

I know this might not be a complete solution as I don’t have access to Office 365 currently, but do check the reply in this thread which is partly linked to SharePoint List. I suggest using the PowerShell module rather than using the library published in Connect.

Help understanding sharepoint activity (Get List Item)

Hi @danilo.arias.sanchez, Welcome to the community! Although the library on connect for SharePoint is good for development purposes, I would avoid using it in production environments. It is not an official Uipath library. I suggest you rather write a powershell script yourself to get list items from SharePoint. It takes a little longer to develop, but much faster and you can design all the exception handling yourself. Mainly, you don’t have to look for documentation of that library, which I k…