SharePoint List Reader
Reads items from a SharePoint Online list into a PAD DataTable using Microsoft Graph API. Supports filtering by column value, selecting specific columns, and pagination.
Sign in or create a free account to copy this script.
Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.
Problem this solves
Users want to use SharePoint lists as configuration or queue tables but can't easily pull data into PAD.
Usage Notes
- 1.Graph API uses internal column names, not display names.
- 2.5,000 item threshold — use Pagination Loop Handler for larger lists.
- 3.OData filter syntax: eq, ne, gt, lt, startswith, contains with and/or.
- 4.App Registration requires Sites.Read.All with admin consent.
Dependencies
- REST API POST Caller
- Pagination Loop Handler
- SharePoint File Downloader