Power Query
published
Search
K

SharePoint.Tables

SharePoint.Tables

Returns a table containing content from a SharePoint List.
function (url as text, optional options as nullable record) as table

Description

Returns a table containing a row for each List item found at the specified SharePoint list, url. Each row contains properties of the List. options may be specified to control the following options:
ApiVersion : A number (14 or 15) or the text "Auto" that specifies the SharePoint API version to use for this site. When not specified, API version 14 is used. When Auto is specified, the server version will be automatically discovered if possible, otherwise version defaults to 14. Non-English SharePoint sites require at least version 15.

Category

Accessing data