5 minute interval with SQL Server

So often I have said, it doesn’t matter where your data lives, but have you ever compared SQL Server with SQL in Azure when you use Power Automate?

SQL Server

Table of Contents

In this post I’m not going to look into how to set up SQL Server or how to get a data gateway set up so that you can get your flows in Power Automate to talk to on-premises SQL Server.

But have you noticed that when you create a flow with the When and item is created (V2) trigger that there can be a delay of 5 minutes for your flow to actually run?

When and item is created (V2) trigger

For many scenarios that might not be good enough.

When you look at your flow runs you might only have a few succeeded runs in the All Run view.

SQL Server

But when you look at the Checks (no new data) view of the flow runs you will find the following.

5 Minute delay when using SQL Server trigger

Your flow will only ever check SQL Server every 5 minutes for new records?

SQL Azure

When you use SQL Azure however your flows will be triggered as expected immediately. So if you have a choice you might want to move your databases to the cloud.

But that might be easier said then done. Once that database lives on those servers on your network you might not be able to just move them across overnight.

So when you look at connecting to from the Power Platform and you know that you want to trigger on the creation of items you might want to consider that 5 minute delay.

By Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: