Yearly Archives: 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…

0 Comments
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
Read more about the article PowerApps Essential PnP PowerShell for SharePoint Provisioning
Automation / PowerShell

PowerApps Essential PnP PowerShell for SharePoint Provisioning

When importing PowerApps SharePoint-based solutions into upper level environments (such as from development to test environment), it’s typically necessary to provision a dedicated site and the lists that each environment will use. Unlike Dataverse solutions where importing a solution automatically creates the tables in the target environment, SharePoint sites and list resources are not. This gap led me to ask: what's the most efficient, programmatic way to create these SharePoint resources? Well, since you’ve read the title, you probably know where this is going: PowerShell PnP to the rescue! I'm going to assume you already have the SharePoint…

Comments Off on PowerApps Essential PnP PowerShell for SharePoint Provisioning
May 30, 2025
Read more about the article Format Date and Time to 12-Hour AM/PM in PowerApps Forms
PowerApps Canvas

Format Date and Time to 12-Hour AM/PM in PowerApps Forms

When you use a form control with date and time fields in PowerApps, it automatically generates a data card with a date picker, plus two dropdowns for hour and minute—in 24 hour time. Now, I don’t know about you, but here in the U.S., where we’re used to the 12-hour AM/PM format, it’s kind of surprising that Microsoft hasn’t made this behavior easier to configure! Therefore, I sought to build my own solution to this annoyance by achieving the following goals: Combine the Hour, Minute, and AM/PM format into one single dropdown control. Allow for interval-based time selection…

Comments Off on Format Date and Time to 12-Hour AM/PM in PowerApps Forms
April 18, 2025
Read more about the article Fast and Efficient Pagination in Power Automate
Power Automate

Fast and Efficient Pagination in Power Automate

Pagination is frequently used by APIs to divide large sets of data into manageable "pages." In this post, I’ll show you how to efficiently paginate and collect all the results into an array in Power Automate—without using Apply to Each. I’ll also include a quick performance comparison so you can see the impact for yourself. The difference in speed will surprise you! Use Case: The Office 365 Users Connector I want to use an example where you can try this against your own tenant: the Office 365 Users connector. One of it's actions is the Send an HTTP…

Comments Off on Fast and Efficient Pagination in Power Automate
April 12, 2025
Read more about the article Working with Dataverse Column Data Types using Web API
Dataverse / PowerShell

Working with Dataverse Column Data Types using Web API

This guide covers how to create and update common Dataverse column data types using the Dataverse Web API with PowerShell. While standard types are relatively simple to handle, complex types like Lookup require specific formatting and payload structure to be processed correctly. The Basics I already covered the basic CRUD operations using the Web API so I strongly recommend reviewing this post first. Basically, you'll either be using the methods post for create and patch for update. Then, we will pass the payload containing all the columns we want to create or update. We also need to ensure…

Comments Off on Working with Dataverse Column Data Types using Web API
April 11, 2025
Read more about the article Query Dataverse FAST with FetchXML Builder
Dataverse / PowerShell

Query Dataverse FAST with FetchXML Builder

One of the must-have tools for every Power Platform developer is XRMToolBox. Within it is a tool called FetchXML Builder, which lets us connect to our Dataverse environment, browse and query data easily, and export the results in various formats. Don’t let the name 'FetchXML' fool you—it does much more than just fetch XML! We can also convert the query output to OData (Web API) format for use with our scripts. This post is part of my ongoing series on using the Dataverse Web API with PowerShell. Make sure you have read through my post on Obtaining an…

Comments Off on Query Dataverse FAST with FetchXML Builder
April 6, 2025