I don’t know if this is possible or not but no harm in asking.
We need a process that will query all the folders in a document library based on a word in the document names.
Step 1 (Media collection): Process needs to look inside all the folders in a document library, and create a collection of only those documents with ‘media’ in the name
Step 2 (Media with Date collection): Once step 1 is complete, it then needs to pull out only those items in the collection that are older than a year.
Step 3 (Media with Date include all items): based on the media with dates collection, the document and the parent folder with all it’s content, then needs to be copied to another document library the entire folder and its contents to a new library.
Any ideas on how or if this can be accomplished?
SharePoint 2016 On-Premise