Power Platform Community Forum Thread Details

Hello,

I would like to know how can I send an email depending on a PowerBi table filtered by some rules.
For example here is my powerbi table visual:

Country	Rule1
France	OK
Spain	OK
China	KO

My goal is to get the variable "Country" from PowerBI if the Rule1 is "OK", and then to create a condition like:
If [Country] = France, send email to {Person1,Person2...}
Else if [Country] = Spain, send email to {Person3...}
...

Here it would send emails to people linked to France and Spain only, not China as it is set as "KO"
I already know how to send emails to people from an Excel table, but my goal is to only send email to people that are concerned to the Rule1 from Powerbi.

Thank you for your help !