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?