cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Flow with SQL only works on test

Hi, 

 

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?flow test.PNG

 

Thanks!

 

3 REPLIES 3
Community Support
Community Support

 

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.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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. 

SQL test.PNGItem created.PNG

When an item is modified: nothing happens when I modify items in my application. 

 

Thanks. 

 

Hi @closcher ,

 

Please try to add record in SQL table directly and check if Flow can be triggered normally.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (34,683)