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 Automate - Using Flows
Suggested answer

Dataverse 'Add a new row' action - help with syntax errors

(0) ShareShare
ReportReport
Posted on by 38
Hi PP Community
 
I am creating a flow intended to take a selected MS List item and create a new task in a Planner Premium planner (Project for Web). I understand that to do this, I need to use dataverse actions. I have got everything working successfully except to the final action; 'Add a new row', for which I keep getting the following error: Action 'Add_a_new_row' failed: Bad Request - Error in query syntax.
 
My understanding is that the error is occurring due to syntax errors in the JSON input for the 'add a new row' action, it should maybe not say 'item', but I cannot for the life of me work out how to fix it. Below is the RAW data input for the 'add a new row' action:
 
Any advice on how to get this working will be GREATLY appreciated. 
Thanks in advance, 
Frustrated User
 
 
EDIT - adding additional information:
 
Here is a screenshot of the add a new row action. I removed dynamic content from non-required fields to try and get the flow working and still get the same error. 
The formulas used in my compose actions are as follows:
Compose - Project and raw input & output: 
 
Compose - Bucket and raw input & output: 
 
Compose - title and raw input & output: 
 
 
 
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    50,151 Super User 2025 Season 2 on at
    Dataverse 'Add a new row' action - help with syntax errors
     
    Can you please share the Action itself, with the configuration, then let's look at the run, and look at the RAW data inputs please
     
  • eellis1 Profile Picture
    38 on at
    Dataverse 'Add a new row' action - help with syntax errors
    Thanks @Michael E. Gernaey, I have added additional information to my post. Any advice on how to get the flow working would be amazing.
  • Suggested answer
    Vejai SH Profile Picture
    437 on at
    Dataverse 'Add a new row' action - help with syntax errors
     
    Make sure you are getting the correct logical name for that entity.
     
    In your lookup, you should not have quote against guid
    eg:  "item/new_AccountName@odata.bind""/accounts(xxxxxxxx-xxxx-xxxx-xxx-6045bd0c6bf7)",
     
    Thanks, 
    Vejai SH  
     
    Please mark as answer if my suggestion helps you
  • Michael E. Gernaey Profile Picture
    50,151 Super User 2025 Season 2 on at
    Dataverse 'Add a new row' action - help with syntax errors
     
    Yes, with the new information provided, you shouldn't use quotes around the GUID as its not a string
  • eellis1 Profile Picture
    38 on at
    Dataverse 'Add a new row' action - help with syntax errors
     
    Thank you both for your advice. The JSON code is the raw input for the 'add a new row' action from the failed flow run - it's not code I have written or can edit (it's not editable). Would this mean there's actually something not working properly with the 'add a new row' action? or is there another way I can achieve what I need?
  • Vejai SH Profile Picture
    437 on at
    Dataverse 'Add a new row' action - help with syntax errors
     
    Issue is not with 'Add a new row' issue is with your compose action.
     
    Try changing your compose action like this
     
     
    Thanks, 
    Vejai SH  
     
    Please mark as answer if my suggestion helps 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 714 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 519 Moderator

#3
chiaraalina Profile Picture

chiaraalina 317

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow