cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhinaybuiss
Helper I
Helper I

Update a row error: "message": "')' or ',' expected at position...

Hi,

 

Thank you for reading my post.

 

I have a table in Dataverse with primary column PrimaryIdx which is of type Autonumber.

 

I am trying to update that table in a flow and I have passed a string variable with value '2021-04-06-000000037' in the 'Row ID' parameter.

 

The raw input is:

 

{
    "host": {
        "connectionReferenceName": "shared_commondataserviceforapps",
        "operationId": "UpdateRecord"
    },
    "parameters": {
        "entityName": "<somename>",
        "recordId": "2021-04-06-000000037",
        "item/<somecolumn>": <some value>
    }
}

 

 

The step is failing with the following error message:

 

{
  "error": {
    "code": "0x8006088a",
    "message": "')' or ',' expected at position 5 in '(2021-04-06-000000037)'."
  }
}

 

 Am I doing something wrong here?

1 ACCEPTED SOLUTION

Accepted Solutions
abhinaybuiss
Helper I
Helper I

Hi,

 

I was using the wrong column for the value of record id. I fixed it and it worked.

 

With best regards,

Abhinay

View solution in original post

5 REPLIES 5
Johnnyg
Community Support
Community Support

Hello abhinaybuiss,

Could you share more field details on this "recordid field"? Please check below similar issue and whether you recordid share the same situation 
https://powerusers.microsoft.com/t5/General-Power-Automate/Automatically-create-record-in-Dynamics-3... 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
abhinaybuiss
Helper I
Helper I

Hi,

 

I was using the wrong column for the value of record id. I fixed it and it worked.

 

With best regards,

Abhinay

Could you give details on what you mean by wrong column for the value of record id? That way others like myself that are trying to fix a similar error message can replicate your solution. 

dazzerd
Helper I
Helper I

Thanks dataflows works using the actual GUID which I can access, problem is the dataflow updates 1 row at a time... when I need to bulk update 1000+ in one go. Must be some way to update from a spreadsheet then import in bulk.

dazzerd
Helper I
Helper I

hmm ignore wrong post....

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (5,358)