cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
v-anabat Frequent Visitor
Frequent Visitor

Trigger Email when status changes from Power BI workspace

Hi, I have a scenario where I would like to trigger an email to Project owner whenver the status of the project onboarding status changes to completed. Is it possible to achieve this from Power BI workpsace and Flows combining. I have come across few posts like we can trigger an email when sales reaches to threshold or any application reaches to expiry date. But here it is limited to certain kind of visuals like Card or Guage. But in my case I can have more than 1 project which can change it's status to complete whenever data refresh happens, also I have to look up for the owner of the project when the status changes and send email to that owner, so that they can take appropriate actions later.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Trigger Email when status changes from Power BI workspace

Hi @v-anabat ,

 

As the online document. 

 

  • Alerts are currently not supported for Bing tiles, or card tiles with date/time measures.
  • Alerts only work with numeric data types.

Here we can create a measure of a project to work around using SWITCH FUNCTION.

 

STATUS = SWITCH(TRUE(),[status]="on time",1,0)

Then we can set alert based on the measure.

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Trigger Email when status changes from Power BI workspace

Hi @v-anabat ,

 

As the online document. 

 

  • Alerts are currently not supported for Bing tiles, or card tiles with date/time measures.
  • Alerts only work with numeric data types.

Here we can create a measure of a project to work around using SWITCH FUNCTION.

 

STATUS = SWITCH(TRUE(),[status]="on time",1,0)

Then we can set alert based on the measure.

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Trigger Email when status changes from Power BI workspace

Hi @v-anabat ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.