Hi
I am new to Power Automated, and want to know, if it is possible to create a flow that sends an email each time a specific SQL query (e.g. SELECT Col1, Col2 FROM MyTable WHERE Col3 = 'GivenValue') is executed in a database?

Hi
I am new to Power Automated, and want to know, if it is possible to create a flow that sends an email each time a specific SQL query (e.g. SELECT Col1, Col2 FROM MyTable WHERE Col3 = 'GivenValue') is executed in a database?
Yes, it is possible to create a flow in Power Automate that sends an email each time a specific SQL query is executed in a database. However, Power Automate itself cannot directly detect when a specific SQL query is executed in your database. It doesn't have that trigger.
You would need to create a mechanism within your database or application that triggers the Power Automate flow. This could be a stored procedure or a trigger in your database that calls a Power Automate HTTP trigger.