Microsoft Power Apps Canvas Apps, Power Fx Formulas, and Controls
View All Tags
A screen that shows one month at a time needs a way to move between months. Keep the month in a context variable, as its first day; two buttons move it with DateAdd(month, -1, TimeUnit.Months) and DateAdd(month, 1, TimeUnit.Months), and a heading shows it as November 2026. To stop people going past this month, the next button disables itself there.
Text writes a date's day of the week as a name: Text(d, "dddd") is Monday and Text(d, "ddd") is Mon. Put it in front of the date, "ddd dd/mm/yyyy", and a list of dates reads Mon 02/11/2026, so people can see the weekends at a glance.
To show a date as its month and year, format it with Text and the placeholders for the month's name and the year: Text(d, "mmmm yyyy") is November 2026, and Text(d, "mmm yyyy") is Nov 2026.
Power Fx has no EOMONTH function, but the last day of a month is always the day before the first of the next month. Go forward one month from the first, then back one day: DateAdd(DateAdd(first, 1, TimeUnit.Months), -1, TimeUnit.Days). For November 2026 that's 30/11/2026. Date(year, month + 1, 0) gives the same day.
The first day of a month is the date with that month's year and month, and day 1: Date(Year(d), Month(d), 1). With Today() for d, it's the first of this month; on 8 November 2026 that's 01/11/2026.
To find the Monday of the week a date falls in, count how many days the date is after Monday and go back that many. With Weekday numbering Monday as 1, that's Weekday(date, StartOfWeek.Monday) - 1 days, and DateAdd goes back. For Sunday 8 November 2026 the result is Monday 2 November.
Weekday turns a date into the number of its day in the week. By default the week starts on Sunday, so Sunday is 1 and Saturday 7. Add StartOfWeek.Monday and Monday is 1 and Sunday 7, the way a UK week runs.
For a month with no entries, a Power Apps screen showed Total for September 2026: hours, with nothing where the number should be. Sum of a table with no rows returned blank, not 0, and Text turned the blank into empty text. Wrapping the Sum in Coalesce(…, 0) made it read 0.00 hours.
Every row of a Power Apps gallery showed a thin grey scroll bar at the end of its first two lines of text. The two Text controls were 24 pixels high and kept their default padding of 5 at the top and bottom, which left less room than one line of text needs. Setting PaddingTop and PaddingBottom to 0 removed the scroll bars.
This is the screen people use most: they log a shift of overtime. They choose the day it started, the start and finish times, the unpaid break, the department and a reason. The hours are worked out as they choose, correctly across midnight and the nights the clocks change, and Save stays disabled until the entry is complete and doesn't clash with one already logged.
