Send mail (v2) when new entry in sql table is created only works in test mode

Like (0) Share

Report

Posted on 4 Feb 2020 10:59:28 by powertube

Hey Guys,

I'm taking my first steps with power automate.

What I want to do is to send a mail when a new entry in a sql table (dynamics nav on prem) is created.

I created the connection to the sql database like this:

But the flow doesn't work.
When I go to edit -> test -> with data from sql -> the flow works and I get the mail

What is the problem?

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on 05 Feb 2020 at 06:02:18

Like (0)

Report

Re: Send mail (v2) when new entry in sql table is created only works in test mode

Hi @powertube ,

First, make sure the trigger you use is When an item is created (V2) and not When an item is modified (V2).

In addition, Flow may be triggered later. When you test, you can wait for a few minutes and see if Flow is executed normally.

If the connection is created for the first time, there may be a delay.

Best Regards,
abm abm 32,464 Most Valuable Professional on 04 Feb 2020 at 11:16:48

Like (0)

Report

Re: Send mail (v2) when new entry in sql table is created only works in test mode

Hi @powertube

Your flow steps looks good to me. Could you try deleting the trigger step and recreate again.

Thanks