Unanswered

SQL When new record is created

(0) Share

Report

Posted on by Adeeba

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

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Brad_Groux 4,556 on at

Like (0)

Report
Copy link

Link copied!
Yes, you can utilize on-premise SQL with Microsoft Flow. To troubleshoot please:
Review the Known issues and limitations of the SQL Connector and insure that your issue does not exist due to a limitation
Insure that your on-premise gateway is properly installed and configured, including the firewall or proxy, and ports
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!

Was this reply helpful? Yes No
Adeeba 7 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Brad_Groux 4,556 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

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.

Was this reply helpful? Yes No
Cameron Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Adeeba, Please paste the schema for your table here. Thanks, -Cameron

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Any idea why it may happen?

Thanks in advance.
Denis.

Was this reply helpful? Yes No
A8Tony 66 on at

Like (0)

Report
Copy link

Link copied!

Did you ever get an answer to this, or work out how to do it?

I'm very interested as I have many clients with on-premise SQL who wish to take advantage of the benefits of Flow/Automate, but can't without custom connectors.

Was this reply helpful? Yes No