A duplicate column heading exists while downloading Template for data export

(1) Share

Report

Posted on by BF-19051058-0

When attempting to export from an Advanced Find View, I get the below error message.

A duplicate column heading exists

A duplicate column heading exists. If you contact support, please provide the technical details.

Error Code: 0x80040338

I have seen a few solutions for when importing but not exporting.

Any suggestions?

Categories:

Dynamics 365 general

A duplicate colum...

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Tom_Gioielli 2,291 Super User 2025 Season 2 on at

Like (0)

Report
A duplicate column heading exists while downloading Template for data export

CRM really doesn't like having more than one column with the same name in an export.

Go to https://make.powerapps.com and open your tables list

Find the table you were exporting from, and go to the 'columns' area to see all of the defined fields

Sort the list of fields by name, and look for two of them that have the same Label Name

Update the label of one of them so it is unique

Save and publish your changes

This has been a limitation for years now, but I think of it as a good thing as you should always try to avoid having duplicate columns names from the perspective of data quality, user perspective, and general system administration.

Good luck and hope this helps!

Was this reply helpful? Yes No
Verified answer

BF-19051058-0 9 on at

Like (0)

Report

A duplicate column heading exists while downloading Template for data export

The issue wasn't to do with naming of any of the fields in a table.
There were many fields/columns I was selecting when creating the view and as there were fields that had similar (although not the same) column names, I had selected some fields/columns more than once (not helped by the window being small to see the full name of the field). Which cased this error.
I found a workaround - Downloading XML of the view (Download Fetch XML), then pasting it to Excel and then creating a pivot table to identify fields that more than one row/count

1 people found this reply helpful.

Was this reply helpful? Yes No