Forum Discussion
Dataflow failed to update Dataverse lookup field
Hi all,
I am having and issue when try to update a lookup field in dataflow. There is an error appears on the screen when I run bebug:
Job failed due to reason: Error response from server: Some({"error":{"code":"0x80048d19","message":"Error identified in Payload provided by the user for Entity :'', For more information on this error please follow this help link https://go.microsoft.com/fwlink/?linkid=2195293 ----> InnerException : Microsoft.OData.ODataException: An undeclared property 'ngo_incomecode1' which only has property annotations in the payload but no property value was found in the payload. In OData, only declared navigation properties and declared named streams can be represented as properties without values.\r\n at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadUndeclaredProperty(IODataJsonLightReaderResourceState resourceState, String propertyName, Boolean propertyWithValue)\r\n at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadPropertyWithoutValue(IODataJsonLightReaderResourceState resourceState, String propertyName)\r\n at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.<
I could not figure out where the issue is. I have done the following steps:
- Data preview in sink step can see there is value
- I have tried to use Xrmtoolbox to update the field with SQL statement and there is no issue.
- Pipeline debug mode show error with the following screen:
Thank you very much in advance.
Henry