Unanswered

SQL When Item Is Created (V2) not triggering

(0) Share

Report

Posted on by SiGoy

One flow stopped triggering when an item in SQL table is created (screenshots below). The error states BadGateway, however when I look at the status of the Gateway it suggests it's online and up to date. No changes made to architecture of SQL table, simply adding rows to it. The flows don't show as failed in the run list either so I can't resubmit.

The error message suggests timeout issue but I have other flows using the exact same gateway AND trigger but are working fine!!

Solutions would be appreciated as I'm lost on this one.

2023-07-20 15_23_17-Manage your flows _ Power Automate and 4 more pages - [InPrivate] - Microsoft E.png 2023-07-20 15_24_45-.png 2023-07-20 15_26_10-Manage your flows _ Power Automate and 4 more pages - [InPrivate] - Microsoft E.png 2023-07-20 15_35_28-Edit your flow _ Power Automate and 4 more pages - [InPrivate] - Microsoft Edge.png

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (1)

Report

Were any rows deleted in the SQL table?

I know that the trigger(s) for the SQL connectors can be very sensitive due to how it tries to keep track of rows in a table.
https://learn.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations-with-triggers

Was this reply helpful? Yes No
SiGoy 3 on at

Like (0)

Report

Thank you for taking the time to read and respond, no items have been deleted from the table, only created.

Was this reply helpful? Yes No