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

Notifications

Announcements

No record found.

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)
  • Blue Wang Profile Picture
    on at

    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

  • Rohin Profile Picture
    4,624 on at

    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

    Hi Sir,

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

    If you missing some setup.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Rohin Profile Picture
    4,624 on at

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

  • Rohin Profile Picture
    4,624 on at

    hey Ludwig,

    It says some incorrect references:-

    pastedimage1607502622264v1.png

    Please suggest.

  • Verified answer
    Blue Wang Profile Picture
    on at

    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

    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.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans