10x Faster SharePoint Get Items In Power Automate

Power Automate can retrieve up to 5,000 SharePoint list items in just 2 seconds using the Send An HTTP Request to SharePoint action. This is much faster than the built-in SharePoint - Get Items action, which fetches 200 records at a time. The Send An HTTP Request to SharePoint action uses the SharePoint REST API to retrieve all list items in a single request. To demonstrate the speed difference, a comparison is made between the two methods in retrieving 5,000 car inventory records from a SharePoint list. The SharePoint - Get Items action takes over 1 minute, while the Send An HTTP Request to SharePoint action only takes 2 seconds. The article provides step-by-step instructions on setting up the SharePoint list and implementing the fast method using the HTTP request action.

Article 5m Matthew Devaney

---

Login now to access my digest by 365.Training

Login