topic Re: Send an email to particular person based on Value in PowerBI report in Developer

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

FilipM — Tue, 13 Jul 2021 10:34:09 GMT

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!

Anonymous — Thu, 15 Jul 2021 07:02:00 GMT

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

Best Regards

giramswa — Thu, 22 Sep 2022 18:06:06 GMT

@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 — Tue, 13 Dec 2022 12:12:06 GMT

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

giramswa — Wed, 14 Dec 2022 09:54:54 GMT

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

PBINL — Wed, 11 Jan 2023 09:07:46 GMT

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