Note: This article is part of a tutorial series on using PowerApps, Microsoft Flow, and Power BI with SharePoint Online. Make sure you read the series introduction to get a sense of the big picture, as well as related downloads.
In this task we'll add an alert in Power BI to let us know if pending projects are taking too long to approve, and a flow that responds when that alert occurs. For more information on alerts, see Data alerts in Power BI service.
In the Power BI service, open the dashboard you created in the last task.
On the card with the single number, click or tap the ellipsis (. . .).
Click or tap .
In the right pane, click or tap Add alert rule.
Look at the options that are available for alerts, such as how frequently an alert should run. Enter a value of 25 for Threshold, then click or tap Save and close.
The alert won't fire right now even though 56 is above the threshold of 25. It will fire when data is updated, which we'll see when we run through the scenario end-to-end.
When the alerts fires, Power BI sends email to the creator of the alert, and we'll see how to send additional mail using Microsoft Flow, in the next step.
Sign into flow.microsoft.com, click or tap Services, then Power BI.
Click or tap Send an e-mail to any audience when a Power BI data alert is triggered.
Click or tap Use this template.
If you're not already signed in, sign into Outlook and Power BI, then click or tap Continue.
In the Alert Id drop-down list, select Alert for Max days pending approval.
In the To box, enter a valid email address.
Click or tap Edit to see other fields that you can update.
At the top right of the screen, click Create flow, then Done.
We will see this flow run when we run through the scenario end-to-end. Now we'll move on to the last task in this scenario - embedding a Power BI report into SharePoint.
The next step in this tutorial series is to embed the Power BI project report in SharePoint Online.