cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

CDS Error "0x8006088a"

Hi all,

 

I need to create a flow that (when condition true) copy the adress to another field.

 

Trigger

When a record is created, updatet or deleted

 

 

Conditions (CDS fields from D365)

new_syncaccountaddress = true

new_erpid = "A309943" (onyl for testings)

 

If condition true the flow should change follow fields in Dynamics 365 Sales.

 
 
 

grafik.pnggrafik.png

Now I get the error below.

 

 

{
  "error": {
    "code": "0x8006088a",
    "message": "Bad Request - Error in query syntax."
  }
}

 

 

 

What do I have to adjust in the flow to make it work properly?

Thanks in advance and greetings from Switzerland

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

Hi all,

 

I've found the solution for my issue.

If you need to update a lookup field, yout need to write the entity-name as a prefix and then the ( dynamic content )

Now everthing works 🙂

 

Thanks you all for the help!

View solution in original post

6 REPLIES 6
Super User III
Super User III

Hi @DaleJohnny 

 

Which step you getting the error? Is that in your update record step? Check the field data types and corresponding value you trying to map.

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Hi @abm 

 

I get the error in the last step (update record).
I've already checked the mapping and everything should be fine.
Only by the "item id" i'm not shure - do i need to write the record id from D365?

Super User III
Super User III

Hi @DaleJohnny 

 

What data type is Item Id? Make sure your mapping value is also the same type.  If not try to use the int() expression to convert it.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Hi @abm 

 

Thanks for your answer.

 

The Item ID is the GUID from Dynamics 365 sales.

I've put now the dynamic content for this Item-ID - that should be correct now.

 

But, now i receive the error below in the step "Update a record".

{
  "error": {
    "code": "0x0",
    "message": "An error occurred while validating input parameters: Microsoft.OData.ODataException: The 'odata.bind' instance or property annotation has a null value. In OData, the 'odata.bind' instance or property annotation must have a non-null string value.\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadAndValidateAnnotationStringValue(String annotationName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadAndValidateAnnotationStringValueAsUri(String annotationName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadEntryPropertyAnnotationValue(String propertyAnnotationName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadODataOrCustomInstanceAnnotationValue(String annotatedPropertyName, String annotationName, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ParseProperty(PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue, String& parsedPropertyName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ProcessProperty(PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue, Action`2 handleProperty)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadResourceContent(IODataJsonLightReaderResourceState resourceState)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightReader.StartReadingResource()\r\n   at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadResourceSetItemStart(PropertyAndAnnotationCollector propertyAndAnnotationCollector, SelectedPropertiesNode selectedProperties)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtStartImplementationSynchronously(PropertyAndAnnotationCollector propertyAndAnnotationCollector)\r\n   at Microsoft.OData.ODataReaderCore.ReadImplementation()\r\n   at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action)\r\n   at System.Web.OData.Formatter.Deserialization.ODataReaderExtensions.ReadResourceOrResourceSet(ODataReader reader)\r\n   at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext)\r\n   at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)"
  }
}

 

Solution Sage
Solution Sage

Hi @DaleJohnny ,

Do you have look up value in the update record step. if yes then before setting that lookup value check for inputs coming from previous step whether it is null , accordingly do update.

 

Thanks

Frequent Visitor

Hi all,

 

I've found the solution for my issue.

If you need to update a lookup field, yout need to write the entity-name as a prefix and then the ( dynamic content )

Now everthing works 🙂

 

Thanks you all for the help!

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,375)