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

[abhinaybuiss]

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?

[Johnnyg]

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... 

[abhinaybuiss · Accepted solution]

Hi,

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

With best regards,

Abhinay

[G0Springs]

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]

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]

hmm ignore wrong post....