Alerts based on date value

[Sachy123]

Is possible to recieve alerts based on an event today? E.g if I have a holiday calendar and I get an alert one day before that tommorow is a holiday? And I want to use this as a background service.

E.g if HolidayCalendar[Date] == Today () then <Trigger an email>

[lbendlin · Accepted solution]

You may want to look into Power Automate for that.  What alerts are you referring to - KPI, dashboard, something else?

[lbendlin · Accepted solution]

You may want to look into Power Automate for that.  What alerts are you referring to - KPI, dashboard, something else?

[Sachy123 · Accepted solution]

@lbendlin  Yes I looked into Power Automate and found the solution.