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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

[Data Export] "The field with ID '0' does not exist in table" error when exporting data?

(0) ShareShare
ReportReport
Posted on by 167

Version in use: app 10.0.8 / plat 32

I've created a new table with the following fields in my custom model:

(int)UnitIdNumber,(real) Cost,(enum) Spared,(enum) Priority ,(string) Description

I then created an entity so I could export this data. When the entity is created it also creates a few additional fields in the staging table that I do not need

(DefinitionGroup, ExecutionId, IsSelected, TransferStatus.), so I delete them from the staging table.

After building and Syncing the database, I go to my table view URL to ensure the table is there. It is there and it's currently empty.

Then I go to data import/export to test the export and verify the empty table is exported without issue.

I then add 1 row of data to the table from the table view, and then return to data export workspace.

Now when I try to export the data this time it fails with the generic error "The field with ID '0' does not exist in table 'MyDataTable'". Other answers around this seem to point to the issue being in the map, however I don't know why this is working for an empty table then because the map should be the same. I did review the map settings in data import/export and all fields are mapped correctly. I removed my data from the table and the export works without issue. What could be causing this to happen?

I have the same question (0)
  • tayapr Profile Picture
    167 on at

    To clarify the above, I do have indexes on my main table and my staging table. The error message above should correctly read as "The field with ID '0' does not exist in table 'MyDataTableStaging'".

  • Verified answer
    tayapr Profile Picture
    167 on at

    Able to figure it out, those fields I had deleted were needed. Export was failing because they were not referenced. Was able to figure out how to reference them. Now Export is working.

  • Allen Dejoux Profile Picture
    Microsoft Employee on at

    Hi tayapr,

    I am glad you were able to resolve your issue, would you take a moment and mark "yes" for the post which answered your question?

  • André Arnaud de Calavon Profile Picture
    305,455 Super User 2026 Season 1 on at

    A person is not able to verify his/her own answer. I have marked the correct answer now. I think this was a good learning for Tayapr.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 146 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 102 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 102 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans