Power Platform Community Forum Thread Details

Hi,

While using Invoke SOAP web service to add a new record in Data Verse table, I'm getting this response.

{"error":{"code":"0x0","message":"CRM do not support direct update of Entity Reference properties, Use Navigation properties instead."}}

What does this mean? is there any thing to change/update with Dataverse table or something within the desktop flow?

Here is the parameter I used for Invoke SOAP Web service :

Custom headers :

OData-MaxVersion:4.0
OData-Version:4.0
Accept:application/json
Content-Type:application/json; charset=utf-8
Prefer:return=representation
Authorization: Bearer %Token%

Request body:

{"_cr303_queue_id_value" : "%CurrentItem_DataTable_Add_Cases['QueueId']%","cr303_monthnumber" : "%CurrentItem_DataTable_Add_Cases['MonthNumber']%","cr303_year" : "%CurrentItem_DataTable_Add_Cases['Year']%","cr303_processedcases_success" : "%CurrentItem_DataTable_Add_Cases['ProcessedCasesSuccess']%", "cr303_processedcases_exception" : "%CurrentItem_DataTable_Add_Cases['ProcessedCasesException']%", "cr303_workunitpercase" : "%CurrentItem_DataTable_Add_Cases['WorkUnitPerCase']%"}

Categories:

Power Automate Desktop

I found the same question and answer here.

Getting 400 Bad Request "CRM do not support direct update of Entity Reference properties, Use Navigation properties instead :

Set Values of all Data Types using Web API in Dynamics CRM :

It is suggested to "@odata.bind" with property value.

"_customerid_value": "2e593c87-3107-e811-a956-000d3af28a0d",

"customerid_contact@odata.bind": "contacts/2e593c87-3107-e811-a956-000d3af28a0d"

Here is my request body :

{

"_cr303_queue_id_value" : "%CurrentItem_DataTable_Add_Cases['QueueId']%",

"cr303_monthnumber" : "%CurrentItem_DataTable_Add_Cases['MonthNumber']%",

"cr303_year" : "%CurrentItem_DataTable_Add_Cases['Year']%",

"cr303_processedcases_success" : "%CurrentItem_DataTable_Add_Cases['ProcessedCasesSuccess']%", "cr303_processedcases_exception" : "%CurrentItem_DataTable_Add_Cases['ProcessedCasesException']%", "cr303_workunitpercase" : "%CurrentItem_DataTable_Add_Cases['WorkUnitPerCase']%"

}

It looks to use "@odata.bind" with "_cr303_queue_id_value" (lookup field). However, I'm not understanding how the syntax should be.

It should be something like this :

"cr303_queue_id@odata.bind": "id/(%CurrentItem_DataTable_Add_Cases['QueueId']%)

Please guide me if I'm understanding correctly.