HubSite 365Power Automate: Excel Is the Bottleneck
🟪 Excel writes are the bottleneck in Power Automate 🚀
If your SharePoint exports to Excel take minutes or hours it's likely due to row by row writes.
The video shows switching to a bulk insert using Office Scripts and a JSON array to cut run time from minutes to seconds.
It also covers creating the JSON payload generating the Office Script with ChatGPT and wiring it into a flow.
💡 Bulk insert via Office Script
🔍 JSON array for rows
⚖️ Time cut from minutes to seconds
Ready to speed up your exports?
▶︎https://www.hubsite365.com/en-ww/citizen-developer/?id=c6a5df47-b9fa-f011-8406-000d3a4aeaab&topic=8daf8386-bb75-ea11-a811-000d3a210788&theater=true
