SharePoint Online list with 1 day retention policy still showing 3 days of items

%3CLINGO-SUB%20id%3D%22lingo-sub-1458034%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20list%20with%201%20day%20retention%20policy%20still%20showing%203%20days%20of%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458034%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20Online%20list%20set%20up%20with%20a%201%20day%20retention%20policy%20-%20I%20set%20this%20up%20under%20List%20settings%20%26gt%3B%20Information%20management%20policy%20settings%3A%20Content%20Type%20Policy%3A%20Item.%20In%20'Edit%20Policy'%20I%20have%20'Enable%20Retention'%20ticked%2C%20and%20event%20of%20Created%20Date%20%2B%201%20days%20has%20an%20action%20of%20'Move%20to%20Recycle%20Bin'%20with%20no%20recurrence.%3C%2FP%3E%3CP%3EThe%20retention%20policy%20seems%20to%20be%20kicking%20in%2C%20but%20it's%20still%20keeping%20stuff%20from%20two%20days%20ago%20(so%20in%20the%20'Created'%20filter%20on%20the%20list%2C%20you%20can%20see%20items%20with%20T-2%20days%2C%20T-1%20day%20and%20Today).%20Is%20there%20a%20way%20I%20can%20optimise%20to%20make%20it%20as%20strictly%20as%20possible%20delete%20items%20from%20more%20than%2024%20hours%20ago%3F%3C%2FP%3E%3CP%3EMy%20list%20has%20thousands%20of%20items%20hitting%20it%20a%20day%2C%20so%20I%20don't%20think%20a%20Power%20Automate%20will%20be%20the%20best%20way%20to%20deal%20with%20it%2C%20but%20happy%20to%20be%20convinced%20otherwise.%3C%2FP%3E%3CP%3EAll%20help%20appreciated%2C%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1458034%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1458056%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20list%20with%201%20day%20retention%20policy%20still%20showing%203%20days%20of%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458056%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679790%22%20target%3D%22_blank%22%3E%40rhiheu%3C%2FA%3E%2C%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EPerhaps%20it%20happens%20because%20the%20Policy%20is%20not%20determined%20for%20the%20Site%20Collection%20as%20it%20said%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fretention-policies-sharepoint%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehere%3C%2FA%3E%3A%20'...%3CSPAN%3EA%20retention%20policy%20is%20applied%20at%20the%20level%20of%20a%20site%20collection.%20When%20you%20include%20a%20SharePoint%20site%20collection%20or%20OneDrive%20account%20in%20a%20retention%20policy%2C%20a%20Preservation%20Hold%20library%20is%20created%2C%20if%20one%20doesn't%20exist.%20You%20can%20view%20this%20library%20on%20the%20%3C%2FSPAN%3E%3CSTRONG%3ESite%20contents%3C%2FSTRONG%3E%3CSPAN%3E%20page%20in%20the%20top-level%20site%20of%20the%20site%20collection.%20Most%20users%20can't%20view%20the%20Preservation%20Hold%20library%20because%20it's%20visible%20only%20to%20site%20collection%20administrators.%3C%2FSPAN%3E..'.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3ECheers%2C%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EOleg.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467698%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20list%20with%201%20day%20retention%20policy%20still%20showing%203%20days%20of%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663983%22%20target%3D%22_blank%22%3E%40olegmelnikov%3C%2FA%3E%2C%20thanks%20for%20your%20reply.%20Since%20it's%20possible%20to%20also%20set%20retention%20policies%20at%20a%20list%2Fcontent-type%20level%2C%20I'm%20not%20quite%20understanding%20where%20that%20article%20provides%20an%20answer%20to%20my%20issue%20sorry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467778%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20list%20with%201%20day%20retention%20policy%20still%20showing%203%20days%20of%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467778%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679790%22%20target%3D%22_blank%22%3E%40rhiheu%3C%2FA%3E%26nbsp%3B-%20this%20article%20may%20help.%20Looks%20like%20the%20policy%20needs%20to%20be%20set%20at%20the%20Site%20Collection%20level%20first%2C%20and%20then%20to%20the%20Content%20Type.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2Fset-retention-deletion-policies-files-folders-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepointmaven.com%2Fset-retention-deletion-policies-files-folders-sharepoint%2F%3C%2FA%3E%26nbsp%3BHope%20that%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

I have a SharePoint Online list set up with a 1 day retention policy - I set this up under List settings > Information management policy settings: Content Type Policy: Item. In 'Edit Policy' I have 'Enable Retention' ticked, and event of Created Date + 1 days has an action of 'Move to Recycle Bin' with no recurrence.

The retention policy seems to be kicking in, but it's still keeping stuff from two days ago (so in the 'Created' filter on the list, you can see items with T-2 days, T-1 day and Today). Is there a way I can optimise to make it as strictly as possible delete items from more than 24 hours ago?

My list has thousands of items hitting it a day, so I don't think a Power Automate will be the best way to deal with it, but happy to be convinced otherwise.

All help appreciated, thanks.

3 Replies

Hi @rhiheu,

Perhaps it happens because the Policy is not determined for the Site Collection as it said here: '...A retention policy is applied at the level of a site collection. When you include a SharePoint site collection or OneDrive account in a retention policy, a Preservation Hold library is created, if one doesn't exist. You can view this library on the Site contents page in the top-level site of the site collection. Most users can't view the Preservation Hold library because it's visible only to site collection administrators...'.

 

Cheers,

Oleg.

 

Hi @olegmelnikov, thanks for your reply. Since it's possible to also set retention policies at a list/content-type level, I'm not quite understanding where that article provides an answer to my issue sorry.

Hi @rhiheu - this article may help. Looks like the policy needs to be set at the Site Collection level first, and then to the Content Type. https://sharepointmaven.com/set-retention-deletion-policies-files-folders-sharepoint/ Hope that helps.