Flow with SQL only works on test

(0) Share

Report

Posted on by closcher

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!

Categories:

Using connectors

All responses (3)

Answers (0)

Sort by

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,
closcher 20 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Thanks.
v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @closcher ,

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

Best Regards,