On Sharepoint I have a folder called 'Studies'. Inside this folder I have various sub-folders for example: Research Proposal, Supervisors, Degree Certificate, References. Students upload one or more documents to each folder. The document(s) they upload should include their Student ID and Name (which most do) but they also add other text e.g. Bill Jones 3432920 Research Proposal. They also include some documents, which I don't want to be copied (but I can copy them and delete them later on if needed). I then create folders on my local drive (but it could be on my One Drive or another SharePoint site) for each student and call the folder the Student's ID and Name e.g. 3432920-Bill_Jones. I then have to download each of the students' documents from the various folders on the Sharepoint site into their appropriate folder (which when there are 100s, this takes days to do). Is there a way to automate copying the files into the folders? Fortunately, I have found a quick way of creating the folders using a .bat file. I am relatively inexperienced with Power Automate and have no knowledge of code.
I would be immensely grateful if anyone could help.
Share
Report
All responses (
Answers (
794
