SQL Trigger not populating with Table in Logic App

Introduction

In SQL triggered Azure Logic Apps that you might have faced the issue of not being able to select your table in the dropdown. Also, if you enter the table name using the Custom Text option, you notice the Logic App is not being triggered as expected. Let us see what the issue is and how to solve it.

Problem

There are two SQL Triggers as follows in Azure Logic App at the moment:

1. When an item is created trigger (V2)
2. When an item is modified trigger (V2)

You do not find your tables in the dropdown because the “When an item is created trigger (V2)” requires IDENTITY column and “When an item is modified trigger (V2)” requires ROWVERSION (TIMESTAMP) column.

Solution

Please verify below in your tables:

1. The table must have an IDENTITY column for the When an item is created trigger (V2)
2. The table must have a ROWVERSION (a.k.a. TIMESTAMP) column for the When an item is modified trigger (V2).

Try to create a new table with these added columns and recreate the API connection again in your logic app and verify if you are able to see the tables in the dropdown.