Forum Discussion
Archive records from a list which as exceed the 5k limit
Hi, A SharePoint list as exceed it 5k limit. As anyone be able to archive data to another list, using a Flow? Is it possible to archive files in to individual folders for example for the years...
SvenSieverding
The issue is relating to a Choice column in the list. Trying to add to the list and this error message appears
There are loads of records. Over 20k 
Hi Chris_Clark1968,
are you setting the toggle "Enforce Unique Values" (in "More Options") to true?
(Do you really want that with a choice column? Then you can only use each choice exactly with one element)
This combination won't work in a list with more than 5000 elements as SharePoint can not make sure that this setting works.
Best Regards,
Sven