cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Adeeba
Level: Powered On

SQL When new record is created

Hello Everyone,

 

I have created a flow, if a record is created in our on - premise SQL Datawarehouse (Not Azure) then an item should be created in the sharepoint list. But the flow isn't working.

 

Whenever there is a new record inserted in the SQL Table, the flow isn't failed but it shows that it skipped in the check runs.

 

Skipped Flow.PNG

 

 

Can we create flows using On - Premise SQL server (via gateway) or it has to be AZURE SQL database only?

 

Also I have SQL Standard 2016 version, do I have to have SQL 2017 version in order for the flow to run?

 

Thanks,

Adeeba

6 REPLIES 6
Super User
Super User

Re: SQL When new record is created

Yes, you can utilize on-premise SQL with Microsoft Flow. To troubleshoot please:

Also, here's an overview of how the connector works:Data-Gateway-Overview.png

Usually when there is an issue with the gateway, there is a configuration or networking issue as the culprit. Like with SQL, the On-premise gateway also has logs you can review while troubleshooting: on-premise-event-logs.png

Microsoft recommends using Fiddler to perform network and proxy traces. If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Adeeba
Level: Powered On

Re: SQL When new record is created

I have tested the flow manually and the test worked absolutely fine, but when I add a new record in SQL table, the flow doesn't run. I assume if the test flow was working then there is no issue with the gateway, because I am able to read the data.

Super User
Super User

Re: SQL When new record is created


@Adeeba wrote:

I have tested the flow and the test works absolutely fine, but when I add a new row, the flow doesn't run.


Again, you likely have a configuration issue with your data gateway and/or SQL connectory. It isn't updating Flow that a change was made to trigger the Flow. 

v-zhos-msft
Level 10

Re: SQL When new record is created

Hi @Adeeba ,

I have made some tests on my side, and it works well.

Capture1.PNG

Could you please share a screenshot of the details of the Run history with the skipped information?

Best Regards,

Community Support Team _ Zhongys

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

Microsoft Cameron
Microsoft

Re: SQL When new record is created

Adeeba, Please paste the schema for your table here. Thanks, -Cameron
Denees
Level: Power Up

Re: SQL When new record is created

Hi,

 

I was able to connect the Flow and SQL Server successfully and the flow runs on the Orders table. However, when I run the Flow it sends an email for the very first order number (record) and not for the newly created orders.

 

ROWID and ORDER NUMBER are two different columns and the identity field is ROWID.

 

Flow.png

 

 

Any idea why it may happen?

 

Thanks in advance.

Denis. 

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,992)