Template Data Import Duplicate error

(0) Share

Report

Posted on by Community Member

When I use the Template for Data Import and select Account, then I get an error message: A duplicate column heading exists.

For other records like Case or Contact all is working fine.

How can I resolve the error related to the account?

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

LuHao 40,892 on at

Like (0)

Report

Hi Marcel,

This is because there are duplicate Display Names of Account fields.

Note that the imported template cannot have duplicate column names, which is the Display Name of the fields.

So we have to find out the duplicate Display Name.

Go to https://make.powerapps.com/, select the D365 environment and go to Data > Entities > Account > Fields, sort by Display name and try to find duplicate fields.

If there are too many fields, then you could click Edit data in Excel to download the Excel file.

Here is a demo, I changed the display name of the field "Twitter" to "Facebook", then there are two "Facebook".

In the Excel, these two fields are displayed as "Facebook" and "Facebook2".

Therefore, the column of the duplicate field will end with 2.

So wo search "2" in the Excel and find all, we will see the duplicate field.

Go back to power apps, edit the duplicate field and change its display name.

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (0)

Report

Hi Marcel,

Please don't forget to click Yes under Did this answer your question? to close this thread.

Thanks. :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Lu Hao,

Yes thank you, this was the root cause.

Sorry for not responding.

Kind regards,

Marcel Kroon

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (0)

Report

Hi Marcel,

Glad that your problem has been solved.

Could you please click Yes to close this thread? Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

done

Was this reply helpful? Yes No