Skip to content

Instantly share code, notes, and snippets.

@Zerg00s
Created June 5, 2021 00:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Zerg00s/71fe6699fea97f32a88751adf487cb1c to your computer and use it in GitHub Desktop.
Save Zerg00s/71fe6699fea97f32a88751adf487cb1c to your computer and use it in GitHub Desktop.
Populate SharePoint Online Tasks list
# ===============================================
# Populate Tasks list
# ===============================================
$list = Get-PnPList TasksList
$users = Get-PnPUser
$users = $users | Where-Object {$_.Email -ne ""}
$Statuses = @("Not Started","In Progress","Completed","Deferred","Waiting on someone else")
$now = Get-date
$Priorities = @( "(1) High","(2) Normal","(3) Low")
Connect-PnPOnline -Url https://contoso.sharepoint.com/sites/ClassicTeam -UseWebLogin
for($i = 0;$i -le 6000; $i++){
Write-Host $i / 6000
$user = Get-Random -InputObject $users
$Status = Get-Random -InputObject $Statuses
$Priority = Get-Random -InputObject $Priorities
$suppress = Add-PnPListItem -List $list -Values @{
Title="Task $($i)"
AssignedTo = $user.Email
PercentComplete = $i
Body = "Description $($i)"
Status = $Status
DueDate = $now
Priority = $Priority
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment