The ask, suggest some structural changes for a few Power Automate cloud flows to improve readability. The flow makers are already adding comments and notes to their controls, but their flows still come across as unstructured. The proposed solution, add and nest flow actions into Scope controls: Figure 1 - Power Automate cloud flow with … Continue reading Power Automate: Cloud Flow + Better Readability (Scope Controls)
Power Automate Controls
Power Automate: Cloud Flows + Complex Conditional Logic
The ask, see if there is a better way to conditionally update a Salesforce record whenever there is a value mismatch between it and SharePoint Online (SPO), the source system. There is already a Condition block with a nested Update record action, but can the condition logic be improved? Figure 1 - Power Automate cloud … Continue reading Power Automate: Cloud Flows + Complex Conditional Logic
Power Automate: Cloud Flow Gotchas | Infinite Loops
The ask, figure out why a maker's cloud flow is running more than expected. Their flow was only recently enabled for PROD, but they reported receiving an email (Figure 1) that their flow was "performing slow" shortly afterwards. Shortly after that, they received a second email (Figure 2) that their flow was "running too many … Continue reading Power Automate: Cloud Flow Gotchas | Infinite Loops
Power Automate: Do While Loop | Calculate Power Of
The ask, create a Power Automate cloud flow to calculate exponentiation, a base value taken to the power of an exponent value. Ultimately, this flow will be one of many flows filling in where Microsoft hasn't yet provided an expression. For this ask, create a new cloud flow and choose "When Power Apps calls a … Continue reading Power Automate: Do While Loop | Calculate Power Of
Power Automate: SharePoint Online | Update Document Set Metadata
The ask, update the metadata of a document set using a Power Automate cloud flow. In this ask, the document sets are created when certain conditions are met in an external source system. Post-creation, that metadata is kept in sync, receiving updates as changes are made in the source system. So, creating the document set … Continue reading Power Automate: SharePoint Online | Update Document Set Metadata
Power Automate: Dynamically Compose HTML Emails
Power Automate can do so much more than send emails, but even so, there are plenty of processes still relying on emails. Some processes depend on emails to report workflow success or failure, others prompt for task approvals, and a few simply provide content queried from a dataset somewhere. Figure 1 - Power Automate cloud … Continue reading Power Automate: Dynamically Compose HTML Emails
Power Automate: Cloud Flow | Best Practices + Tips
Power Automate is the process automation service of the Power Platform. Makers leveraging the solution can build both desktop and cloud flows, but each comes with their own considerations. Though, more people are likely building cloud flows than desktop flows. And for those cloud flow makers, there are some best practices, tips, and factors to … Continue reading Power Automate: Cloud Flow | Best Practices + Tips