Solved: Azure Logic Apps to D365 F&O flow results in different data type in D365 compared to Logic Apps

Jun Ting Ho 141 Reputation points
2021-03-15T10:21:56.407+00:00

My team is trying to use Azure Logic Apps to List Items Present in a Table in Dynamics 365 Finance & Operations using filterQuery. However, for some of the filter queries, we encounter errors where the data type in D365 is different from the one in Logic Apps, resulting in incompatible types. The fields throwing errors have data types in D365 "enum" and "bool" respectively. Is there a simple way to resolve this error?

77776-20210315-microsoftteams-image-redacted.png77777-20210315-microsoftteams-image-1.png

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,991 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leo Erlandsson 1,656 Reputation points
    2021-03-15T15:27:53.017+00:00

    Hi,

    Some people are reporting success on filtering on Microsoft.Dynamics.DataEntities.NoYes columns.

    Could you please provide what your query looks like?

    I've seen some reporting that e.g. Column eq 1 works.
    And some reporting that e.g.
    Column eq Microsoft.Dynamics.DataEntities.NoYes’Yes’

    works.

    Please see:
    https://erpcoder.blog/2021/02/08/filter-on-noyes-field-in-dynamics-365-flow-connector/

    Br,
    Leo

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. MayankBargali-MSFT 70,006 Reputation points
    2021-03-15T11:33:32.977+00:00

    Hi @Jun Ting Ho

    As per the error message looks like your filter query has a filter on the column of Microsoft.Dynamics.DataEntities.NoYes type and another column of string type.
    You cannot filter on the NoYes type as per the error message. As per the connector action, List items present in table the ODATA filter query restricts the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).