Skip to main content

November 2026

Every post published in November 2026, newest first. Pick a day to jump straight to it.

Posts
802
Topics
75
Reading time
91 h
Active days
15

Posts 241–270 of 802 · November 8, 2026

Page 9 of 27

Sunday, November 8, 2026

30 of 55 posts

  1. 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.

  2. How 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.

  3. How 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.

  4. How 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. How 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.

  6. Fixed: 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. Fixed: 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.

  8. Build 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.

  9. How 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.

  10. How 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.

  11. How 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.

  12. How 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.

  13. How 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.

  14. How 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.

  15. How 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.

  16. How 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.

  17. How 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.

  18. How 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.

  19. How 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.

  20. How 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.

  21. How 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.

  22. How 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.

  23. How 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.

  24. How 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.

  25. How 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.

  26. How 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.

  27. How 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.

  28. How 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.

  29. How 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.

  30. How 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.