Jeremy Neely Text Jeremy

Automation & Integration · Prototype

Email SLA Monitor

Teams nudges when an email waits too long for a reply.

Built for: AME staff who own client-facing mailboxes

Tracked emails with business-minute timers and a Teams alert card (sample data).
Tracked emails with business-minute timers and a Teams alert card (sample data).

The problem

For an MSP, a client email that sits unanswered is a service-quality risk, usually found when the client follows up. Inbox rules cannot tell a real request from a newsletter, or business hours from a weekend.

What I built

I built a Power Automate solution design that tracks real inbound email and counts business minutes until you reply, then alerts you in Teams when the window passes. It went through three versions in one day, ending as a Dataverse blueprint with actionable cards.

How it works

  1. Track each new inbound email and skip the noise.
  2. Pick the reply window from VIP, customer or default rules.
  3. Close open rows when a reply appears in Sent Items.
  4. Add one minute per business minute to every open row.
  5. Post a Teams card at the threshold to snooze or add rules.

Built with

  • Power Automate
  • Outlook connector
  • SharePoint Online lists
  • Dataverse
  • Teams Adaptive Cards
  • Microsoft Graph

More of Jeremy's work