PowerApps Canvas

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…

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…