Skip to content

Instantly share code, notes, and snippets.

@joerodgers
Created February 20, 2025 15:19
Show Gist options
  • Save joerodgers/e3904dbe0f0295a9f8f3a572c2cf8a71 to your computer and use it in GitHub Desktop.
Save joerodgers/e3904dbe0f0295a9f8f3a572c2cf8a71 to your computer and use it in GitHub Desktop.
# requires Microsoft Forms > Application > Forms.Read.All
Connect-PnPOnline -Url "https://$env:CDX_TENANT-admin.sharepoint.com" `
-ClientId $env:CDX_CLIENTID `
-Thumbprint $env:CDX_THUMBPRINT `
-Tenant $env:CDX_TENANTID `
-ErrorAction Stop
$userObjectId = "a8734c7e-a19b-41c6-b384-........"
$formId = "pVQHEDt5kk....."
$uri = "https://forms.office.com/formapi/api/{0}/users/{1}/light/forms(`'{2}`')/responses?`$select=submitDate,responder,answers" -f $env:CDX_TENANTID, $userObjectId, $formId
$accesstoken = Get-PnPAccessToken -ResourceUrl "https://forms.office.com/.default"
$response = Invoke-RestMethod -Method Get -Uri $uri -Headers @{ authorization = "Bearer $accesstoken" }
$response.value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment