CATEGORY
Power Apps
Power Apps looks intimidating from the outside, but once you get going it is a friendly, fast way to build real applications with very little code. This area is full of my step-by-step tutorials for creating canvas apps that run happily on mobile, desktop, and the web. I cover the foundations, like how to assign values to variables and auto-layout your elements, then move into the practical fixes that save your sanity, such as how to fix the delegation warning and which delegable functions you can safely rely on. There are design touches too, including alternate row colors to make your galleries readable, and real-world logic like calculating overtime for a timesheet app. Because Power Apps rarely works alone, I show you how to provide parameters from Power Apps to Power Automate. Even the quirks get their moment, like the reminder that 1900 is not a leap year.
Power Apps: Calculate Overtime
Power Apps: DateDiff Function
Returns the difference between two dates in days, hours, months, or other units.
Power Apps: Today Function
Returns today's date with time set to midnight. Volatile.
Power Apps: Mod Function
Returns the remainder of a division.
Power Apps: Now Function
Returns the current date and time. Volatile.
Power Apps: Round Function
Rounds a number to a given decimal place using half-round-up.
Power Apps: RoundUp Function
Rounds a number up to the next higher decimal place.
Power Apps: No more magic numbers
Power Apps: RoundDown Function
Rounds a number down to the next lower decimal place.
Power Apps: Text Function
Converts a value to formatted text. Numbers, dates, and currencies supported.
