Forum Discussion
Possible to load Sharepoint list using Sharepoint.Contents( ) ?
No, you cannot directly load a SharePoint list using SharePoint.Contents() in Power Query. SharePoint.Contents() is used to access the contents of a SharePoint site, such as document libraries and folders, but to specifically access a SharePoint list, you should use SharePoint.Lists() instead. This function allows you to retrieve data from a specific SharePoint list, making it more suitable for working with list data directly.
SharePoint doesn't store files quite how you expect. It necessary for the content connector to differ from the list connector due to this backend distinction.
The SharePoint front end does a great job of fooling you into thinking that that structure is what the backend looks like. Its not. Its much more flat.
Noted and thanks
