The ask, correct a failing Power Automate cloud flow. For months, this flow ran daily, without issue, querying a growing SharePoint Online list, but now, the Get Items action is failing and throwing an error: "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold." Figure 1 … Continue reading Power Automate + SharePoint Online: Get Items | Lookup Column Threshold Error
Cloud Flows
Power Platform: Canvas App + Cloud Flow | SPO List Config.
The ask, propose an alternative configuration option for a Power Platform solution. The maker created a Power Apps canvas app and a Power Automate cloud flow. When items are submitted, others are prompted via email, sent by the cloud flow, to open the canvas app and complete an action. Following best practice, the maker created … Continue reading Power Platform: Canvas App + Cloud Flow | SPO List Config.
Power Platform: SPO Data Sources + Error Emails
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: 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 Error Reporting
The ask, introduce some better error reporting for a troublesome production cloud flow. The maker just recently deployed their solution to PROD, with some pretty good error handling, but this flow is experiencing some quirks not seen in DEV or QAT, so there are more errors than expected. And unfortunately, each error handled action sends … Continue reading Power Automate: Cloud Flows + Better Error Reporting
SharePoint Online: Appended Comments + Canvas Apps + Cloud Flows
The ask, get the appended comments of a SharePoint Online (SPO) list item. One of the makers is working on a Power Apps canvas app and their data source is an existing SPO list. In this list, the maker has a "Comments" column with the Append changes to existing text setting enabled. Per the project … Continue reading SharePoint Online: Appended Comments + Canvas Apps + Cloud Flows
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: 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
console.log('Charles'); 