hi @SPS-DEV-22
It would depend. 1 I would be curious what the issue is as 2000-3000 is super small unless you have a super wide list and lots of heavy columns.
But there is no OOB archive process. And Archival itself is a broader topic. Like will you need to reload them ever, or do you need them for analytics, or for searches (indirect or direct) etc.
The easiest way is to either create a daily or time based flow that runs and counts the rows and then either exports them to a blob or to another matching list. This way you could run your daily or weekly or whatever recurring flow to search by created and or modified and say hey if the date for modified is greater than X period then export it/copy it and then delete it.
One thing to remember is that you would want to add an extra column of data if you put it into another list, so that you can track the original row id in the sharepoint list.
Which leads to another issue, from an auditing etc perspective, if you remove them and then later need to lookup all the changes to X row, you have to cross match them. And if you have since removed all the rows related to changes and want to put them back, the issue is these rows wont have the same rowid in sharepoint.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
