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, ...
Suggested Answer

Enum label ID in data import/export

(0) ShareShare
ReportReport
Posted on by 439

Hi All,

I have created a simple data entity for export and import  which is just working fine.

Here in the list of fields we have one enum field  and for this field we are using the value as the element name of the enum  not the.

client want to give and take data as  respective label ID  of the enum element.

What is the best possible solution for the same.

I have the same question (0)
  • GirishS Profile Picture
    27,827 Moderator on at

    Hi rohit,

    Normally enum labels will only display on the forms. Try giving enum label as value in the excel and import it. It will work.

    Thanks,

    Girish S.

  • rohit1900 Profile Picture
    439 on at

    Sorry does not work like that i tried  and got the  error message as below :

    The column XXXXXX in entity XXXXXXEntity has incorrect data. Please correct the data and try the import again.

    I am using d 365

  • Martin Dráb Profile Picture
    237,990 Most Valuable Professional on at

    Using a label ID is a strange requirement, because users and external systems usually have no idea what IDs like @SYS22361 mean.

    But if you wish, you can use a virtual field to get label IDs. Using a computed column would also be possible, but it's significantly more work in this case.

  • rohit1900 Profile Picture
    439 on at

    Hi Martin, Can you suggest which 2 methods should  I use for writing the business logic in the data entity, well i tried few of standard method and it seems it is not working  should I use insert and update method of data entity  for inserting the value

  • Suggested answer
    Martin Dráb Profile Picture
    237,990 Most Valuable Professional on at

    I guess you're talking about a virtual field. In that case, use postLoad() and mapEntityToDataSource(). You can find more information, including concrete examples, in F&O documentation: Computed columns and virtual fields in data entities.

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
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans