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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
Check out the community blog page where you can find valuable learning material from community and product team members!