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:

Using the $top parameter to return the top 300 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
Leave a Reply