Emailed alerts in Power BI with dynamic email list?

[nrqz]

I have a table in my PBI report like this. The report refreshes multiple times per day:

Order ID	Fulfiller Name	Fulfiller Email	Days Left to Fulfill
1	Bob	Bob@company.com	1
2	Katie	Katie@company.com	3
3	Adam	Adam@company.com	7

I'm trying to setup "smart" emailed alerts that trigger when a row hits 1 day left to fulfill, then sends an email to only the address in that row. In the above example, I would want an alert to go to Bob@company.com so he knows he has an order that needs to be fulfilled very soon. Another reason I'm trying to do this (aside from the obvious ones) is that sometimes the fulfiller for a specific Order ID will change. In other words, manually setting up a bunch of alerts for all the fulfillers just isn't viable.

Is this possible to do in PBI, Power Automate, or MS Fabric? I know it's possible in some ETL tools like Alteryx.

[nilendraFabric]

Hello @nrqz 

Try this with Fabric activator

in your report

Create a filtered table to isolate orders with `Days Left to Fulfill = 1`

Ensure this table includes `Order ID`, `Fulfiller Name`, and `Fulfiller Email`.
Publish the report to a Microsoft Fabric-enabled workspace.

 in fabric activator ,Open the report, select the visual displaying your `Alert_List` table, and click Set Alert > Create Alert.

Define the trigger conditions:Property to monitor: `Days Left to Fulfill`
• Condition: `Equals 1`.

Add dynamic email routing:
map the `Fulfiller Email` field from the `Alert_List` table in recepient
• Customize the email subject/body using dynamic fields as needed

@Thaumaturgist suggestion is a good solution as well for power automate 

[Thaumaturgist]

I recommend Power Automate. Give this article a try:

How to send email from excel using Power automate?