Send an email to particular person based on Value in PowerBI report

[FilipM]

Hello everyone,

I have recently joined you, and I am very pleased how you are working here and solving the challenges..

I have a challenge to trigger Outlook mail from PowerBI report..

I have report, and one page is like a table, and I need to send email to person from one column if value in other column is <= 5.

You can take a look on the picture that I attached.

All persons from this report are inside our organizations, and their email addresses are in the powerquery within this report.

Thank you in advance!

[giramswa]

@FilipM Can you please share details about how you resolved this issue? I have exactly same requirement.

How did you get Power BI to trigger alert by looking at each row in table for one particular column?

[Anonymous]

Hi, Have you found solution for this. If so can you please share

[giramswa]

I created a Power Automate flow as following and the outcome is exactly what the question is asked here:

[PBINL]

Hi @giramswa,

That looks good! Would it possible to share the details of the steps: Select, Create HTML Table and Compose?

[v-yiruan-msft · Accepted solution]

Hi @FilipM ,

You can refer the content in the following links to achieve it by using Power BI alerts and Microsoft Flow:

Email Alerts on Power BI Dashboards with Microsoft Flow – Better Together

Conditions within "Send E-Mail - To" field

Best Regards