I connected my SQL server to flow and it seems to be correct.
My flow is very simple. I just want to send an email when an item is created. I have a second flow that sends an email when an item is modified.
For when an item is created:
The problem is that nothing happens with the flow when I perform trigger action and tests don´t do anything. Only when I select the test using SQL data it runs the flow but sends an email with the first entry of the data base.
What could be happening?
Hi @closcher ,
If the connection is created for the first time, the triggering of the flow may not be particularly timely. This also involves the operating status of the gateway and the impact of the network environment.
You can try to update the connection. When testing, make sure you add a new record to the specified table and then observe if there are new records in the Flow run history.
Please wait for some time or refresh the Flow details page and see the results.
Thanks for your response @v-bacao-msft .
When an item is created flow: Test works using SQL server data but again it brings me the first record of the table. I assume the connection is working correctly.
I´m adding records into my application (not directly into SQL) and still nothing happens with the flow.
When an item is modified: nothing happens when I modify items in my application.
Hi @closcher ,
Please try to add record in SQL table directly and check if Flow can be triggered normally.
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!