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 :
Finance | Project Operations, Human Resources, ...
Answered

Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

(0) ShareShare
ReportReport
Posted on by 4,624

Hi , 

I am creating ER Data model mapping with Data source. I have to bind data source enum field with enum field in data model but " Bind" is not unable for that. Can someone please suggest how to do that.

pastedimage1607417747300v1.png

I have the same question (0)
  • Rohin Profile Picture
    4,624 on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Thanks Blue but its really complicated.

    @Ludwig - Can you please suggest that simple way you usually do for bind Enum data source fields to DataModel.

  • Verified answer
    Blue Wang Profile Picture
    on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Hi Sir,

    I read this Enumeration (Dynamics 365 for Operations > Enumeration) part.

    : ax.docentric.com/.../

    It seems to transform the NoYes enum value into a boolean value in the model.

  • Rohin Profile Picture
    4,624 on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    hey Ludwig,

    It says some incorrect references:-

    pastedimage1607502622264v1.png

    Please suggest.

  • Rohin Profile Picture
    4,624 on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Thanks Ludwig , I'll try this and let you know.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Hi Rohin,

    An alternative to defining "Eye" as Enumeration value is defining it as a "String".

    To map the "Is Thinning" NoYes Enum value you can do something like this:

    On the data model "Eye" field click the edit button.

    The select the case formula and do something like

    Case (Eye,

    Thinning.No,

    "NO",

    Thinning.Yes,

    "YES")

    That's what I use often and that overcomes issues with the correct formatting and mapping of enums.

    Hope it helps.

    Best regards,

    Ludwig

  • Blue Wang Profile Picture
    on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Hi Sir,

    Please refer this blog:dynamicsmanuals.com/.../

    If you missing some setup.

  • Rohin Profile Picture
    4,624 on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Hey Blue,

    Thining is Enum type field in my Table and i am trying to BIND  DATA MODEL with my data source , not DATA FORMAT.

    I could see there is no direct way to bind Enum Fields , Can you please suggest how to BIND Enum fields.

  • Blue Wang Profile Picture
    on at
    RE: Bind Enum DataSource field with Enum type Data model Field in Electronic Reporting D365FO

    Hi Rohin,

    What type of thinning field is yours?

    164062.PNG
    Bind cannot be performed if the type does not match.

    I tried it and it seems that there is no type that can bind with Enum.

    417641.PNG

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 785 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 626 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 621 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans