PowerPlatform_Kenya

Lately I've been obsessed with using #PowerAutomate & #MSGraph to work on #Excel files 🤖📝 Here's the top 5 things I learned 😲 1️⃣ Reading #Excel tables is faster with Graph. I read 50k rows in 7s vs. the Excel connector which took 5m. 🔥 2️⃣ Multiple rows can be written to an Excel table with #MSGraph in a single call. It took me only 1s to write 10 lines vs. 14s doing 1 call per row with the Excel connector🐇 ☁ 3️⃣ #MSGraph can do all of the things the Excel connector cannot do. Get values from an individual cell or a named range. Formatting. Create sheets and charts, etc. ♥ 4️⃣ There is a Batch Processing API which allows multiple actions to be run at once. You can get the values from 10 different named ranges at once instead of getting them sequentially. 👨‍💻 5️⃣ HTTP With Azure AD is the best way to make Graph API calls. Security is automatically based on the user account who ran the action. Using the HTTP connector is more complicated because you must make some fancy calls to get a bearer token first 🔓

#PowerAutomate can write to #Excel at blazing fast speeds using #MSGraph 🔥 I created 10 rows in 1️⃣ second with Graph vs. 10 rows in 1️⃣4️⃣ seconds with the built-in Excel connector. The best part is it scales to 100k rows! 👍👍 Here's how I did it: 🔗matthewdevaney.com/quickly-a…