Logic Apps Standard - SQL Service Provider / Built-in trigger do not work

Aubrey Price 5 Reputation points

Further to previous question. Attempted to force recurrence setting on whenARowIsUpdated trigger and received following error:

The template trigger 'When_a_row_is_updated' at line '1' and column '622' is not valid: the 'recurrence' property should not be specified for triggers of type 'ServiceProvider'

Tried every permutation I can think of and SQL Built-In triggers simply do not work

Any help greatly appreciated.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,819 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 67,986 Reputation points

    @Aubrey Price Thanks for reaching out. Your logic app will not get triggered if CHANGE_TRACKING is not enabled on the table as I mentioned here.

    Once the CHANGE_TRACKING is enabled on table and when I perform create any record then the logic app was able to triggered successfully. In case my table does not have CHANGE_TRACKING enabled the logic app will not be triggered.

    enter image description here

    Feel free to get back to me if you need any assistance.

    Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.

    0 comments No comments