Business case: Create the alert message to Slack with MS Flow/Automate

 Business case:

Automatically post the alert message when it hits the criteria by using the store procedure in MS SQL Azure

Solution:

Assumption that we already had the data as following by writing it in the store procedure.

Business case: Monitor mailbox and auto-save the attachment to a SharePoint

Business Case:

- Monitors a shared mailbox for messages that contain the words "expense report"

- Saves the attachment to a SharePoint Library called ExpenseReports

- Marks the email as Read

- Marks the email as Complete 

Solution:

Enter a value for Flow name, and then search the triggers for When a new email arrives in a shared mailbox (V2):

Select SharePoint site

Mark as read

Flag email

Result: