How to export the Data Entity in Excel having field sequence as per data entity structure.

(1) Share

Report

Posted on by harshilsavaj

I am trying to export the data entity into excel but the issue is I have set Field1, Field2, Field3, Field4 .... like this in Data entity and Same in Staging table. But when i export this in Excel i am getting field in different order like field3,field4,filed6... like this. Please let me know the solution as i dont want to do labour work by selecting sequence number in Entity page. Also i am having 120+ fields so i want it in sequence as i am exporting it every hour.

Product: Microsoft Dynamics 365 Finance & Operation

Version: .47

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Subramani Sivan 374 on at

Like (0)

Report
Copy link

Link copied!

Please create an excel file format and use that as a template and export the data.

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Verified answer

Deepak Agarwal 8,712 on at

Like (0)

Report
Copy link

Link copied!

(Assuming you are using a custom entity)) How you are exporting data, using DMF or Excel ad ins.

If you are using DMF, you can try use a sample file with your own sequence of fields, make sure you download the default template first and use the same just changing the sequence of fields.

If you are using excel ad ins, excel ad in refer data entity's Field group > Auto reporting for fields and sequence, if you set the order of fields in this field group, you must be able to get right sequnce in excel ad in export.

Was this reply helpful? Yes No
harshilsavaj 24 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Subramani Sivan @Deepak Agarwal. It worked for me.

Was this reply helpful? Yes No