Hi
We have a sub-site setup in O365 SharePoint online with a typical STAFF list library so different department will update/attach some document(s) to it.
However, the HR staff will save all the STAFF’s certifications to a file folder locally first (e.g \serverHRUsersCertificationsABC123456-Mr.Chan.Cert-1.pdf ) according to their existing workflow. Where ABC123456 is the STAFF NO that match a field in STAFF list library. We cannot change the workflow so it will be a “double-handling” and the HR staff compliant on this …
Any chance we can use a Sharepoint Powershell to upload those .PDF from \serverHRUsersCertifications automatically to the STAFF list library (say everyday @03:00AM) to the respective STAFF record? After the upload/attach, those PDF will be moved to \serverHRUsersCertificationsUploaded folder
do you have the code on doing this via Powershell ?!
If you need to to do this at 3.00 AM every day automatically, then you have two options. A workflow or a scheduler. To host a scheduler you need an Azure app or an on-premise server. Best option is to run a workflow to copy the file from your source to destination.
You may want to check whether Content Organizer (under Manage site features) or Information Management Policy (Library and Folder Based Retention under Site collection features) would work better for your requirement.
This way, you can manage these file transfers within the site itself rather than running a PowerShell script.Â
