Sharepoint list URL in column value. how do I get actual data??

[trevor-adare]

I have extracted a sharepoint online list and some of the columns are returning a sharepoint path rather than actual data.

example - <a href="https://ZZZZ.sharepoint.com/sites/Hub/_layouts/10/listform.aspx?ListId=%7B01811306%2D1AAA%2D423F%2D9... Entries</a>

If I paste this into my browser, it resolves into a sharepoint form, where I can see the actual values that I would expect to be in column pulled through from sharepoint.

Can any tell me how I can resolve this path so that I can use the values in my visualisations? 

I've tried looking in FieldValueAsText but no joy.

Many thanks

[edhans]

You connected to it using the SharePoint.Tables function, right? That is what you get when you connect to "SharePoint List." 

All values should be in columns on their own. There is no need to get URLs to find the data. If the columns are being hidden from you via the SharePoint List connection, you need to talk to your SharePoint admin and either get the settings/visibility of those columns changed, or your permissions changed.