In short, I think would like to able to programatically create folders and sub folders with permissions in a document library based on a csv of some sort…
Here’s the setup:
I’m working on behalf of a school. They have senior leaders, subject departments (each with a head of dept) and teachers. I have been asked to create a structure whereby each teacher has a folder which they can access, but nothing more. The dept heads should have access to the teacher folders in their dept, and senior leaders can access everything.
My PowerShell knowledge is building, but what I have read so far has had me a little befuddled to say the least.
I’m thinking there must be a way to do all of this through code and a csv, but I have so far been unsuccessful in doing so.
I wonder if someone out there would be kind enough to point me in the right direction…?
Or maybe, you have a better idea of how to achieve the same result – I considered security based on columns, but I’m not sure if this is possible ‘out of the box’…?
Thanks in advance lovely people.
You are going to want to be careful about how you set this up. Many people fall into the trap that SharePoint is a replacement for a File Share, when it simply isn’t. There is a general rule of SharePoint, “Don’t use Folders”, merely because they generally cause more issues than benefits.
However, with that being said it is possible to script this out. What do you have so far for your code?
Thank you Beau I don’t really want to do this for that very same reason. However, I can’t think of any other way of producing what they need in the cloud – unless you’ve got some wisdom…? I actually don’t have very much code at all… I was trying to follow these instructions https://collab365.org/creating-sharepoint-folders-via-powershell/ But soon realised this isn’t for SPO…so I’m back to square one…
So waddya reckon @beau-cameron? Is it possible to do something similar for SPO? Or should I just give up and suggest something else?
It’s not really what SharePoint is for, I realise that. But, it’s possible, and I think it’s the best way of achieving what they want…I’m happy for anyone to suggest alternative solutions… I thought I was onto something with these instructions… https://collab365.org/creating-sharepoint-folders-via-powershell/ But then I realised that it’s for SP on premise. It’s exactly what I want though – managed through a CSV… So waddya reckon @beau-cameron and everyone? Is it possible to do something similar for SPO? Or should I just give up and suggest something else?
Thank you @beau-Cameron – I had a breakthrough yesterday, and I’ve got it working!
Testing a comment.
Jonathan, I’ve been trying to respond, but I am unable to load the comments from the other post… not sure what is going on with that. Can you try responding on this one and see if I will be able to view it?