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