Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

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



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.

update record step.PNG

Community Support
Community Support

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,


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 ?

update record 1.PNGupdate record 2.PNG

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.

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

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,


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,186)