Replacing “Alert Me” for Excel / Word file changes using Power Automate
Yes, you can recreate (and significantly improve) the classic “Alert Me” functionality for Excel spreadsheets and Word documents using Power Automate.
The legacy alerts feature still exists and works as designed, but it was built for individual convenience and doesn’t scale well for modern, collaborative environments. Power Automate is now the preferred and more flexible approach.
Basic solution (equivalent to classic alerts)
For files stored in SharePoint or OneDrive for Business:
Trigger
Use the SharePoint trigger:
When a file is modified (properties only)
This works for:
- Word documents
- Excel spreadsheets
- Any file type in a document library
Using properties only is efficient and avoids downloading the full file.
Optional filtering (reduce noise)
Add conditions such as:
- File name = ImportantTracker.xlsx
- Modified By ≠ service account
- Folder path = specific library
This mirrors (and improves on) “alert me on this document/library”.
Notification
Send notifications via:
- Email
- Microsoft Teams message
- Mobile push notification
Include dynamic details:
- File name
- Modified by
- Modified date
- Direct link to open the file
Example:
“The document SalesForecast.xlsx was updated by John Doe at 10:42 AM.”
Enhancements not possible with classic alerts
Power Automate allows you to go beyond simple change notifications:
- Send alerts only on meaningful changes (e.g., status = Approved)
- Route alerts to Teams channels instead of email
- Exclude frequent auto‑saves or background updates
- Create daily or hourly digests for high‑traffic documents
- Centralize alert logic so it’s visible and governable
Summary
✔ Power Automate can fully replace classic “Alert Me” notifications
✔ Works for Excel and Word documents in Microsoft 365
✔ Offers better filtering, routing, and governance
✔ This is the recommended Microsoft direction going forward
Optional deeper reading (implementation + architecture)
If you’d like more detail, here are two related posts that go deeper into this topic:
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
