Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Email Notification using data alerts and Microsoft Flow

Hello All.


Bascially, I have a report in which I am showing list of the employees who received bonus and their details.

Now, I have this requirement where I have to send email notifications to all the employees who received bonus.


For achieving this, I have a card which shows count of employees who received bonus and basically pinned this card to a dasboard and created a data alert on condition (employees with bonus > 0). Then I used Microsoft flow and created a flow where when a power bi data alert is triggerd then I will have an action to send mail to the employees with bonus.


The part where I am stuck is how to make the email recipients dynamic i.e to be able to send mails to only those users who received bonus, say for the next quarter when again this alert is triggered the mails are only sent to user who received bonus in that specific quarter. 

Status: Declined

Hi @dipankar,


I'm afraid there is nothing we can do in the Power BI side. Please go to the Microsoft-Flow-Community for professional support.


Best Regards,


Impactful Individual
Status changed to: Declined