Power Platform Community Forum Thread Details

Hi,

I have a very simple flow which contains the SQL trigger "When an item is created (V2)" and a SQL action "Insert row (V2)"

The connection i am using is my work account, it is the same account i use to modify and perform queries in SQL.

Can anyone shed some light on why i am getting Bad Gateway errors?

I wish for this flow to simply add a new row from one datatable to another. They both have primary keys,

Stucture is as follows (Both tables are the exactly the same)

CREATE TABLE [dbo].[SQLInitial] (

[Title] NVARCHAR (50) NULL,

[HID] NVARCHAR (50) NOT NULL,

[GID] NVARCHAR (50) NOT NULL,

[leID] NVARCHAR (50) NULL,

[Date] NVARCHAR (50) NULL,

[EOSQLID] NVARCHAR (50) NOT NULL,

[SQLID] INT IDENTITY (1, 1) NOT NULL,

CONSTRAINT [PK_SQLInitial] PRIMARY KEY CLUSTERED ([EOSQLID] ASC)

);

Categories:

Azure SQL datatable to Azure SQL datatable on same server and database Bad Gateway