Forum Discussion
Outage Calendar Subscription
This sounds like you'd need a second SP list for "alerts" that has a form where the user can select the type of alerts they want to get and submit it... then a scheduled cloud Power Automate flow on the first calendar list that triggers on new item added, and then does a "get items" on the alerts list, and for each of the alert records checks if the values match the criteria (condition step) before sending an email.
To integrate the two, you could add a button to the alert signup form to your Power BI report, or potentially embed the form as a Power App (but that would probably be overkill).
This sounds like you'd need a second SP list for "alerts" that has a form where the user can select the type of alerts they want to get and submit it... then a scheduled cloud Power Automate flow on the first calendar list that triggers on new item added, and then does a "get items" on the alerts list, and for each of the alert records checks if the values match the criteria (condition step) before sending an email.
To integrate the two, you could add a button to the alert signup form to your Power BI report, or potentially embed the form as a Power App (but that would probably be overkill).