A night shift shown as 22:00 to 06:00 reads as if it ends before it starts. Adding next day when the finish falls on a later day than the shift's date makes it clear: 22:00 to 06:00 next day. The check is Day(EndTime) <> Day(WorkDate) inside an If.
To total each group of records, group them with GroupBy, then add a column with AddColumns whose value is Sum over the group's nested table. Microsoft's own GroupBy reference describes this pattern. Grouping a person's overtime by week gives totals such as 26/10/2026: 6.00 hours.
GroupBy turns a table into one row per value of a column. Each row keeps that value and a nested table of the records that share it. GroupBy(Entries, WeekStart, WeekEntries) gives one row per week, with the week's entries in WeekEntries.
Sum adds up the values of a column: Sum(Table, Column). Wrap the table in Filter to add up only some rows. With a SharePoint list, add up the rows after loading them into a variable, because SharePoint can't do the adding for Power Apps.
To get the SharePoint items between two dates, filter on the date column with >= the first date and <= the last: Filter(List, WorkDate >= FromDate && WorkDate <= ToDate). Both ends are included, and SharePoint can run the comparison itself, so the formula works on lists of any size without a delegation warning.
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.
