Bulk insert to Excel from Power Automate - A lot faster

If your SharePoint exports to Excel take minutes—or even hours—you’re probably blaming throttling, Graph limits, or SharePoint itself. In this video, I show why none of that is the real problem. You’ll see how writing rows to Excel one by one becomes the hidden bottleneck in Power Automate, and how switching to a bulk insert approach using Office Scripts can reduce execution time from minutes to seconds. We’ll walk through the bulk insert strategy, build a JSON array for passing rows efficiently, generate an Office Script with ChatGPT, and wire everything back into a Power Automate flow. You’ll also learn how large your JSON payload can realistically be and what to watch out for in real-world admin exports. This video is especially useful for SharePoint admins exporting large datasets, audit logs, or reporting data to Excel. To enroll in my Udemy courses see below link for discount vouchers https://sslwsh008.securedata.net/dotn... This video contains: 0:00 Introduction and Excel export pain points 0:35 Understanding root cause of the problem 3:03 Bulk insert from Power automate to Excel using Office Scripts 3:43 Bulk insert strategy 5:30 Creating a JSON array to pass new rows to Office Script 9:15 A course to master Power Automate expressions 9:55 Using Chat GPT to create bulk insert office script 13:38 Calling Office Script from Power Automate flow 14:31 Testing the bulk insert to Excel using Power Automate 15:33 How big can the JSON array be 16:27 Conclusion Contact me LinkedIn   / alirezaaliabadi   Twitter   / aaliabadi1   Instagram   / alireza.aliabadi_ig   Facebook   / alireza.aliabadi.fb