The ask, take a date value as input and output its calculated day of the year using Power Fx. Not a fancy request, but it is an ask. E.g., November 1, 2025, is the 305th day of the year. Figure 1 - Power Apps canvas app with date picker and label elements. Breaking down the … Continue reading Power Fx: Date Picker | Calculate Day of the Year
Power App Canvas App
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
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
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 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 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 Apps: Canvas App | Merging Data Sources w/ AddColumn()
Scenario: There is a canvas app with a text box, two radio choices, a vertical gallery, and two data sources. Toggling the radio button changes which data source is filtered and used to populate the gallery. Problem: The data sources don't have any data columns in common and Power Apps doesn't like that. Solution: Create … Continue reading Power Apps: Canvas App | Merging Data Sources w/ AddColumn()
Power Apps: Canvas Apps | Office365Users – Profile Errors
The Office365Users connector gets tricky when makers are working with incomplete user profiles. Especially when trying to display user profile photos. Does everyone have a picture? Even the contractors? Unfortunately, everyone isn't guaranteed to have an uploaded profile photo. Making the assumption that they do only invites future problems. To be proactive, default to the … Continue reading Power Apps: Canvas Apps | Office365Users – Profile Errors
Power Apps: SharePoint | Delegation + AddColumn()
So yeah, this won't work for everyone, but it was a creative delegation workaround for me. In my scenario, I used several SharePoint Online (SPO) lists as data sources and needed to filter on a multi-line column of employee Names, separated by a semi-colon: Figure 1 - SharePoint Online new item form. This example SPO … Continue reading Power Apps: SharePoint | Delegation + AddColumn()
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 Apps: Build a Game… !NeRdlE!
!JeOpArDy was my last canvas app game, so it's been a while. Working on another canvas app, I wanted to give "Nerdle" a try. Important to note though, I'm only replicating maybe 80% of the game. With this in mind, puzzles are hardcoded and not loaded from an external source. Also, keeping this post from … Continue reading Power Apps: Build a Game… !NeRdlE!
Power Fx: Understanding | With()
Power Fx is the Excel-like programming language of the Power Platform, more specifically canvas apps. As with any of their programming offerings, Microsoft has bundled plenty of pre-built functions into Power Fx. Among these bundled functions, With() is easily a standout. If you haven't worked the With() function into your canvas apps yet, then you're … Continue reading Power Fx: Understanding | With()
Power Apps: Canvas App | SubmitForm() + SPOItem [Attachments w/ Permissions]
SharePoint Online lists are flexible as Power Apps canvas app data sources. Not quite as popular as SQL, but app makers can use SPO lists like database tables. One major perk of leveraging SPO lists, they're created ready to handle item attachments without makers needing to configure Azure BLOB storage. Still, there is a permission … Continue reading Power Apps: Canvas App | SubmitForm() + SPOItem [Attachments w/ Permissions]
Power Apps: Canvas App | Best Practices + Tips
Power Apps come in two flavors. To begin, there are model-driven apps, which are built on the Microsoft Dataverse and are more data-focused. These model-driven apps are not meant to be pretty. However, canvas apps are customizable and can be pretty, so they're more UI/UX-focused. Contrasting the two approaches, makers should build canvas apps if … Continue reading Power Apps: Canvas App | Best Practices + Tips
console.log('Charles'); 