sync-github-org.ps1

$ErrorActionPreference = "Stop"

$orgName = $env:GITHUB_ORG
$site = Get-Pnpsite
write-host "Syncing repositories for organization: $orgName with site $($site.Url) )"
$repos = gh repo list $orgName --json "name,visibility" --limit 999 | ConvertFrom-Json

$repoDictionary = @{}
# Populate the dictionary with keys in the format "orgName/repoName"
foreach ($repo in $repos) {
  $key = "$orgName/$($repo.name)"
  $repoDictionary[$key] = $repo
}

#get-pnplist "repositories"
Get-PnPListItem -List "Repositories" 
foreach ($repo in $repos) {
  #  write-host $repo.name
}

# Retrieve all items from the SharePoint list "Repositories"
$listItems = Get-PnPList "Repositories" -ErrorAction SilentlyContinue
if ($null -eq $listItems) {
  Write-Host "Missing list Repositories" -ForegroundColor Red
  throw "Sync repos failed - Missing list Repositories"
  return
}

# Iterate through SharePoint list items and compare with the dictionary
if ($listItems.ItemCount -ne 0) {
  

  foreach ($item in $listItems) {
    # Construct the key from SharePoint item fields
    $listOrgName = $item.FieldValues["OrganisationName"]  # Replace with your actual SharePoint field name
    $listRepoName = $item.FieldValues["RepositoryName"]  # Replace with your actual SharePoint field name
    $key = "$listOrgName/$listRepoName"

    if ($repoDictionary.ContainsKey($key)) {
      Write-Host "Match found for key: $key" -ForegroundColor Green
    }
    else {
      Write-Host "No match found for key: $key in the dictionary" -ForegroundColor Red
    }
  }
}
# Check for repositories in the dictionary that are not in the SharePoint list
foreach ($key in $repoDictionary.Keys) {
  $found = $false
  if ($listItems.ItemCount -gt 0) {
   
    $found = $listItems | Where-Object {
      "$($_.FieldValues["OrganisationName"])/$($_.FieldValues["RepositoryName"])" -eq $key
    }
  }
  if (-not $found) {
    Write-Host "Repository in dictionary but not in SharePoint: $key" -ForegroundColor Yellow
    Add-PnPListItem -List "Repositories" -Values @{
      "Title"            = $repoDictionary[$key].name + " ($orgName)"
      "OrganisationName" = $orgName
      "RepositoryName"   = $repoDictionary[$key].name
      "RepositoryType"   = $repoDictionary[$key].visibility
    }
  }
}

Environment Variables Used

| Environment Variable | |----------------------|| GITHUB_ORG |\n