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 Platform
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]
Power Platform: Data Sources | SQL Tables or Dataverse Tables
The Power Platform is Microsoft's collective of no-code/ low-code solutions. To supplement this platform, Dataverse is Microsoft's secure, no-code/ low-code data storage solution. SQL Server is still a strong contender for data storage, but leveraging it requires some mastery of SQL. Dataverse, however, stores data in tables just like SQL, but doesn't require any proficiency … Continue reading Power Platform: Data Sources | SQL Tables or Dataverse Tables
Power Automate: Understanding | mod()
Modulus (or modulo) is another of the math expression available in Power Automate. Similar to the add(), sub(), mul(), and div() expressions, mod() accepts two parameters, but instead only returns whole numbers, so no decimals. Likely an over-simplified explanation, but in computing, modulo is essentially the calculated remainder of a division calculation. Figure 1 - … Continue reading Power Automate: Understanding | mod()
Power Apps: Canvas Apps | Data Refresh – Manual v Timed
Canvas apps are Microsoft's low-code business apps of the Power Platform, capable of interacting with data from a variety of data sources. Keeping that in mind, app makers should design their apps with data refreshes in mind because after the initial app start, users are working with copies of the loaded data, not live data. … Continue reading Power Apps: Canvas Apps | Data Refresh – Manual v Timed
Power Platform: Data Sources | SQL Tables or SPO Lists
The Power Platform is Microsoft's collection of low-code, citizen developer solutions. Being low-code, makers don't need coding experience to build their apps, bots, automations, and/ or dashboards. Even so, makers still need to decide where their data should ultimately live. For most people, SQL is typically the go-to data storage consideration. And honestly, SQL isn't … Continue reading Power Platform: Data Sources | SQL Tables or SPO Lists
Power Fx: Calculate | Calculate Days in a Month
Power Fx is the Excel-like, formula language of the Power Platform. Akin to Microsoft Excel, most of the functions are only reasonably powerful on their own. When they're combined though, they become much more awe-inspiring. For example, calculating the number of days in a month. Calculating this, makers only need a handful of functions and … Continue reading Power Fx: Calculate | Calculate Days in a Month
console.log('Charles'); 