Outage Calendar Subscription

[Mario69]

I've built a Power App that takes values, populates a SP list, and uses those values to interact with the BI visual MaQ software Calendar.  Everything works for this part.  I've been tasked with adding a feature to this project, however.  I need to add a department field to the project that houses (Electrical, Plumbing, Construction, Elevator).  A prospective user should be able to subscribe to the calendar and select whatever department that they'd like to be notified of an outage on.  Notifications are received via email.  I know that I can make different views in SharePoint, but I'm having trouble visualizing how I could incorporate a subscription feature to a specific view for a specific category.

 

[christinepayton · Accepted solution]

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).