Is there a way to excute Azure function from database trigger

Question

Hi all

There is a custom table in SQL database to store email detail that user want to send. Legacy application insert data to that table will all recipient details. What I need to do is I need to collect those data and need to send to email queue (Another application - not connected to same database). That email queue application will process the email data send and record the failure and successes.

Is there a way to send those email details to Azure function on insert using table level trigger ?

Thanks

Answer 1

Hey
You can use logic app to monitor for the data updates in tables in database
https://microsoft.github.io/AzureTipsAndTricks/blog/blog/tip156.html

You can send email via logic app as well else you can trigger Azure function via logic app :
https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-azure-functions