Fastest Way To Read Large Excel Table In Power Automate

This article explains how to read large Excel tables in Power Automate quickly. The author uses the HTTP With Azure AD connector and the Microsoft Graph API to get all rows from an Excel table instead of the Excel connector. The HTTP With Azure AD connector can fetch 50,000 rows in only 7 seconds, while the Excel connector built into Power Automate takes over 5 minutes to do the same actions. The article provides a step-by-step guide on how to create an Excel table, get the Drive ID and Item ID from the Excel file, configure a connection to Microsoft Graph, read the rows from an Excel table using HTTP With Azure AD, transform the response into a flattened array of Excel rows, and parse the JSON array into a set of dynamic values.

Article 18m Matthew Devaney

---

Login now to access my digest by 365.Training

Login