Vladi Gubler
Vladi Gubler
October 25, 2026
Stay in the know
Get helpful videos

SharePoint can remind people before a date arrives, not just report changes after they happen. Date-based alerts in Ultimate Forms key off any date column: three days before the due date, on the expiry date, weekly after the deadline passed, repeating until someone acts. Native SharePoint never offered this, and building it in Power Automate means flows and expressions. Here it is one alert configuration: pick the column, set the timing, add the conditions, choose the message. This guide walks the full setup and the scenarios it unlocks; for the whole notification engine around it, see the complete guide to replacing SharePoint alerts.

Events tell you what happened. Dates tell you what's coming.

The familiar alert is event-driven: a document is added, an item changes, and an email reports it. Useful, but it only ever looks backward.

Date-based alerts look forward. They respond to values in date columns rather than to events: the Due Date approaching, the Contract End arriving, the Certification Expiry already behind. The deadline that nobody edited, and therefore no event-driven system would ever mention, is precisely the one that needed announcing. Every process that runs on dates, and most do, needs this second kind of alert, because its most expensive failures are the quiet ones: nothing happened, and that was the problem.

The third piece is Repeat: notifications that recur at preset intervals until a condition clears, every two days until the Status changes, say. A single reminder is a hope; a repeating one with a stop condition is a mechanism. The nagging stops exactly when the work is done, automatically, because the stop condition reads the data.

The setup, step by step

1. Open Alerts. On the list or library, click the Design button and choose Alerts, or click Add Alert directly on the toolbar:

Design button on toolbar

2. Create the alert. Give it a meaningful title; the current list is pre-selected. To watch a single item or folder rather than the whole list, select it in the view first, then click Add Alert:

General settings

3. Choose recipients and sender. The recipient model takes users, SharePoint and enterprise groups, distribution lists, columns containing users or email addresses, SharePoint lists, and typed external addresses, mixed freely. Two governance details are built in: internal recipients are security-checked, so nobody is alerted about an item they cannot read, and administrators can restrict the sender identity to Authorized Senders only:

Recipients

4. Configure the date trigger. Under What to send, choose "According to date in column", pick the column, and set the relationship: a number of days before, on the date, or after it. The During option offers the ready-made ranges, Today, Tomorrow, This Week, that cover most daily-digest needs without any date arithmetic:

Date-based notification settings

Then the repeat settings: the interval type and size (every 2 days, every week) and how many times to repeat. Paired with a stop condition in the next step, this is the self-silencing reminder.

5. Add conditions. Conditions refine when the alert fires: Status equals Pending and the due date approaching, and nothing else. Conditions accept text, column references, calculations, and functions, so "End Date within 30 days and Status is Active" is a dropdown exercise:

Conditions

The discipline that keeps date alerts trusted: the stop condition is not optional polish. A reminder that keeps firing after the task completed teaches its recipient to ignore the next one, and ignored notifications are a system-level failure, not a user one.

6. Design the message. Dynamic placeholders carry the task name, due date, and owner into the subject and body, so the email answers its own questions; the four rules of effective alert emails apply doubly to reminders, which compete with their own earlier copies for attention. Configure the format inside the alert, or link reusable branded templates shared across the organization.

7. Schedule the delivery. Immediate, daily summary, or weekly digest, and, a courtesy recipients notice, business-hours-only delivery that holds night and weekend triggers for the next business morning. For the digest formats themselves, see change summaries.

Four reminders worth copying

The deadline countdown. Three days before Due Date, to the Assigned To column, repeating daily, stopping when Status is Completed. The classic, and the configuration takes five minutes.

The expiry watch. Thirty days before Certification Expiry or Contract End, to the owner, then weekly after the date passes until renewal is recorded. The pattern behind contract renewal clocks and HR compliance: the probation review, the license renewal, the audit deadline.

The SLA guard. For support teams, an alert as the SLA deadline approaches on open tickets, to the assignee immediately and the team lead on repeat two. Customer satisfaction lives in the gap between this alert existing and not.

The morning docket. The During option's Today range, delivered daily at 8 AM in summary mode: everything due today, one email per person, zero configuration gymnastics. For heavier recurring reporting, timer-based alerts extend the same machinery.

Designing the timing, not just setting it

The mechanics take minutes; the judgment is in the numbers. Lead time should match the action's size: three days suits a task someone finishes in an hour, thirty days suits a renewal that needs negotiation, and a reminder that arrives too early reads as noise while one too late reads as blame. Repeat intervals should widen with distance, daily when the deadline is close, weekly when it has passed into escalation territory, and the recipient should change as urgency grows: the assignee first, the manager only once silence has proven itself. One date column can carry several alerts with different leads and audiences, which is how a single Due Date quietly becomes a complete chasing policy, written once and enforced forever.

Why not Power Automate for this

A date-driven reminder in Power Automate is a recurrence flow that queries the list, filters by date arithmetic expressions, loops the results, and sends per item, with the repeat-until-resolved logic and the stop conditions all hand-built, per list, per scenario. It works, and it is a developer's afternoon followed by a maintenance obligation. The same reminder here is one alert configured from dropdowns by whoever owns the list, which is the difference that decides whether reminders actually get created when a process needs them. The replacement guide carries the full comparison.

Every sent message lands in the central log, so "was the reminder actually sent before the deadline passed" is a lookup, which matters exactly in the compliance scenarios where date alerts live.

Start with the date that hurts

Every team has one date column whose misses cost the most: the contract that renewed unexamined, the certification that lapsed, the SLA that blew. Configure the alert for that column first, with a before-reminder, a repeat, and a stop condition. The build takes minutes; the first caught deadline pays for the attention. Then let the pattern spread to the other date columns, one reminder at a time, until the calendar stops being something people watch and becomes something that watches them. The complete guide to replacing SharePoint alerts maps the rest of the toolkit around these.

Frequently asked questions

Q: Can SharePoint send a reminder before a due date?
A: Not natively, but Ultimate Forms Alerts can: choose "Send according to a value in a Date column," pick the column, and set the timing, such as three days before. Today, Tomorrow, and This Week ranges are built in.
Q: Can the reminder repeat until someone acts?
A: Yes. Repeat settings define the interval and count, and a condition, such as Status not equal to Completed, stops the repetition automatically the moment the work is done.
Q: Who can receive date-based alerts?
A: Users, groups, distribution lists, users or email addresses stored in columns, and typed external addresses. Internal recipients are security-checked against item permissions, and administrators can enforce Authorized Senders.
Q: Can alerts fire only under certain conditions?
A: Yes. Conditions combine column values, calculations, and functions, so the alert targets exactly the items that matter, open items approaching deadline, active contracts nearing expiry.
Q: Can delivery respect business hours?
A: Yes. Alerts triggered at night or over the weekend can be held for the start of the next business day, and delivery can be immediate, daily, or weekly digest.
Q: What are typical uses?
A: Deadline countdowns to assignees, contract and certification expiry watches, SLA guards for support teams, and morning dockets of everything due today, each one alert configured in minutes.
Loading...

Add your comment

Comments are not meant for support. If you experiencing an issue, please open a support request.
Products
Vladi Gubler | October 24, 2026
SharePoint items can carry true electronic signatures: tamper-evident, identity-verified, and bound to the data they sign. The Signature component of Ultimate Forms is a column you add to any list or library, attach to the columns whose values it should protect, and sign in one of three ways, real-time username and password validation against your...
Products
InfoPath reached the end of its road on July 14, 2026, and Ultimate Forms is its natural successor for SharePoint forms: browser-based design instead of a client application, data stored as real SharePoint items instead of XML, all column types supported, and permissions, validation, automation, and printing built in. This comparison walks the two...
Products
Vladi Gubler | April 30, 2025
If you’ve ever used Survey lists in SharePoint, you’re likely familiar with a powerful and often underappreciated feature: the Rating Scale column. This special column type presents a matrix of statements or questions alongside a numeric scale, typically used for gathering structured feedback. The idea is simple but incredibly effective - allow...
Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution
It’s never been easier to create, innovate, and share. All you need is your web browser!
Cost-Effective
Address business process pain points immediately. Save time and money.
Fantastic Support Team
In addition to our responsive support team, a wide variety of resources, documentations, tutorials, blogs and webinars is available to you
Popular Solution Templates
Leave Request
Leave requests with automated day calculation, task tracking, and manager approval — all inside SharePoint
Maintenance Request
Every request logged, assigned, and tracked from first contact to resolution
Employee Accident Report
Workplace accidents documented accurately, consistently, and auditably in SharePoint
Microsoft partner logo
© 2005-2026 Infowise Solutions Ltd. All rights reserved.
Trust Center | Cookie Policy | Cloud SLA