One Drive For Business Folder Collaboration To Other ODFB Users


Hi guys, let's try to explore a smart process of ODFB specific folders collaboration/permission granting to another ODFB User Account within the same tenant.
The permission types possible are:
  • Read
  • Contribute
  • Full Control
- All the Source and Target User Accounts must be ODFB provisioned along with a Microsoft E3-E5 license 
- Windows PowerShell ISE with all PnP packages, modules to be installed 
- Service Account of the Tenant Account to run the PnP script seamlessly
- CSV report with all the columns
UserEmail Folder Role SiteURL /personal/veera_kaveri_sample_com/Documents/New Joinees Tasks Read /personal/veera_kaveri_sample_com/Documents/BoxUpdate Contribute /personal/veera_kaveri_sample_com/Documents/Resumes Full Control
Use the below PnP script after configuring the below-higlighted areas and run it to have the above permission roles assigned to the above folder specific ODFB User Accounts.
  1. #Variables  
  2. $CSVPath = "D:\Bharat\ODFB\OnedriveUsers1.csv"  
  3. $ListName = "Documents"  
  4. #Get data from CSV  
  5. $CSVData = Import - Csv $CSVPath  
  6. #Iterate through each row in CSV  
  7. ForEach($Row in $CSVData) {  
  8.     Try {  
  9.         #Connect to SharePoint Online Site  
  10.         Write - host "Connecting to Site: "  
  11.         $Row.SiteURL  
  12.         Connect - PnPOnline - Url $Row.SiteURL - UseWebLogin  
  13.         Set - PnPFolderPermission - List $ListName - Identity $Row.Folder - User $UserAccount - AddRole $Row.Role  
  14.         DisConnect - PnPOnline  
  15.     }  
  16.     Catch {  
  17.         write - host - f Red "Error Adding User to Group:"  
  18.         $_.Exception.Message  
  19.     }  
  20. }  
Once the above script is run automatically, all the above-mentioned specific folders from their respective ODFB account get permission shared with the Role type mentioned to the User Email mentioned in the CSV rows.


The entire above process can be used for bulk user accounts permissions/collaborations to various ODFB Folders via PnP scripting by just passing the CSV report prepared in the above format. 
Sharing is Caring!!