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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Bad Request - Error in...
Power Automate
Unanswered

Bad Request - Error in query syntax (Microsoft Dataverse Add a new row Action)

(0) ShareShare
ReportReport
Posted on by
Hii all, Im having this issue where im getting "Bad Request - Error in query syntax " with an error "code""0x80060888".
My automation is simple where i need to add a new row into a selected environment using Dataverse. I have made sure all my records are being entered in proper format (Having GUIDs retrieved and placed as per their respective metadatas) yet Im still unable to create a record. Can someone help me out with this? Thank you in advance.
 
​​​​​​​
Categories:
I have the same question (0)
  • Suggested answer
    rzaneti Profile Picture
    4,241 Super User 2025 Season 2 on at
    Bad Request - Error in query syntax (Microsoft Dataverse Add a new row Action)
    Hi,
     
    Are you using the set names (plural logical names) in the Lookup columns? For example, if you were referencing a record from Account table, you should use accounts(GUID) as input, with the "s". An alternative to easily identify the correct naming of the related table is to go to the respective table in Dataverse, click in Tools, and then "Copy set name":
     
     
    Let me know if it works for you or if you need any additional help!

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/
    https://www.linkedin.com/in/raphael-haus-zaneti/
  • rzaneti Profile Picture
    4,241 Super User 2025 Season 2 on at
    Bad Request - Error in query syntax (Microsoft Dataverse Add a new row Action)
    Hi,
     
    I just want to confirm if you had a chance to test the solution recommended in my previous message.
     
    If it's working properly and answered your question, please mark it as Accepted Answer, so other users with the same issue can find it easily in the future :)
     
     
    -------------------------------------------------------------------------

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard