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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Insert Row Error: ...
Power Automate
Unanswered

SQL Insert Row Error: Status 400 incorrect syntax

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

sqlInsertRowError.png

Categories:
I have the same question (0)
  • v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @MDODD,

     

    Could you please share the detailed configuration of this flow?

     

    Regards,

    Mona

  • MDODD Profile Picture
    Microsoft Employee on at

    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

  • MDODD Profile Picture
    Microsoft Employee on at

    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
    Microsoft Employee on at
  • MDODD Profile Picture
    Microsoft Employee on at

    Just following up on this issue...


    Thank you!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard