Trigger email after a status change within a column

[DRossi]

Hello,

I have a Power BI report that sits within the online service. The dataset is a connection from Salesforce.

I have a column 'Status' which is either 0 or 1. When the status changes from 0 to 1 upon refresh, I want an email to be triggered to the person who logged the job. 

My assumption is a combination of PowerBI and Power Automate but I can only find that I would have to create an alert on a dashboard, but still doesn't really meet the requirement. Any ideas?

Name	Date	Type	Status
John	18/03/21	Job	1

[lbendlin]

I would not use Power BI for that. Pull the report directly into Power Automate via the report API and then process the result there and send the emails as needed.  Or use a proper ETL tool.

[lbendlin]

How are you extracting the SFDC data today? Via the report API, via dataloader, in some other way?

[DRossi]

It's not too complex. I had the owner create the report on SF and then I used the SF report connection on Power BI which pulls that data. This is report on PBI is hosted on a premium node.

[lbendlin]

So your SFDC report has a status column and a user name column?  How are you planning to send the email with that information?

Please provide more details. 

BTW, what license type does your company have for Power Automate?

[DRossi]

Hi @lbendlin 

I have the a unique identifier that comes from SF of the person who raised the lead in the row of data.  I then have built a relationship to another datasource on SP that stored a list of users unique identifier and email address so I would pull from that.

I seen that connection but don't think the business will pay for it.