Power Automate triggered from Power BI alert – automatic order when value below threshold

This article describes how to combine Power BI with Power Automate. We are creating a solution, where:

Power BI checks current values (in our example coffee supply), and when it is below 100, it triggers notification
This notification runs flow in Power Automate, which takes values from Power BI, and based on approves and send an order to supplier

So, how to start?

What to do in Power BI

In Power BI we have to create an Alert. So let´s create a Card visual, pin it to dashboard and set thresholds. Then click to Power Automate.

In Power Automate we will arrange flow like this.

First step is a notification from Power BI. It´s only parameter is a name of an Alert.

Following steps, Approval process, can use info from it – to provide relevant information to an approving person.

Then we need a condition, which sends an order email when approved.