Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Sales forum / How to Change the Data...
Sales forum

How to Change the Data Entity Field Sequence in D365?

(1) ShareShare
ReportReport
Posted on by Sakthiananth 2,127

Hello, Currently I'm developing the Data Entity where I need to export few fields in certain order in Excel to show it to the Vendor but Dynamics 365 doesn't allow me to do this and I couldn't find any where to control this sequencing property for the fields.

The below image is what my data entity field sequence order render for me but this is not desired one.

4011.2017_2D00_04_2D00_20_5F00_9_2D00_03_2D00_07.png

The below one is the needed format.

0083.Final.png

Could any body through some light on this how to control this data field sequencing to export it in excel in the above format.

I've tried rearranging the field in the data Entity field node but that didn't helped me out and also I've tried sequencing number on the Entity mapping but this too didn't help me, still I couldn't achieve the  desired export format. Any Ideas will be greatly appreciated. Thanks:)?

Categories:
  • Rich Profile Picture
    Rich 253 on at
    How to Change the Data Entity Field Sequence in D365?
    Some may prefer a new thread to resurrecting this, but feels pretty relevant...

    Can anyone offer advice if I'm persistently seeing this not affect the order of fields in the output? For both custom and standard data entities, I'm seeing the "default" order in the export file even when I've carefully ordered using Entity attribute
  • Suggested answer
    Shah Keyur Profile Picture
    Shah Keyur 365 on at
    RE: How to Change the Data Entity Field Sequence in D365?

    The best approach for this is to select a sample template file while creating data project and adding your entity to the project.

  • rkoduri Profile Picture
    rkoduri 5 on at
    RE: How to Change the Data Entity Field Sequence in D365?

    Hi,

    I have similar requirement and can you please help where exactly we can locate entity attributes for changing the sequence.

  • Nicolas D365 Profile Picture
    Nicolas D365 20 on at
    RE: How to Change the Data Entity Field Sequence in D365?

    Thanks a lot !

  • Suggested answer
    Percy Nxumalo Profile Picture
    Percy Nxumalo 115 on at
    RE: How to Change the Data Entity Field Sequence in D365?

    Assume you are using enhanced view.

    1. Create export project and add your entities.

    2. Click on applicable legal entities button

    2. Click on processing group that you created for your export and click on entities.

    3. Select your entity and click on Entity Attributes

    4. Then you can re-sequence your fields using up and down buttons.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Change the Data Entity Field Sequence in D365?

    Hello,

    I have de same problem. Could you solve it?

    Thanks

    Tere

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Change the Data Entity Field Sequence in D365?

    Unfortunately there is no option to re-arrange the sequence with which the fields appear in the spreadsheet that will be imported.

    The 'sequence' field refers to the sequence of importing the data entities and not to how the fields appear.

    The only way to put the fields in the order you wish is by creating the data entity from scratch or by adding new rows where you want in order to achieve the desired result.

    2555.import.png

    Of course this is time consuming and inefficient.

  • Suggested answer
    Zain Bokhari Profile Picture
    Zain Bokhari 3,208 on at
    RE: How to Change the Data Entity Field Sequence in D365?

    I don't think its possible this way. But if you ever do find a solution, Do share!

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans