Expected behaviour of Logic App SQL Connector trigger when SplitOn limit is reached?

Mark Furseman 0 Reputation points
2024-08-30T14:08:04.85+00:00

This table in the documentation says that:

Note: When concurrency is turned on, the SplitOn limit is reduced to 100 items.

And this page describes how the Split On is disabled if the limit is exceded:

If trigger concurrency is enabled, the Split On limit is significantly reduced. If the number of items exceeds this limit, the Split On capability is disabled.

But what is the expected behaviour of the trigger action in the case of the limit being reached?

The behaviour I expected is that when the limit is exceeded the Logic App still runs, although with a list of items as an input instead of a single item (as would have been generated by no disabled Split On feature).

However, the observed behaviour is the Logic App trigger fails, with an error code of InvalidTemplate. This behaviour makes combining Split On with concurrency unusable.

I can't find any documentation for this scenario. So, what is the expected behaviour and how should a Logic App be coded to support this?

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,087 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ryan Hill 27,771 Reputation points Microsoft Employee
    2024-08-31T01:06:30.17+00:00

    Hi @Mark Furseman

    As noted, when the number of items exceeds the limit, the SplitOn capability gets disabled. So instead of running concurrent, each item should be treated as a separate event and the workflow will execute separately. You could try to configure your trigger so that instances run sequentially, but I don't think that will address the error you're getting.

    The fact you're getting InvalidTemplate error hints to me that there's either a syntax error, invalid property value(s), or something went wrong with an input parameter. The failed run should indicate what caused the InvalidTemplate error to fail.

    If you can't, feel free share the workflow definition of the trigger and I can see if I run into the same issue.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.