Dynamics 365 "update record (preview)" fails with Bad request error 'PrimitiveValue' node

[Rkaur]

Hi,

I need to update my entity record field attribute with a specific value based on microsoft flow execution results.

flow - there's an approval step and post that based on teh response of teh approver if it was "Approved" one of the custom fields in the entity "Approved By" should show the Approver name.

However, The "Update a record" dynamics conector step fails to update with error -

"An error occurred while validating input parameters: Microsoft.OData.ODataException: A 'PrimitiveValue' node with non null value was found when trying to read the value of the property 'new_ApprovedBy';  however, a 'StartArray' node,  a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.".

screensoht below.

[v-yamao-msft]

Hi @Rkaur,

Could you share more details on the update record action?

I have made a flow to update Approval response to opportunity description field. It is configured likes below:

Please take it for a reference.

Best regards,

Mabel

[Rkaur]

Hi Mabel,

Please see the screen attached.  There are two "Approved By" attributes as shown but in the entity fields there's only one that i created and it is a lookup field for Users in the system.

When i used the second field to set "Approver name" it gave "Primitive node"error but now when i removed it from there and mapped it only to first field ( as part of debugging) it gave 400 error "4.0\r\n\r\n{\"error\":{\"code\":\"0x0\",\"message\":\"')' or ',' expected at position 8 in '(Mathew Hayden)'.\",\"innererror\":{\"message\":\"')' or ',' expected at position 8 in '(Mathew Hayden)'.\",\"type\":\"Microsoft.OData.ODataException\",\"

In the second screenshot, are the error logs where value is captured correctly, the name of the approver and teh error code 400.

What could "',' expected at position 8 in '(Mathew Hayden)' " mean ?

[Rkaur]

found The issue - Approver name contains a space in the value "FirstName LastName' and Microsoft flow is not able to recognize it.

Very strange but if there is a output variable to use"Approver name" in our flow execution then "UPdate a record (preview)"dynamics 365 connector doesnt recognizs the space and fails with error-

{\"message\":\"')' or ',' expected at position 8 in '(Mathew Hayden)'.\",\"type\":\"Microsoft.OData.ODataException\",\"

as it is considring mathew as the terminating string.

when i pass just "Firstname" in it, flow works.

Please provide a solution to passing full name inclusive of first and last name in the update step.

[Rkaur]

ANy update please ?

m blocked on this. please suggest a workaround solution on how to pass "Approver's name from flow to update entity record field attribute

[v-yamao-msft]

Hi @Rkaur,

Thanks for updating.

It seems that a blank between first name and last name cannot be recognized by flow.

Please try to remove the space or replace the space with “%20”.

Here I made a simple replace test using the following code, please take it for a reference:

replace(outputs('Compose'),' ','%20')

 

Best regards,

Mabel

[Rkaur]

Hi Mabel,

eplacing space woud work but finally this update connector has to update a field in record which is a lookup field to user entity. user name is "Mathew Hayden" and the flow will pass "MathewHayden"

CRM would see this as a fied value mismatch and would not map it. 

got the error again different though- 

Entity Name

Expense Reports

Record identifier

bf9def14-85e1-e811-a96b-000d3af2905b

item

{
  "_new_approvalstatus_label": "Approved",
  "new_ApprovedBy": "Mathew%20Hayden",
}

error - Type: application/json; odata.metadata=minimal\r\nOData-Version: 4.0\r\n\r\n{\"error\":{\"code\":\"0x0\",\"message\":\"An error occurred while validating input parameters: Microsoft.OData.ODataException: A 'PrimitiveValue' node with non-null value was found when trying to read the value of the property 'new_ApprovedBy'; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.\\r\\n   at Microsoft.OData.JsonLight.ODataJsonLightPropertyAndValueDeserializer.ValidateExpandedNestedResourceInfoPropertyValue(IJsonReader jsonReader, Nullable`1 isCollection, String propertyName)\\r\\n   ..............................