How to Use the SharePoint REST API with Power Automate to Fetch More Than 100 Items

This post was updated:

The SharePoint REST API, when used in Power Automate, returns a maximum of 100 items by default. Here is one method you can use to retrieve more than 100 items:

_api/web/lists/getbytitle('<List Name>')/items?$top=300

See also:

HTTP Request to SharePoint limited to 100 results

Solutions to the SharePoint 5000 item limit using Power Automate