...
- First we need to make the team site
- Created a team using the "Professional Learning Community (PLC)" template calling it "PLDP 2021"
- Created two new document libraries "Staff Documentation Template" and "Staff Documentation"
- Copied template files Allison wants in each staff member folder into the "Staff Documentation Template" document library making sure the files sit in a folder with the current year.
- Modified the "PLDP Auto Create Staff Documentation Folder" flow which is stored in the svc_power.automate@bciqldedu.onmicrosoft.com account.
- We only need to change the variables where it states "CHANGE ME" to reference the new sharepoint site
- We also need to change the first step to reference the new PLDP site.
- After the flow has been modified, add a member and check to see if a folder has been created with special permissions.
- Now to add team members in bulk
- Created a *.csv with a single column called email
- Ran an sql query to get a list of current teachers and their emails adding them to the csv (also took note of the row count to double check at a later stage)
- Open Powershell
- Connect-MicrosoftTeams (use your office365 admin credentials)
- Get-Team -DisplayName "PLDP 2021", taing note of the GroupId
- Import-Csv -Path "YOUR_FILE_PATH" | foreach{Add-TeamUser -GroupId YOUR_TEAM_ID -user $_.email}
- I checked the number of members was equal to the number of rows returned by the sql query
- There is quite a delay between the adding of members and the triggering of the flow script so be patient
- If everything works you should have a folder for all the members you added in the Staff Documentation document library.
- All done
Archiving Previous PLD team site
- I've lost the flow to do this so when I find some time I will need to modify the current script to instead iterate over the folders in the Staff Documentation document library and set to read only
- Finally you can archive the site as normal.