web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Azure SQL datatable to...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 174

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:
I have the same question (0)
  • SomeoneAwesome Profile Picture
    174 on at

    Bump.

     

    Can someone please help me with this, i just cant seem to solve it and i have spent a considerable amount of time on it

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard