Fetch SharePoint List Item Version History in PowerApps

This article will walk you through two different options for retrieving SharePoint Item Version History in Power Apps using Power Automate. Both solutions are designed to be ALM-friendly and avoid using Premium Connectors. If you’re not familiar with SharePoint Item Version History, you can access it by selecting the context menu for a list item and choosing Version History. Context Menu to access SharePoint item version history The modern modal dialog of a item's version history For this example, I have a simple SharePoint list consisting of Financial Validation events. These events are managed out of a Canvas…

0 Comments

Creating a Process Bar Component in Canvas Apps

As a busy user, I appreciate being able to see a visual indicator of the stage/status of an item at a glance. Model-Driven Applications, have Business Process Flows which include a nice visual control, which displays a process bar of the current stage. The process bar in a Model Driven App This led me to wonder: could I create something similar on the Canvas App side? In this post, I’ll demo my custom reusable component that visually represents stages in a Canvas App. The custom canvas app component built Example: Ordering Process Consider an example where you are…

Comments Off on Creating a Process Bar Component in Canvas Apps

Collect External Responses in Dataverse Using Microsoft Forms

A common requirement is the need to collect responses from users outside of your organization. Anyone who's spent a good deal of time within Power Platform knows this can quickly turn into a very complex task! I don't want to license external users and I don't want to build a Power Page to collect some simple form responses! Surely there's got a be a simpler way? Well, with the help of the pre-filled URL feature in Microsoft Forms, and a little Power Automate, there is! Scenario: Event Response Submissions In this example, I'm gathering Power Platform Conference Event…

Comments Off on Collect External Responses in Dataverse Using Microsoft Forms

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…

Comments Off on PowerApps Week of Selector Component

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

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

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