SharePoint Retention Policy not working – Solved

SharePoint provides Out of the box Information management policy for document retention. If you try to browse the internet for information regarding this, you find many posts which complains that retention policy not working. This blog is my experience with retention policy.

SharePoint provides many actions which can be performed on item, when it is ready or marked for expiration. Here are the list of actions

  • Move to Recycle Bin
  • Permanently Delete
  • Transfer to another location(need to configure ‘Send To’ connection in Central Admin before hand for this to work)
  • Start a workflow
  • Declare a record
  • Delete previous drafts
  • Delete all previous versions.

I am not going to explain the steps to set the retention policy to work. Here is a blog which explains how to set retention policy in SharePoint.There are many other good articles explaining it in detail.

I tried to archive a huge document library based on creation date. My idea was to move documents to a new ‘Archival library‘ located in same sub site. First of all I need to use the action ‘Transfer to another location‘ from the available options. To get this working, we need to create a new ‘Send To‘ connection in Central Administration.

Note: Before hand, Content Organizer site feature should be activated in the destination site.Conent Organizer


Go to Central Admin -> General Application Settings -> Under External Service Connections -> Configure Send to ConnectionsConfigure Send To Connection


Here is a blog which explains how to configure sent to connections in SharePoint.

Once you have it configured. It shows up in the drop down when you are adding retention rules.Retention Policy not workingNow you have your Retention policy setup to move documents older than 4 months (created + 4) months move to a location (for which you have configured Send to connection).Retention Policy

Ideally once the timer jobs
1. Information Management policy
2. Expiration policy

are run successfully, all the document should be moved to ‘Archival library’ in your subsite. But that did not happen.
When i modify the retention policy to move documents to ‘Recycle bin’ after 4 months, it was working perfectly fine. It makes it clear that, the issue with moving the documents. I verified that my ‘Send To’ connection is working fine. After exploring all the options, we logged a support ticket with Microsoft.

After couple of weeks, Microsoft came back with the answer – It was as per design. If you try to move documents to a different location using Retention policy, you have to move it a library in a different site collection. Preferably ‘Records center‘ site collection. Main idea of Microsoft is to have one Archival or Records center site collection for the whole organization.

So, if you are trying to move documents after expiration to a library in same site or site collection, you can use a workaround to start a workflow on expiration date which moves the document to archival library. This is what i ended up doing.Archival workflow rule


Designer workflow


After the timer job is run and item is marked for retention, workflow kicks in and moves the document to archival library and deletes the document in present library.

Hope this helps some one! If there is any other better approach to solve this, please post a comment.

3 thoughts on “SharePoint Retention Policy not working – Solved

  1. FINALLY! I’ve been busting my head on the keyboard trying to find out why this didn’t work. Powershell scripts, strange permissions and still nothing work. You rock! Setting up my workflow now!

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Designer cannot display the item

You run into ‘SharePoint Designer cannot display the item’ error when you are trying to edit an existing workflow setup in Designer quite often when there is a windows update or update to .NET framework installed in your computer. In some cases it may also not allow you to create new workflows. Resolution: Clearing Designer […]

Read More

Windows security prompt. Connecting to SharePoint….

Users often run into this issue. Windows security prompt pops up every 15 minutes or so repeatedly trying to connect to SharePoint. No matter you enter credentials or cancel, user will be prompted for credentials again and again. SharePoint may not be the culprit all the time. List of things I check whenever I run […]

Read More

User with Contribute access gets access denied

Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions – check permission option. Every other person in the […]

Read More