Blog Archive
Every post on Dewiride Developer Blogs, newest first. Pick a year or a month to narrow it down, or page through them all.
- Posts
- 1,085
- Topics
- 132
- Reading time
- 130 h
- First post
- Jun 2025
Posts 241–270 of 1,085 · November 8, 2026
Page 9 of 37
November 2026
802 postsSunday, November 8, 2026
30 of 55 posts
How to Show the Month Name and Year in Power Apps
Show a date as November 2026 or Nov 2026 in Power Apps with Text and the mmmm yyyy or mmm yyyy format. Live results from Studio, the language the month name follows, and a month heading that changes with previous and next buttons.
4 min readHow to Get the Last Day of the Month in Power Apps
Power Apps has no EOMONTH, but the last day of a month is one day before the first of the next: DateAdd forward a month, then back a day. Or use Date with day 0. Live results for November 2026 and February 2028 in Studio.
5 min readHow to Get the First Day of the Month in Power Apps
Get the first day of the current month, or of any date's month, in Power Apps with Date(Year(d), Month(d), 1). Live results from Studio, and how a timesheet app keeps the month it shows as its first day.
5 min readHow to Find the Monday of a Week in Power Apps
Find the Monday of any date's week in Power Apps: go back Weekday(date, StartOfWeek.Monday) - 1 days with DateAdd. Live results for a Sunday and a Monday in Studio, and a MondayOf function in App.Formulas that a timesheet app uses for its weekly totals.
5 min readHow to Get the Day of the Week in Power Apps with Weekday
Weekday returns the day of the week as a number in Power Apps. By default Sunday is 1; with StartOfWeek.Monday, Monday is 1 and Sunday is 7. Live results from Studio for Sunday 8 November 2026, and how a timesheet app uses it to find each week's Monday.
4 min readFixed: Sum Returns Blank Instead of 0 for an Empty Table in Power Apps
A Power Apps screen showed Total for September 2026: hours, with no number, for a month with no entries. Sum of a table with no rows returned blank, and Text turned it into empty text. Coalesce(Sum(…), 0) makes it 0.00.
7 min readFixed: Scroll Bar Appears Inside a Text Control in Power Apps
A thin grey scroll bar appeared at the end of two Text controls in every row of a Power Apps gallery. Each was 24 pixels high with the default padding of 5 at the top and bottom, leaving less room than one line of text needs. Padding of 0 fixed it.
7 min readBuild an Overtime Timesheet App in Power Apps — Part 6: Build the Log Overtime Screen
Build the Log Overtime screen: a UK date picker, searchable start and finish times, an unpaid break, hours worked out live across midnight and clock changes, checks for overlaps and unfinished shifts, and a Patch that saves each shift to SharePoint.
29 min readHow to Save a Date and Time to a SharePoint List with Patch in Power Apps
Patch a Date into a SharePoint date-only column and a DateTime into a date-and-time column, and the list shows exactly what people chose when the site's time zone is theirs. A night shift saved live as 24/10/2026 22:00 to 25/10/2026 06:00, with the month as text.
7 min readHow to Stop a Button Being Selected Twice While It Saves in Power Apps
A save to SharePoint takes a moment, and a second tap in that moment runs the formula again. Set a context variable first in OnSelect, disable the button and show Saving... while it's true, and clear it on success, on error and when the screen opens.
7 min readHow to Validate a Form Without an Edit Form in Power Apps
Separate input controls saved with Patch get no built-in validation. Put the rules in one function that returns the first problem, show it in a live-region label, and disable Save until every field is filled and nothing is wrong. Live from a timesheet app.
10 min readHow to Check for Overlapping Times in Power Apps
Two time ranges overlap when each starts before the other ends. One LookUp on a SharePoint list, StartTime < new end && EndTime > new start, finds a clashing entry, and blank means the time is free. Live results, the message, delegation and the index.
8 min readHow to Create a User-Defined Function in Power Apps
Write a function once in App.Formulas, with typed parameters and a return type, and call it from any control like a built-in function. Live in Studio: four shift-time functions, the setting that turns them on, and a call that returns 540 minutes.
8 min readHow to Convert Minutes to Hours and Minutes in Power Apps
Show 450 minutes as 7 h 30 min in Power Apps with RoundDown for the hours and Mod for the minutes, or as 7.50 decimal hours with Text and the 0.00 format. Live results from Studio, and the hours line of a timesheet app that shows both.
6 min readHow to Round a Number in Power Apps with Round, RoundDown and RoundUp
Round, RoundDown and RoundUp round a number to the decimal places you choose in Power Apps. Live results: 445 minutes is 7.42 hours with Round, and 450 minutes is 7 whole hours with RoundDown or 8 with RoundUp. Which one a timesheet uses where.
5 min readHow to Get the Remainder of a Division in Power Apps with Mod
Mod returns what's left after a division in Power Apps: Mod(450, 60) is 30, the minutes left over when 450 minutes is split into whole hours. A live result from Studio, the sign rule for negative numbers, and two uses in a timesheet app.
4 min readHow to Convert Local Time to UTC in Power Apps with TimeZoneOffset
TimeZoneOffset returns the minutes between the user's local time and UTC at a given moment: 0 in London in November, -60 in July. Add it with DateAdd to turn 09:00 on 1 July into 08:00 UTC. Live results from Studio, the sign, and the date to pass.
7 min readHow to Calculate Hours Across a Daylight Saving Time Change in Power Apps
On the night UK clocks go back, 22:00 to 06:00 is nine real hours, not eight. Build the start and finish with DateTime and count minutes with DateDiff, and Power Apps counts the real time: 540 minutes in October, 420 in March. Proof with TimeZoneOffset, live in a timesheet.
7 min readHow to Calculate Hours for an Overnight Shift in Power Apps
A shift from 22:00 to 06:00 finishes the next day. Put the finish time on the next day when it's earlier than the start, build both moments with DateTime, and count the minutes with DateDiff: 480, or 7 hours after an hour's break. Live results from a Power Apps timesheet.
6 min readHow to Calculate the Minutes Between Two Times in Power Apps with DateDiff
DateDiff returns a whole number of units between two dates or times, so 17:00 to 20:30 is 3 hours but 210 minutes. Count minutes with TimeUnit.Minutes and divide by 60 for hours such as 3.5. Live results from Studio, and the start-then-end order.
5 min readHow to Add Days or Minutes to a Date in Power Apps with DateAdd
DateAdd adds days, hours, minutes or other units to a date or date and time in Power Apps, and subtracts them with a negative number. Live results for adding one day and 450 minutes, the units it accepts, and how a timesheet uses it for the next day.
4 min readHow to Combine a Date and a Time in Power Apps with DateTime
Combine a date from a date picker and a time from a time picker into one date and time in Power Apps: DateTime(Year(d), Month(d), Day(d), Hour(t), Minute(t), 0). Live results from Studio, and why Microsoft advises against adding dates and times directly.
6 min readHow to Get the Hour and Minute of a Time in Power Apps
Hour and Minute return the parts of a time in Power Apps as numbers: 22 and 30 for 22:30, with Hour always on the 24-hour clock. See both live in Studio, and how a timesheet uses them to put a chosen time onto a date.
4 min readHow to Get the Year, Month and Day of a Date in Power Apps
Year, Month and Day return the parts of a date as numbers in Power Apps: 2026, 11 and 8 for 8 November 2026. See each one live on a date picker's SelectedDate, what they're for, and when Text is the better choice.
4 min readHow to Add a Number Input in Power Apps
Add the modern Number input to a canvas app for numbers such as a break in minutes: set Min, Max, Step and Precision, give it an accessible label, and read Value. A live test shows Value updates when the person leaves the box, not on every keystroke.
5 min readHow to Let Users Pick a Time in Power Apps
Power Apps' modern controls have a date picker but no time picker. A modern combo box listing every time of day, five minutes apart, works as one: show the times as hh:mm, allow one choice, type 22 to narrow the list, and read the Time from Selected.
7 min readHow to Build a Table in Power Apps with ForAll
ForAll runs a formula for every record of a table and returns a new table of the results. With Sequence, it turns 288 numbers into every time of day, five minutes apart, as a named formula. Live results from Studio, and what ForAll can't do.
6 min readHow to Create a List of Numbers in Power Apps with Sequence
Power Apps' Sequence function makes a single-column table of numbers: Sequence(5) is 1 to 5, and Sequence(288, 0, 5) is every five minutes of a day. Its syntax, three live results from Studio, and the 50,000-record limit.
5 min readHow to Stop Users Picking a Future Date in a Power Apps Date Picker
Set the modern Power Apps date picker's EndDate to Today() and the calendar greys out every day after today, so people can't pick a future date. See the result live, and why the app should still check the date when it saves.
5 min readHow to Show Dates as dd/mm/yyyy in a Power Apps Date Picker
Make the modern Power Apps date picker show day-first UK dates such as 08/11/2026 for everyone: set Format to a dd/mm/yyyy pattern instead of a built-in format that follows the app's language, and start the calendar's weeks on Monday.
6 min read