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

Notifications

Announcements

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

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
    on at

    Hi @MDODD,

     

    Could you please share the detailed configuration of this flow?

     

    Regards,

    Mona

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard