Forum Discussion
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 ...
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!
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
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!