SharePoint List - get URL columns

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

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.