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?
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,
Hi @powertube
Your flow steps looks good to me. Could you try deleting the trigger step and recreate again.
Thanks
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional