111 posts tagged with "SharePoint"

People can log their overtime; this screen shows them what they've logged. It lists a month of their entries with a status badge on each, adds up the month and each Monday-to-Sunday week, moves between months, and lets them correct an entry until it's approved, by opening it on the Log Overtime screen.

A SharePoint view can show a total under a column: select the column's heading, then Totals and a calculation such as Sum. In a grouped view, each group gets its own total, and the list gets one at the bottom. Save the view to keep it.

Grouping puts a list's items under a heading for each value of a column, such as each month, with a count of the items in each group. Select the column's heading and Group by it, then Save view as to keep the grouping. For a second level, such as month and then person, use Edit current view.

Requests should be easy to correct until someone approves them, and fixed after that. In a gallery, give each row an Edit button whose Visible is ThisItem.Status.Value <> "Approved": pending and rejected rows can be opened, approved ones can't. When an edited item is saved, set its status back to Pending, so the change is approved too.

A check for clashes or duplicates that works when adding an item finds the item itself when you edit it. The fix is to skip that item, but SharePoint can't run ID <> x on its ID column, so put it in the query and nothing is delegated. Instead, let SharePoint find the matches with a query it can run, hold them in memory with With, and skip the edited item there.

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.

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.

To save a date to SharePoint with Patch, pass a Date to a date-only column and a DateTime to a date-and-time column, as values, not text. SharePoint then shows exactly what the person chose, as long as the site's time zone is the one they work in. A night shift saved this way showed as 24/10/2026 22:00 to 25/10/2026 06:00.

The app gets its first real screen in this part. The Home screen greets the signed-in person, shows their department and, if they approve overtime, which departments they approve for. Its tiles depend on the person's role: everyone can log overtime, but only approvers, payroll staff and admins see the screens meant for them.

A SharePoint list often names people in a Person column: a department's approvers, a project's owners, a request's reviewers. A canvas app can find the items that include the signed-in person by comparing their email with the column's Email values. With a column that allows several people, it takes one extra step to keep SharePoint's delegation rules happy.