Trigger Email when status changes from Power BI workspace

[v-anabat]

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.

[v-frfei-msft · Accepted solution]

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.

[v-frfei-msft]

Hi @v-anabat ,

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