Sep 28 2020 03:23 AM
Hi All,
We have a large Document Library with ~200k items.
We are looking to have a solution which automatically archives any files older than 3 years and moves them into a new archive document library.
Ideally, when moved into the archive library, the file would keep the same folder structure.
We have looked into Power Automate however we are having issues with delegation limits.
Any suggestions for this?
Sep 28 2020 03:50 AM
@Clong97 Hello,
What do you mean with delegation limits? You should have a service account that makes the work. So that it can be easily tracked by audit log and also ensure that not the wrong person gets access to the sensitive information.
Sep 28 2020 03:52 AM
@Clong97 You could create a site policy and get notifications when files have become older than three years. Not sure if the policy can trigger a power automate.
Sep 28 2020 03:59 AM
Sep 28 2020 04:04 AM
@Clong97 Ah, it makes kinda sence. I would suggest to build the automated solution in PowerShell.
have a script that runs once a week (during weekend), to analyze your files and based on metadata fields, be able to move them directly or notify a content responsible. There are many cool ways to solve this. But it is absolute a challenge to go through so many items. Even PowerShell can fail with loss of connection or runtime error. My recommendation is to use PowerShell, either locally or in Azure functions.