Yeah I found that Grafana doesn’t have the feature set to help with this. Alerting leaves a lot to be desired Create an alert from a bool value - #2 by mattabrams
I ended up just making an AzureDevOps Pipeline that send out an email using PowerShell