PowerApps

Read more about the article PowerApps Week of Selector Component
PowerApps Canvas

PowerApps Week of Selector Component

Have you ever needed to filter data based on the week of? To use a select-able dropdown, you first need to figure out the week start date based on the current date, week end, build a dynamic collection, filter, date add, sequence… yada yada, blah blah! Instead of doing all that in multiple apps, why not build one reusable component that handles all that tricky date calculation logic? That’s exactly what we’ll cover in today’s post. Component Goals Develop a reusable component that displays the week of start and end date in a dropdown Allow the user to…

0 Comments
November 12, 2025
Read more about the article PowerApps Modern Buttons Icon Name Cheat Sheet
PowerApps Canvas

PowerApps Modern Buttons Icon Name Cheat Sheet

Modern Controls in PowerApps Canvas Apps have been with us for a few years now. And while they are still in preview at the time of this post, some controls are more “mature” than others from my experience. One of these is the button control. Unlike the classic button control, the modern one can include an icon within the button making for a better visual experience to the end-user. Indeed, there are 73 modern button icons to choose from. Where I had some challenges however, is that I wanted to know all the icon names so I can…

Comments Off on PowerApps Modern Buttons Icon Name Cheat Sheet
October 8, 2025
Read more about the article Retrieve Environment Variable Values using JavaScript
JavaScript / PowerApps Model Driven

Retrieve Environment Variable Values using JavaScript

This guide shows how to use JavaScript to query Dataverse environment variables and reference the values within a Model Driven App. This guide assumes you already know how to add JavaScript as a web resource and attach it to a Model-Driven App form. If not, I would review Microsoft's guides here: Create or edit model-driven app web resources to extend an app View and edit web resource properties for model-driven app forms Display Text Environment Value in a Notification Banner In the first example, we’ll use the formContext.ui.setFormNotification API to display an email address directly on the form.…

Comments Off on Retrieve Environment Variable Values using JavaScript
September 13, 2025
Read more about the article Hide a Business Process Flow Using JavaScript
JavaScript / PowerApps Model Driven

Hide a Business Process Flow Using JavaScript

In some scenarios, you may want to hide a Business Process Flow (BPF) once the entire process is complete. In this post, we’ll walk through how to achieve this in a model-driven app using JavaScript. Once the last stage is completed, the JS code hides the control. The Methodology We can use the formContext.data.process client API to determine the status of the BPF with the getStatus method. When the process is complete, this method returns the string value "finished". Then, call the formContext.ui.process.setVisible method to hide or show it. Applying the Code Create a new web resource and…

Comments Off on Hide a Business Process Flow Using JavaScript
August 9, 2025
Read more about the article Intro to Deep Linking in PowerApps
Dataverse / Power Automate / PowerApps Canvas / PowerApps Model Driven

Intro to Deep Linking in PowerApps

Instead of opening an app's main screen, there are scenarios where you'd want to directly take a user to a specific screen. This post will explore how to deep link to a specific record in both Canvas and Model Driven Apps. Example Use Case Consider an example where app contains Purchase Orders. When someone creates a new purchase order (PO), Power Automate sends an email to the manager with a deep link to the corresponding PO. The deep link directly to the main form for that PO. A Deep link in an email navigating to the Main Form…

Comments Off on Intro to Deep Linking in PowerApps
July 6, 2025
Read more about the article Calculate Age using PowerApps
PowerApps Canvas

Calculate Age using PowerApps

On the surface, the calculation for a person's age in PowerApps seems simple enough: use the DateDiff function to take the current date and the difference between their birthdate and return in years. However, in PowerApps, it's not quite so straight-forward! For example, let's say the current date is 6/5/2025, and someone's birthdate is 7/4/1989. Using DateDiff: DateDiff(Date(1989,7,4),Date(2025,6,5),TimeUnit.Years) The function returned 36 and not 35 like we would expect! The person wouldn't be 36 until it's 7/4/2025. Turns out, the PowerApps DateDiff function behaves differently than it's Excel counterpart. Unlike DateDif function in Excel which, by default, calculates…

Comments Off on Calculate Age using PowerApps
June 7, 2025
Read more about the article Get SharePoint Column Descriptions into a PowerApps Form
PowerApps Canvas

Get SharePoint Column Descriptions into a PowerApps Form

Within a SharePoint list, it's common practice to add a description to your columns. Naturally, you would want to provide a description to aid users in filling out the form. The out of the box form experience in a SharePoint list will display descriptions automatically. However, if you're building a Canvas PowerApp using the Form control, you’ve probably noticed the descriptions are missing. Frustrating! The description fields are present in the default SharePoint list form. The same list connected to a PowerApps Form...no descriptions show. 😐 To address this limitation, I’ve seen some workarounds—like hardcoding the description directly…

Comments Off on Get SharePoint Column Descriptions into a PowerApps Form
May 31, 2025