Quickly Add Multiple Rows to Excel Table In Power Automate
This article explains how to quickly add multiple rows to an Excel table using a single Power Automate action. The HTTP for Azure AD connector can add 10 rows to a table in 1 second, compared to 14 seconds using the Excel connector. This technique can scale up to 100,000 rows added at once. The article provides a step-by-step guide on how to set up the SharePoint list, create an array of multiple Excel rows, make a new Excel workbook with a table, get the Excel workbook drive ID and item ID, configure a connection to the Microsoft Graph, and add multiple rows to an Excel table using HTTP with Azure AD. The article also includes a table of contents and related posts.
Article 18m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time