Trigger a logic app with an item being added to sql

Question

I cannot seem to get my logic app to work when i use the trigger - "when an item is created" in SQL. I know that there are consistently items added to this table, but the trigger always seems to fail. Any thoughts ?

]1

Answer 1

@Zack Widdoss The Select Query parameter here is an OData Select Query, not a SQL Query. So, just order_number_id in your case.

You can refer the reference doc for the trigger for more information.