Showing results for 
Search instead for 
Did you mean: 
Continued Contributor
Continued Contributor

Trigger automated email to table contacts based on conditional criteria

I'm pretty new with Automate, I need to trigger an email to be sent to a list of people that can be found on a SQL table. The people on that table that will be added to the email will depend on certain criteria.


The email also needs to be triggered by looking at another SQL table, when a certain record breaches a certain date threshold, it should trigger the email to the people relevant to that threshold.


There's a correlation between the Records table and the People's List table. 


I have no idea where to start at all...can anyone guide me in the right direction?


Is this easily achievable or is it quite complex power automate stuff?


Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,487)