The ask, rethink error email recipients of a Power Platform solution. The original maker needs to transfer ongoing support to the help desk and presently, if there's an issue, the cloud flows are designed to email the maker directly. Fortunately, the solution's data source is a series of SharePoint Online (SPO) lists, so there's at … Continue reading Power Platform: SPO Data Sources + Error Emails
Power Automate Best Practices
Power Automate: Cloud Flows | Terminate Unnecessary Runs
The ask, address a Power Automate cloud flow that needlessly continues to run even when there's no data to process. This particular flow is an Automated cloud flow, and it runs daily, emailing a dynamic list of people a digest report of SharePoint Online list items created the day prior. The flow is triggered, then … Continue reading Power Automate: Cloud Flows | Terminate Unnecessary Runs
Power Automate: Cloud Flow + Better Readability (Scope Controls)
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: Cloud Flow | Filter Datasets Better
The ask, improve a long running cloud flow's performance. It has a Get files (properties only) action querying 2,000 recent items which are filtered using a Condition block. Because the library already has 100K+ items, OData filters can be hit or miss, so the maker is iterating each returned item, causing the flow loop to … Continue reading Power Automate: Cloud Flow | Filter Datasets Better
Power Automate: Cloud Flows | Is the Array Empty?
The ask, suggest some alternative Power Automate logic for a group of non-dev cloud flow makers. Arrays and functions are new concepts to them, but they understand variables. So, instead of using the length() function to determine whether or not an array is empty, they would like some "more intuitive" logic for their Condition blocks: … Continue reading Power Automate: Cloud Flows | Is the Array Empty?
Power Automate: Cloud Flows + Better(er) Error Reporting
The ask, build on the better error reporting and share the actual error message when a cloud flow action fails. Earlier, the cloud flows were generating way too many error messages, one for each failed action, which was resolved using an array variable to store custom messages specified by the maker, then generating a single … Continue reading Power Automate: Cloud Flows + Better(er) Error Reporting
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: SharePoint Online | Check If Document Set Exists [ v3 ]
The ask, find another, another way to determine whether a document set exists or not. Still using the Deal ID value as the unique identifier, instead of adding the Get files (properties only) action [ option #2 ], use the Send an HTTP request to SharePoint action. This particular HTTP request action takes advantage of … Continue reading Power Automate: SharePoint Online | Check If Document Set Exists [ v3 ]
Power Automate: SharePoint Online | Check If Document Set Exists [ v2 ]
The ask, determine whether or not a document set exists before Power Automate tries to create one. Otherwise, the cloud flow will run long, appear stuck, and eventually fail. The flow could check for an existing document set by Name, but because SharePoint Online (SPO) isn't the source of truth system. this column value isn't … Continue reading Power Automate: SharePoint Online | Check If Document Set Exists [ v2 ]
Power Automate: SharePoint Online | Check If Document Set Exists
Document sets aren't new to SharePoint Online (SPO), but plenty of organizations are just discovering them as they're a great way to bundle related documents. And document sets allow organizations to group and manage these related files as a single entity, defining metadata for the entity instead of individual files. Figure 1 - SharePoint Online … Continue reading Power Automate: SharePoint Online | Check If Document Set Exists
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: Application Lifecycle Management | Housekeeping
Power Automate cloud flows are environment specific when they're created. Power Platform application lifecycle management controls the management of cloud flows as solution assets, and proper management guides the deployment and maintenance of these solutions. Whether the solutions are managed or unmanaged, flows are deployed from one environment to another. Typically, makers create and test … Continue reading Power Automate: Application Lifecycle Management | Housekeeping
Power Automate: Loops + Concurrency (/Parallelism)
Power Automate is versatile. As the automation engine of the Power Platform, it can connect with dozens of data sources to build repeatable work processes. And to enumerate datasets of these data sources, the Apply to each control is used to loop through the data records. But as datasets grow, expect the flows to take … Continue reading Power Automate: Loops + Concurrency (/Parallelism)
Power Automate: Error Handling | Scope Controls [try/catch/finally]
Reiterating, "high-code" error handling isn't supported in Power Automate. However, flow creators can use Scope controls and mimic a try-catch-finally execution: Figure 1 - Power Automate list of controls. To recreate the "try-catch-finally"-esque experience, add three Scope blocks to the flow and rename each: Try, Catch, Finally. Next, add the necessary actions to each Scope, … Continue reading Power Automate: Error Handling | Scope Controls [try/catch/finally]
Power Automate: Error Handling | Mitigation
Power Automate is a no-code (/ low-code) workflow automation solution. Because the service isn't "high-code", developers can't create flows with traditional try-catch-finally blocks for robust error handling. But flows could be designed with "error mitigation" in mind. Otherwise, these flows will fail without recovery. To mitigate some anticipated issues, makers can use Power Automate expressions … Continue reading Power Automate: Error Handling | Mitigation
console.log('Charles'); 