Get Over 5000 Items From A SharePoint List In Power Automate

The Power Automate SharePoint - Get Items action can return over 5000 SharePoint list items by increasing the top count and using pagination. If you have a large SharePoint list with over 100,000 items, you must use the SharePoint - Send An HTTP Request action instead. This article covers both methods. Method #1: Increase Top Count And Enable Pagination - Create a SharePoint list with over 5000 items - Get items from SharePoint and increase top count to 5000 - Run the flow to get over 5000 list items Method #2: SharePoint HTTP Request With Pagination - Initialize variables for list items and SharePoint URI - Use pagination to get over 5000 SharePoint list items - Send an HTTP request to get SharePoint list items - Store the array of SharePoint list items in a variable - Follow the next link to get the next page of results - Run the flow to get over 5000 items from a SharePoint list

Article 3m Matthew Devaney

---

Login now to access my digest by 365.Training

Login