This is the pattern I use to create a new Excel file with Power Automate and add rows. It can take data from any datasource (SharePoint, Dataverse, SQL, etc.). And the file is dynamically generated so it is not necessary…
With this method I was able to get 50,000 rows from an Excel file in 7 seconds. By comparison, the Excel action built in Excel action is quite slow. It took over 5 minutes to get the same amount of…
Multiple rows can be added to an Excel table using a single Power Automate action. And the best part is its blazing fast. Using the HTTP for Azure AD connector I added 10 rows to a table in 1 second…
If you use the Power Automate Excel action to list rows present in a table you will notice an option to filter the result. In this short guide I will show you how to filter Excel table rows in Power…
Power Apps Powershell cmdlets give administrators access to a hidden group of commands that cannot be executed through the Power Platform admin center. Often times, these Powershell cmdlets get promoted into the user interface of Power Platform. It provides Microsoft…
Power Apps named formulas enable us to use the same app logic in several different places. Unlike a variable, named formulas do not store values in memory. They recalculate each time they are referenced. Named formulas ensure the most current…
Welcome to the Power Automate Coding Standards For Cloud Flows. In this guide you will find 60+ pages of coding rules, guidelines and best practices I use everyday to create Power Automate cloud flows. I have spent the last 3…
Table of Contents • Use Connection References Instead Of Connections • Remove Duplicate Connection References From Solutions • De-duplicate Connection References In Environments • Assign Connection Ownership To Service Accounts Use Connection References Instead Of Connections Flow actions requiring authentication…
Table of Contents • Why Write Code Comments? • Tips For Writing Good Comments • Display Power Automate Expressions In The Flow Comments • Do Not Use The Collaborative Comments Feature For Coding Comments Why Write Code Comments? Write comments…
Table of Contents • Try, Catch, Finally Pattern • Group Multiple Actions Inside Of A Scope Action • Terminate The Flow With A Status Of Success Or Failure • Notify The Process Owner Of The Flow Failure • Get The…