Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

SQL Insert Row Error: Status 400 incorrect syntax

(0) ShareShare
ReportReport
Posted on by

Please see attached error.  I am inserting just 1 row into a new SQL table with 1 column called "AccountId".

sqlInsertRowError.png

  • MDODD Profile Picture
    MDODD on at
    Re: SQL Insert Row Error: Status 400 incorrect syntax

    Just following up on this issue...


    Thank you!

  • MDODD Profile Picture
    MDODD on at
  • MDODD Profile Picture
    MDODD on at
    Re: SQL Insert Row Error: Status 400 incorrect syntax

    Update:  Please see updated screenshot below.  While I am still getting the Invalid Mashup, the workaround of typing the table manually works now.  I learned that it's case sensitive - earlier, I had xtemp instead of xTemp.

    Config Screenshot: https://microsoft-my.sharepoint.com/personal/madonnam_microsoft_com/_layouts/15/guestaccess.aspx?guestaccesstoken=Xdo59b50o%2fGJf1YnMS8ijgjQ1bwcfomXZppmdK32fIY%3d&docid=2_1fbfcc02e72734b1e9b4b91ab67722b49&rev=1

  • MDODD Profile Picture
    MDODD on at
    Re: SQL Insert Row Error: Status 400 incorrect syntax

    Please see link below.  However, now, I am running into an issue in which the table is not found although the table exists in the server.  Note that when I posted this message, I was getting the same Invalid Mashup Error when loading the table - to get around it, I just selected custom value and typed the table manually.  At that time, the table was found and I was able to select ContextId and save the flow.  

     

    Thank you!

     

    Config Link:  https://microsoft-my.sharepoint.com/personal/madonnam_microsoft_com/_layouts/15/guestaccess.aspx?guestaccesstoken=%2fLyGKtmF%2bLMtLDUj3%2bP5hraddh4wGflNJtFflldR5Zs%3d&docid=2_15d61f59feff44a698ec9654b52c906ee&rev=1

  • v-monli-msft Profile Picture
    v-monli-msft on at
    Re: SQL Insert Row Error: Status 400 incorrect syntax

    Hi @MDODD,

     

    Could you please share the detailed configuration of this flow?

     

    Regards,

    Mona

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics