How to Update Excel Rows from Power Automate (The Efficient Way) скачать в хорошем качестве

How to Update Excel Rows from Power Automate (The Efficient Way)

Updating Excel rows from Power Automate can be painfully slow when you rely on Apply to each and Update a row. In this video, I show why Excel updates are slow, what’s really happening behind the scenes with connections, and how to fix it the efficient way using Office Scripts. We take a real flow that updates 100 Excel rows in ~80 seconds, then rebuild it using an Office Script and call it from Power Automate — reducing execution time to under 5 seconds. To enroll in my Udemy courses see below link for discount vouchers https://sslwsh008.securedata.net/dotn... ⏱ Timestamps 0:00 – Introduction & the performance problem 1:06 – Inside the slow Power Automate flow 2:25 – Why Excel updates are so slow (connections) 3:29 – Introduction to Office Scripts 4:03 – Recording your first Office Script 7:15 – Asking ChatGPT to generate the script 10:14 – Calling the Office Script from Power Automate 11:53 – Performance testing with Office Scripts 14:35 – Conclusion Contact me LinkedIn   / alirezaaliabadi   Twitter   / aaliabadi1   Instagram   / alireza.aliabadi_ig   Facebook   / alireza.aliabadi.fb