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 Platform
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: Do While Loop | Calculate Binary Of
The ask, convert a whole number to binary. The approach, use a do-while loop and the cloud flow to calculate the power of a number, calling it as a child flow. At some point, this flow may also be used as a child flow, so create it using the Respond to a Power App or … Continue reading Power Automate: Do While Loop | Calculate Binary Of
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: 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
SharePoint Online: JSON Column Formatting | Link to Power Apps
The ask, create a dynamic link from a SharePoint Online (SPO) document library, navigating end-users to a Power Apps canvas app. This app expects "deal_id" as a parameter, Param(), which would be the id of the library item. Is it possible? Yes. Is it complicated? No. SPO libraries, which inherit from lists, are relatively easy … Continue reading SharePoint Online: JSON Column Formatting | Link to Power Apps
Microsoft Dataverse: Table Designs w/ Copilot
The ask, create new Dataverse tables for an upcoming initiative. There are several existing tables that could be used for this initiative, but the project requirements necessitated new tables be created. Because this is an upcoming initiative, business stakeholders aren't ready to build the solution UI, even though Microsoft Copilot could create everything for them: … Continue reading Microsoft Dataverse: Table Designs w/ Copilot
Microsoft Dataverse: Virtual Tables [ Pros ]
Unfortunately, Microsoft Dataverse isn't a data storage consideration for many Power Platform makers because their organizations are already using other data sources like SQL Server, Salesforce, SharePoint Online (SPO), etc. These other data sources are well-supported, but Dataverse is the foundation of the Power Platform, so there is native integration for it in Power BI, … Continue reading Microsoft Dataverse: Virtual Tables [ Pros ]
Power Apps: Canvas App | Ranked Choice Voting (RCV)
This is likely to be a lengthy post because there was no ask today. I just wanted to stress test nested Power Fx With() functions a bit. My question, "Are there any performance concerns nesting With() functions?" To test this and maybe get an answer, I created a Power Apps canvas app to determine the … Continue reading Power Apps: Canvas App | Ranked Choice Voting (RCV)
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 Apps: Application Lifecycle Management | Housekeeping
Power Apps canvas apps are easy enough for citizen devs to build without a traditional developer's background. And they can build some pretty complex solutions. Unfortunately, as apps grow in complexity, devs rarely remember to clean up their solutions and remove unnecessary elements, especially as solutions are promoted from one environment to another. Likely the … Continue reading Power Apps: Application Lifecycle Management | Housekeeping
Power Platform: Application Lifecycle Management | Housekeeping
As with Power Automate housekeeping, good Power Platform solution hygiene means being intentional with design. Keep the managed and unmanaged solutions as lite as possible, and work to reduce the amount of unnecessary project assets. Larger Power Platform solutions can bundle dozens of different assets, as well as dozens of each asset type. For example, … Continue reading Power Platform: Application Lifecycle Management | Housekeeping
Power Fx: Unique Records w/ Duplicate Count
Scenario: I have a data source with thousands of addresses, and their street names need to be searchable in a canvas app. Problem: There are similar streets in other cities, so search results will contain duplicates. Workaround: Group similar addresses and display the NumberOf duplicates using the Power Fx's GroupBy function. Figure 1 - Canvas … Continue reading Power Fx: Unique Records w/ Duplicate Count
Power Automate: Ticketing System | Microsoft Teams + SharePoint Online [managed solution]
Some time ago, I architected a low-cost "service management"-esque app combining Microsoft Teams, SharePoint Online (SPO), and Power Automate. As a Power Platform low-code solution, I could piece everything together and demo a working ticketing system in a few hours. However, I never packaged the deliverable as a Power Platform managed solution, adhering to proper … Continue reading Power Automate: Ticketing System | Microsoft Teams + SharePoint Online [managed solution]
console.log('Charles'); 