Forum Discussion
need help creating alerts
Hey everyone,
stuck trying to wrap this around my head. have a report with two data sources. relationship between the two is a common column "partner"
in one data source i have "team name", "partner" columns
In the other i have multiple columns but also "partner" and "software build"
what i'm trying to do is create an alert that will email a team if their software build number is below a certain value.
two issues: the software build is a text value. not a number "8.0.3-build-24567" for example. So thats my first issue as i understand it, i need it to be a number, not text.
second: i can't wrap my head around as to how i would write the conditions for this to trigger the email alerts. If team 1 has old build numbers, i only want to email team 1, not everyone. and that would apply to all 4 teams.
Any help would be appreciated:)
3 Replies
It will be much easier to do this in Power Automate where you can schedule DAX queries against semantic models. Surely you don't need this to be real time, once a day is likely enough.
Where should the alert go? Into an email? Data Activator? Something else?
I'm looking for email alerts.
power automate to schedule dax queries... any examples or reference material on that topic?
