Migrating SharePoint List items created between two dates

Question

Hello Community,

I have a SharePoint 2013 list containing items created between 2012 and 2022. I want to migrate only the ones created in 2015 to SharePoint Online. I am using SharePoint Migration Tool.

Note: I cannot migrate all of the source list and then delete all the non 2015 records because it exceeds 50 000 items.

The tool only offers migrating list items that are created/modified after a certain date.

Is there a way to only migrate list items that are created between two dates? Maybe using JSON for bulk migration? Maybe something like the following:

{  
  "Tasks": [  
    {  
      "SourcePath": "source path",  
      "TargetPath": "target path",  
      "Items": {  
        "Lists": [  
          {  
            "SourceList": "source",  
            "TargetList": "target"  
          }  
        ],  
        "SubSites": []  
      },  
      "Settings":{  
        "MigrateFilesCreatedAfter": "2014-12-31",  
        "MigrateFilesCreatedBefore": "2016-01-01"  
      }  
    }  
  ]  
}  

Answer 1

Hi @Bachar HAJJAR ,

According to my research and testing, unfortunately, we cannot migrate SharePoint List Items between specified date. As you said, SharePoint Migration Tool only can filter "Migrate files created after"/ "Migrate files modified after" . I also try to use JSON, but per my test, it is not possible. Currently there is no way to achieve it.

I suggest you can propose a feedback on this issue. Many features of our current products are designed and upgraded based on customers’ feedback. With requirements like this increase, the problem may well be released in the future. Thanks for your understanding.

feedback:
https://feedbackportal.microsoft.com/feedback/

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---