Forum Discussion
Deleting old rows from a SharePoint list
Hi, I am using a SharePoint site as a database for a desk booking system. The data is held in SharePoint lists. I want to delete old data, i.e. items older that 1 month Is there an easy way to ...
Ollie Another option, in addition to what Rob mentioned, is to utilize the in-built list retention.
- Go into Site Settings > Site Collection Features > enable Library and Folder Based Retention
- Go into your List Settings > Information management policy settings > click on Item > select Enable Retention
- Add a retention stage > Set Time Period to Created Date 1 month then click on Ok. This should delete your items automatically after 1 month of creation (you can choose to have them permanently deleted or sent to the recycle bin).
IMPORTANT: For any of these solutions, I'd highly recommend trying them out on a Test List first to ensure they work as expected.