Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Exporting hidden fields from a form

Posted on by 150

Hi,

Does anyone have any suggestions how to include hidden fields into Excel export when exporting from a form? For example, a form has a grid with a limited number of fields on the first tab and the rest of the detail fields are on the second tab, to make it look organized. These tabs behave similar to any standard Overview and Detail tabs. Fields on both tabs reside on the same, prepopulated temporary table. 

Thank you 

  • silentsquirrel Profile Picture
    silentsquirrel 150 on at
    RE: Exporting hidden fields from a form

    Hi Andre,

    I think a customization might work. I'm thinking about an export button which will prompt end users where to save a file and then export all required fields.

    Thanks everyone!

  • Suggested answer
    Jonathan  Halland Profile Picture
    Jonathan Halland 11,302 on at
    RE: Exporting hidden fields from a form

    Hi.

    You can just personalise the form and add the missing fields to the grid. The export to excel then will bring this through, this worked in 2012, I just tested in it is still working in D365.

    2020_2D00_06_2D00_12-08_5F00_25_5F00_00_2D00_Window.png

    2020_2D00_06_2D00_12-08_5F00_25_5F00_44_2D00_Window.png

  • Verified answer
    Blue Wang Profile Picture
    Blue Wang on at
    RE: Exporting hidden fields from a form

    Hi Silentsquirrel,

    As Andre said, hidden columns cannot be exported through "Export to Excel".

    But the hidden column you mean, Is it through personalization? You can try the hidden column or the displayed column before exporting.

    93.PNG

    If not, then you can use the suggested method and use data management.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,914 Super User on at
    RE: Exporting hidden fields from a form

    Hi Silentsquirrel,

    This is not possible. The Export to Excel is taking the columns from the grid only.

    You can potentially use Data Import Export Framework or consider a customization for another way of exporting data to Excel.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans