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
Power Apps
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 Platform: Understanding | Solutions + Environments
Application lifecycle management is the governance, deployment, and maintenance of applications. Even though the Power Platform is "low-code", makers should still adopt the practice. More specifically, when deploying their projects as solutions across environments. So, what are solutions and what are environments? Solutions are bundled project assets. In the Power Platform ecosystem, these project assets … Continue reading Power Platform: Understanding | Solutions + Environments
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
Power Apps: Generate Custom GUID(s)
Acknowledging it early, yes, there is a Microsoft provided GUID() function already available in Power Fx. The function is handy and gets the job done. However, there are scenarios where makers may want to create their own GUID values. How? Well, nesting a small handful of Power Fx functions: Set() Concat() With() Sequence() Switch() ForAll() … Continue reading Power Apps: Generate Custom GUID(s)
Power Apps: Canvas App Styles | Inline vs Internal vs External
Power App canvas apps are easily personalized, but at the moment, not as easily styled as websites. Web developers can share and reuse their stylesheets across projects. Canvas apps, not so much. Even so, there are some similarities with styling scopes. There are three approaches to personalizing and branding canvas apps... Approach #1: Inline Every … Continue reading Power Apps: Canvas App Styles | Inline vs Internal vs External
Power Apps: Security + Access Layers
Power Apps aren't natively built for iOS or Android. Rather, these business apps are created and deployed a bit differently. And being deployed differently, organizations have more decisions to make with regards to app security. Power Apps security can be managed and granted at three layers: environment, app, and data. Power Platform Environment An environment … Continue reading Power Apps: Security + Access Layers
Power Apps: Deconstructing… LinkedIn
Power App canvas apps are "low-code" business apps. And because they're low-code, app makers don't need iOS or Android app development experience. Even so, creating any app from scratch can feel daunting. Why? Because makers often look to other published apps for inspiration. Inherently, this isn't bad, but keep in mind that these apps are … Continue reading Power Apps: Deconstructing… LinkedIn
Power App: Consistent Screens (w/ Components)
Power App canvas apps aren't built like native mobile apps. Even so, these business apps can still be built to follow some common software engineering best practices. Likely one of the more popular development practices is reusability. Where possible, build with modularization in mind. Applying this approach to canvas apps, app makers can create consistent … Continue reading Power App: Consistent Screens (w/ Components)
Power Apps: Design | Nested Galleries
Power App canvas apps are extremely customizable. As makers build their business apps, they can connect to data from dozens of sources and output data records dynamically. An easy way to list these records, bind the data source to a gallery control: "A control that contains other controls and shows a set of data… A … Continue reading Power Apps: Design | Nested Galleries
Power Apps: Design | Hover Menu
Power App canvas app makers often need to build menus for their apps. To create a hover menu, without using a component, just add the necessary menu controls, then select and group them. Grouped elements have properties similar to every other screen control: Figure 1 - Power Apps screen with several controls. Figure 2 - … Continue reading Power Apps: Design | Hover Menu
Power Apps: Build a Game… !JeOpArDy
The Power Apps platform is great for building business solutions. Even so, does it have to be all for work? Luckily, it doesn't. Just as business apps are created, developers could build simple games, too. For instance, designing a "Jeopardy"-esque game... Getting started, this example uses Microsoft Excel as it's data source. The Excel file … Continue reading Power Apps: Build a Game… !JeOpArDy
Power Apps: Name Randomizer
The gift giving season is here. Keeping with the festivities, many organizations are hosting virtual raffles. There are plenty of online name randomizers available, but building and personalizing a Power App is also an option... The raffle names can pull from almost any data source, or sources, but for testing, these names are manually entered … Continue reading Power Apps: Name Randomizer
console.log('Charles'); 