The list item could not be added or updated because duplicate values

Like (0) Share

Report

Posted on 9 May 2023 17:16:38 by BenBennett321

114

I have a flow which is triggered when a xlsx export is saved in a certain folder.

It deletes all entries of an existing SharePoint list and then writes the contents of the excel file to said SharePoint list. Once done, it deletes the file that triggered this flow.

This has been working fine until today where I get the following error message:

The list item could not be added or updated because duplicate values were found in the following field(s) in the list: [Area].
clientRequestId: 1582e916-1fbf-4200-af23-e2960c076f46
serviceRequestId: 1582e916-1fbf-4200-af23-e2960c076f46

What is strange is there is no duplicate entry in the excel file and all entries do seem to be written to the SharePoint list, it's just that the flow states it's failed and the file is not deleted. I'm not sure why this is happening, does anyone have any ideas.

Many thanks,

All responses (2)

Answers (1)

Verified answer

BenBennett321 114 on 10 May 2023 at 09:51:06

Like (0)

Report

Re: The list item could not be added or updated because duplicate values

Hi, I worked out the problem - The limit for the Get Items part of the flow which deletes the entries on the list (Before it then writes the new set) is 100 by default, but it was trying to update 104. This meant that not all the entries were deleted, so they remained and hence there was a duplication on the Sharepoint List at the ned of the flow.

I've increased the Top Count to 200 (as there will never be more than that in my import) and it works fine.

Many thanks
Nived_Nambiar 17,982 Super User 2025 Season 2 on 09 May 2023 at 17:33:38

Like (0)

Report

Re: The list item could not be added or updated because duplicate values

Hi @BenBennett321

is Area a column under the list ?