Are there any known issues at present with SQL?
I have a flow that fires on item created in a table but it just doesnt want to work.
The table has 21000 rows currently.
Gateway reports connected.
Ive also just tried on a new table and it also doesnt want to fire.
Do you use On-premises SQL Server connector?
Recently, SQL Server trigger is only supported for SQL Server in Azure. SQL Server trigger is not supported for On-premises SQL Server.
More known issues and limits of SQL Connector, please check the following document:
I have managed to devise a workaround for my scenario, you may be able to implement depending on what you need. (this is for new items created but it could be modified to allow for modified items aswell)
1: Create a list (a) within sharepoint and add a column, type number to store a temporary ID
2: create a row in this list and put the ID -1 of the SQL table in where you want to start processing from, lets say for instance we set as 0 it will start at ID 1
2: Create a list (b) within sharepoint and add 2 columns, 1 as date only, 1 as yes/no (default as No)
3: Create a flow on a daily recurrence at your business start time and set it to create a row in your list (b) with the current date
4: Create a flow on a daily recurrence at your business close time and set it to update the row in your list (b) that is filtered by the current date and set the Yes/No column to Yes
5a: Create a flow, triggered on new item created in list (b), add a do until loop and set it to terminate when Yes/No column equals true
5b: In your do until loop: Add get row from list (a) rowID=1 (as there is only 1 row in this table use the ID for that row which should be 1 unless you made a mistake and deleted a row etc), this will get the current ID which we set as 0
5c:Add a get rows from your sql table filtered on the field containing our current ID (Dynamic content from get row of list (a)), set this to top count 1 ie in the filter query put: ID gt DynamicfiledName
5d: Add a compose action and in expression add length(body('Get_rows')?['value']) (ensuring you change Get_rows to the name of your get rows action)
5e: Add a condition to check whether there are any more IDs - use the output from 5d and set is equal to 0
5f: Under if Yes add a delay and set to say 10 minutes
5g: Under if No Add a compose action so that we dont end up with an array and under expression paste:
It should work on azure, but it needs an IDENTITY column, this is only described in known issues,
A pity that there is no indication when designing the flow, you wait for ever before spending yout ime on internet wordering why
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!