Get an alert when a file doesn't arrive in SharePoint by 8:00
Every weekday a partner, an export or another team drops a file into SharePoint or OneDrive, and your process starts at 8:00. When the file isn't there, you want to know at 8:00, not when someone asks why the report is empty. SharePoint can't tell you about a file that isn't there, but a deadline check can.
Why SharePoint only tells you when something happens
Everything built into SharePoint and OneDrive reacts to an event: a file was created, changed or deleted. Power Automate's SharePoint and OneDrive triggers work the same way. A file that doesn't arrive creates no event, so nothing fires.
The classic SharePoint Alert me feature is gone as well: Microsoft retired SharePoint Alerts in steps: new alerts were turned off for all tenants starting in January 2026, and existing alerts stopped working in July 2026. Microsoft points to Power Automate and SharePoint rules instead, which are also event-driven.
The answer forum threads arrive at, year after year, is a scheduled flow: a Recurrence trigger at 8:00 lists the folder's files, filters on today's date, and sends an email when the list is empty. It works, but each folder needs its own flow, the date filter is easy to get wrong (filtering on the uploader instead of the date is a known trap), and the flow's own failures go to whoever owns it.
Watch the file with TaskBeacon
TaskBeacon's SharePoint / OneDrive integration reads only a file's name, size and modification time through Microsoft Graph, never its contents. You add a file to watch and choose a rule:
- New file by a time, for example by 08:00 on weekdays: OK when the file was modified since the previous deadline, Missed after 08:00 otherwise.
- Updated at least every N hours, for a file that is overwritten during the day.
- File name with today's date:
sales_{yyyy}-{MM}-{dd}.csvlooks for today's file in your time zone;*matches anything. - At least … KB: a smaller file is Odd data, which catches an export with only a header line.
No code runs on your side. An administrator creates an app registration and grants it read access to the one site (with Sites.Selected, the least access), and you paste its IDs into TaskBeacon. The SharePoint page in the Docs has each step. Integrations are part of Pro, open to everyone for now, and this one is marked beta: not yet run on a real installation — tell us how it went.
What you get
- An alert at the deadline when today's file isn't there, by email, Slack, Teams or a webhook, to everyone who depends on it.
- An Odd data alert when the file arrived but is suspiciously small.
- A history of when the file arrived each day, so "the partner is always late on Mondays" becomes visible.
If the file is then processed by a script of yours, give that script a job too, so you also hear when the processing fails or loads no rows; see 0 rows or far fewer than usual and data freshness checks.
Without TaskBeacon
Build the scheduled flow in Power Automate: a Recurrence trigger at the deadline on weekdays, Get files (properties only) on the folder with a filter on Created or Modified being today, and a condition that sends an email or a Teams message when the result is empty. Use the date in your time zone, and test it on a day with a file and a day without one. Add a size check in the same flow if empty files are a risk.
Connected Claude or ChatGPT to TaskBeacon? Ask it "what failed last night, and why?" and it answers from your jobs. How that works.
Related
In the Docs: SharePoint / OneDrive files · Integrations · Alerts.
- Power BI refresh failure notifications for the whole teamFailure emails only, only for scheduled refreshes, only inside your tenant.
- Check that a daily table or file is freshA load that "works" but brings yesterday's data again.
- Find out when a scheduled job didn't run at allA run that never happened leaves no error to alert on.
TaskBeacon is free to start, with every feature open for now and no credit card. Create a job, paste the code, and the first ping shows up on the job page.
Start free View live demoSources
- Microsoft Support: SharePoint Alerts retirement (timeline to July 2026) (undated, © 2026; checked 2026-11-09)
- Message center MC1072889 (mirror): SharePoint alerts fully off from July 2026 (reminder dated 2026-06-15)
- Microsoft Learn: Microsoft Graph, get a driveItem (name, size, lastModifiedDateTime) (updated 2025-11-25)
- Fabric Community: Power Automate flow to send emails when no files were uploaded today (about 2025 (estimated))
Page checked against its sources on 2026-11-09. Menus and limits of other products change; if something here no longer matches, write to support@taskbeacon.io.