Forum Discussion
Possible to load Sharepoint list using Sharepoint.Contents( ) ?
- 2 years ago
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.
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.
- gancw12 years agoResolver II
Noted and thanks !
I believe that should be SharePoint.Tables() and not SharePoint.Lists()