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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer Service forum

Cannot export because display field names are duplicated

(0) ShareShare
ReportReport
Posted on by

When I export all the fields in the specific entity choosing "static worksheet(page only)" from advanced find, the error message comes out "generate excel file error". I know its reason that there are duplicated field names. But I'm sure the system has its unique field names separately from display names. How can I export all the data in the entity to avoid having error? I cannot change display name.

Categories:
  • Suggested answer
    bac26 Profile Picture
    2,268 on at

    You CANNOT export unless the display names are different.   Doesn't matter if the field names are unique.   

  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi tomoko,

    As Beth explained, we cannot export data to Excel unless the fields have no duplicate display name.

    Although there are "name" and "display name" for fields in D365, there is no such distinction in Excel.

    Excel has only one field name, the display name exported from D365.

    So in order for the exported Excel to work properly, the display names of the fields exported from D365 must be different.

    If my answer is helpful, please mark it as verified. This will help other users with the same theme.

    Hope this helps.

    Best Regards,

    Lu Hao

  • Suggested answer
    Community Member Profile Picture
    on at

    Thank you so much. We have so many same display names in one entity. I understand that we should change those names as unique.

  • Community Member Profile Picture
    on at

    Thank you!!!

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 > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans