Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Like (0) Share

Report

Posted on 29 Aug 2022 18:03:45 by Awais Qurni

Data export in excel through data entity ,its export all the from table in excel and when I put a record and publish the data through data connector window and its showing a error: Original data contains duplicate entries.

I try after exporting the data in excel delete the existing record and then i put a record this time data publish successfully. But its not a solution . I want when export data in excel existing record not exist in excel file or in the presence of existing record my data will do successfully with no error.

How it is possible , Please give me suggestions thanks.

All responses (4)

Answers (0)

Suggested answer

Komi Siabi 12,789 Most Valuable Professional on 30 Aug 2022 at 19:13:35

Like (0)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Hi Awais Qurni ,

Kindly mark answer(s) verified, to archive this post.
Awais Qurni 56 on 30 Aug 2022 at 04:28:00

Like (1)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Yes
Suggested answer

Komi Siabi 12,789 Most Valuable Professional on 29 Aug 2022 at 19:02:22

Like (1)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Hi @Muhammad Awais Qurni,

Truly, the last two records are duplicates. The error simply means, there is a table on the entity which does not allow duplicate records.

Please double check before publishing.
Suggested answer

BillurSamdancioglu 17,153 Most Valuable Professional on 29 Aug 2022 at 18:06:36

Like (2)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Hi,

How do you try to delete the data?

First delete the data and publish. Then try to upload new please