Forum Discussion
Email trigger based on refreshed data
Hi, I'm not sure if I'm in the right place for a Power Automate/email trigger question.
I have Salesforce linked to a PowerBi report, the report is on a daily refresh which has information about student accommodation. I need to set up an email alert from PowerBi (Not Salesforce) to send the CEO when there's an altercation in one of our locations. So in the example, the CEO would get an email on the 13th April refresh saying something like:
"There has been an altercation today (13/04/2025) in Newcastle involving Jason and Matt."
Is it possible to have a triggered email from what the tabled data reflects in a refresh?
| Name | Date | Altercation | Location | Involving |
| Dave | 10/04/2025 | No | Manchester | Paul |
| John | 11/04/2025 | No | Edinburgh | Lloyd |
| Mary | 12/04/2025 | No | Bristol | Rhys |
| Jason | 13/04/2025 | Yes | Newcastle | Matt |
Thanks
Rich
RichOB , You can try to create flow
Create a Power Automate Flow:
Go to Power Automate and create a new flow.
Choose the trigger "When a data-driven alert is triggered" from Power BI.
Set Up the Power BI Alert:In Power BI, create a data alert on the specific visual or data point that indicates an altercation.
For example, you can set an alert on a measure that counts the number of altercations and triggers when this count is greater than 0.
Configure the Flow:In the flow, after the trigger, add an action to "Get rows" from the Power BI dataset.
Filter the rows to get the specific data where Altercation is Yes.
Send an Email:Add an action to send an email (e.g., using Office 365 Outlook).
Configure the email body to include the details from the filtered data, such as the date, location, and individuals involved
4 Replies
RichOB , You can try to create flow
Create a Power Automate Flow:
Go to Power Automate and create a new flow.
Choose the trigger "When a data-driven alert is triggered" from Power BI.
Set Up the Power BI Alert:In Power BI, create a data alert on the specific visual or data point that indicates an altercation.
For example, you can set an alert on a measure that counts the number of altercations and triggers when this count is greater than 0.
Configure the Flow:In the flow, after the trigger, add an action to "Get rows" from the Power BI dataset.
Filter the rows to get the specific data where Altercation is Yes.
Send an Email:Add an action to send an email (e.g., using Office 365 Outlook).
Configure the email body to include the details from the filtered data, such as the date, location, and individuals involvedHi RichOB,
I wanted to check if you had the opportunity to review the information provided by bhanu_gautam. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi RichOB,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi RichOB,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
