web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Data type mismatch error while mapping field of Dynamics F&O and FS in power app integration flow

(0) ShareShare
ReportReport
Posted on by 50

I have added a custom NoYes enum type field in InventTable and also in the entity which is usimg to integrate the Dynamics F&O and FS . In FS side boolean type field isFixedAsset is created which has to map with field isFixedAsset of F&O. After mapping the field and refreshing the entity ,I run the project . But getting the below error.

Reason: Bad Request, Header x-ms-client-request-id 2a65f5cd-cd58-4a43-abd5-89d6cbdbfb6a, Error code: 0x0, Message: An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal 'No' to the expected type 'Edm.Boolean'. ---> System.FormatException: String was not recognized as a valid Boolean. at System.Boolean.Parse(String value) at System.String.System.IConvertible.ToBoolean(IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at Microsoft.OData.ODataPayloadValueConverter.ConvertStringValue(String stringValue, Type targetType) at Microsoft.OData.ODataPayloadValueConverter.ConvertFromPayloadValue(Object value, IEdmTypeReference edmTypeReference) --- End of inner exception stack trace --- at Microsoft.OData.ODataPayloadValueConverter.ConvertFromPayloadValue(Object value, IEdmTypeReference edmTypeReference) at Microsoft.Crm.Extensibility.ODataV4.CrmPrimitivePayloadValueConverter.ConvertFromPayloadValue(Object value, IEdmTypeReference edmTypeReference) at Microsoft.OData.JsonLight.ODataJsonLightReaderUtils.ConvertValue(Object value, IEdmPrimitiveTypeReference primitiveTypeReference, ODataMessageReaderSettings messageReaderSettings, Boolean validateNullValue, String propertyName, ODataPayloadValueConverter converter) at Microsoft.OData.JsonLight.ODataJsonLightPropertyAndValueDeserializer.ReadPrimitiveValue(Boolean insideJsonObjectValue, IEdmPrimitiveTypeReference expectedValueTypeReference, Boolean validateNullValue, String propertyName) at Microsoft.OData.JsonLight.ODataJsonLightPropertyAndValueDeserializer.ReadNonEntityValueImplementation(String payloadTypeName, IEdmTypeReference expectedTypeReference, PropertyAndAnnotationCollector propertyAndAnnotationCollector, CollectionWithoutExpectedTypeValidator collectionValidator, Boolean validateNullValue, Boolean isTopLevelPropertyValue, Boolean insideResourceValue, String propertyName, Nullable`1 isDynamicProperty) at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadEntryDataProperty(IODataJsonLightReaderResourceState resourceState, IEdmProperty edmProperty, String propertyTypeName) at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadPropertyWithValue(IODataJsonLightReaderResourceState resourceState, String propertyName, Boolean isDeltaResourceSet) at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.<>c__DisplayClass9_0.<ReadResourceContent>b__0(PropertyParsingResult propertyParsingResult, String propertyName) at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ProcessProperty(PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue, Action`2 handleProperty) at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadResourceContent(IODataJsonLightReaderResourceState resourceState) at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadNextNestedInfo() at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtNestedResourceInfoEndImplementation() at Microsoft.OData.ODataReaderCore.ReadImplementation() at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action) at System.Web.OData.Formatter.Deserialization.ODataReaderExtensions.ReadResourceOrResourceSet(ODataReader reader) at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext) at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)

 

I have the same question (0)
  • Suggested answer
    D365 FnO Developer Profile Picture
    50 on at
    RE: Data type mismatch error while mapping field of Dynamics F&O and FS in power app integration flow

    Thanku Miguel,

    I have transformed the datatype using function command data integration flow in power app .

    I have used transform type ValueMap as No -> False and Yes->True.

    The issue is resolved.

  • Suggested answer
    Miguel Lourenco Profile Picture
    on at
    RE: Data type mismatch error while mapping field of Dynamics F&O and FS in power app integration flow

    Hi, by FS I understand Field Service, therefore you need to go to yourorg.crm4.dynamics.com/main.aspx

    - Customizations

    - customize the system,

    - search for your entity and

    - go to fields.

    I don't think it will be possible to change the data type but you can delete the field and recreate it with the correct data type (of course you will lose its associated data). If that is a problem for you, you can create a new field with the correct data type and somehow copy all values from one to the other.

    From the F&O perspective I don't know.

  • D365 FnO Developer Profile Picture
    50 on at
    RE: Data type mismatch error while mapping field of Dynamics F&O and FS in power app integration flow

    Hello Miguel.

    Thanks for the quick response.

    The value of NoYes enum type is saved as 0 for No and 1 for Yes. Do you know where we can change the property of same field in FS ?

    How can we match the datatype of both field in dynamics F&O and FS

  • Suggested answer
    Miguel Lourenco Profile Picture
    on at
    RE: Data type mismatch error while mapping field of Dynamics F&O and FS in power app integration flow

    hi, as stated in the error, they are of different types:

    boolean and enum

    Can you change one of them to meet the same type as the other?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 101 Super User 2025 Season 2

#2
Suresh Kulla Profile Picture

Suresh Kulla 69 Super User 2025 Season 2

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 58

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans