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 ContentsUse Connection References Instead Of ConnectionsRemove Duplicate Connection References From SolutionsDe-duplicate Connection References In EnvironmentsAssign Connection Ownership To Service Accounts Use Connection References Instead Of Connections Flow actions requiring authentication must use either a connection or a connection…
Table of ContentsWhy Write Code Comments?Tips For Writing Good CommentsDisplay Power Automate Expressions In The Flow CommentsDo Not Use The Collaborative Comments Feature For Coding Comments Why Write Code Comments? Write comments to describe the intended goal of a section of Power…
Table of ContentsTry, Catch, Finally PatternGroup Multiple Actions Inside Of A Scope ActionTerminate The Flow With A Status Of Success Or FailureNotify The Process Owner Of The Flow FailureGet The Flow Error Message For The Failed ActionInclude The Flow Run…