Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

Get data from SharePoint list folder

Hello,

I want to retrieve data from a SP list folder.

Neither the list connector nor the folder connector seemed to work.

I tried with OData but cannot authenticate for a weird reason.

Any ideas? Thank you 🙂

Anonymous
1 year ago
That was what I was doing but I could only access the tables within the list.
The issue was that there were folders.

The solution was to use v1.0 of online lists!

2 Replies

Anonymous
Not applicable
1 year ago
Hi,

When you connect to a Sharepoint you'll need to only use the start of the Sharepoint URL:
https://COMPANY.sharepoint.com/sites/YOURSHAREPOINT/

In Power Query you can then navigate to the folder you want to connect to. Either by the url link to the right or to change the connection type from Sharepoint.Files to Sharepoint.Contents
- Anonymous
  Not applicable
  1 year ago
  That was what I was doing but I could only access the tables within the list.
  The issue was that there were folders.
  
  The solution was to use v1.0 of online lists!