Create & Populate Excel File Fast - Office Scripts without an Apply to Each

If you are looking to export data from SharePoint Lists or DataVerse Tables using PowerAutomate and Import this into Excel fast and efficiently (6 seconds for 1000 items/rows during this video), you need to give Office Scripts a try. The "add rows to a table" action running in an "apply to each" for large data sets will timeout or be extremely slow. Let me show you how you can use OfficeScripts and load datasets with large volumes in a handful of seconds.

Can't use Office Scripts? Have you tried looking at Graph API?    • Create and Populate an Excel File Fas...  

With Office Scripts you do not need to reference a table like the traditional excel actions. In my final solution, I create a brand new Excel File using a technique I have previously demo'd here    • Create a new Excel File in Power Auto...  

0:00 - Intro and Overview
1:22 - First Flow using Apply to Each & Add Row to Table
3:51 - Second Flow Using Office Scripts for Fast and Efficient Import
6:51 - Reviewing the Office Script in the Code Editor
9:42 - 1000 Dataverse table rows into an existing Excel file in 6 seconds flat!
10:46 - Third Flow Creating a new Excel File with the Dataverse Data

#Dataverse #SharePoint #Lists #PowerAutomate #OfficeScript

Download sample script https://github.com/DamoBird365/PowerA... Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕