-
Power Automate: Read / Write to Excel using Microsoft Graph (Fast!)
Prologue Working with Excel files using Power Automate is relatively straightforward, thanks to the standard Excel connector. It works well for small files, but things can get challenging with larger ones. Your flow may struggle with ‘Apply to Each’ loops to handle large datasets, and the biggest issue? It’s painfully slow. The good news is…
-
Super fast way to create large Excel table from Power Automate
Prologue Exporting data to Excel file is easy with Power Automate using ‘Add a row into table‘ action. but the main problem is it’s incredibly slow and inefficient. In this post, I will show more efficient way to perform the same thing but far way faster. Dataset I will use my sample dataset called ‘Data100K’…
-
Power Apps | Dealing with large SharePoint List (100K+ records)
Greetings Hey everyone, hope you’re all doing well. I wanted to chat about something pretty exciting today—my recent experience with handling large SharePoint lists in Power Apps. Let me share what I’ve learned and how it can help you tackle similar challenges. Prologue Working with SharePoint as a data source in Power Apps is a…