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.
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?
Yes, you can utilize on-premise SQL with Microsoft Flow. To troubleshoot please:
Also, here's an overview of how the connector works:
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:
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!
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.
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.
Hi @Adeeba ,
I have made some tests on my side, and it works well.
Could you please share a screenshot of the details of the Run history with the skipped information?
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.
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.
Any idea why it may happen?
Thanks in advance.
Join us for the first ever Power Platform Online Conference!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!