Forum Discussion

bluecoat2020's avatar
bluecoat2020
Copper Contributor
Mar 13, 2020

Unable to run across all users in Azure

Hi 

 

Just trying to get powershell to update sharepoint which is working if i use an individual account please see the current script

 

Get-Module SharePointPnPPowerShell* -ListAvailable| Select-Object Name,Version| Sort-Object Version -Descending


Install-Module SharePointPnPPowerShellOnline

Update-Module SharePointPnPPowerShell*

Install-Module AzureAD

Connect-AzureAD

$aaduser = Get-AzureADUser -ObjectId "User1@example.com"


Connect-PnPOnline –Url https://admin.sharepoint.com

if('' -ne $aaduser.facsimileTelephoneNumber -and $null -ne $aaduser.facsimileTelephoneNumber) {
Set-PnPUserProfileProperty -Account $aaduser.UserPrincipalName -Property 'fax' -Value $aaduser.facsimileTelephoneNumber

 

How ever when i try to get this to run across all users in azure it fails to work the following script is this 

 

Get-Module SharePointPnPPowerShell* -ListAvailable| Select-Object Name,Version| Sort-Object Version -Descending


Install-Module SharePointPnPPowerShellOnline

Update-Module SharePointPnPPowerShell*

Install-Module AzureAD

Connect-AzureAD

$aadusers = Get-AzureADUser -All $true


Connect-PnPOnline –Url https://admin.sharepoint.com

if('' -ne $aaduser.facsimileTelephoneNumber -and $null -ne $aaduser.facsimileTelephoneNumber) {
Set-PnPUserProfileProperty -Account $aaduser.UserPrincipalName -Property 'fax' -Value $aaduser.facsimileTelephoneNumber

 

Could anyone point me in the correct direction 

 

Thank you 

Azure Active Directory
sharepoint
  • Erick A. Moreno R.'s avatar
    Erick A. Moreno R.
    Mar 18, 2020

    bluecoat2020 I think you are missing a foreach so you can loop through each user in $aadusers. 

     

    Foreach($aaduser in $aadusers)

 {
  If('' -ne $aaduser.facsimileTelephoneNumber -and $null -ne $aaduser.facsimileTelephoneNumber)
   {   
    Set-PnPUserProfileProperty -Account $aaduser.UserPrincipalName -Property 'fax' -Value $aaduser.facsimileTelephoneNumber
   }
 }

    Regards

    Erick Moreno

  • Erick A. Moreno R.'s avatar
    Erick A. Moreno R.
    Iron Contributor
    Mar 18, 2020

    bluecoat2020 I think you are missing a foreach so you can loop through each user in $aadusers. 

     

    Foreach($aaduser in $aadusers)

 {
  If('' -ne $aaduser.facsimileTelephoneNumber -and $null -ne $aaduser.facsimileTelephoneNumber)
   {   
    Set-PnPUserProfileProperty -Account $aaduser.UserPrincipalName -Property 'fax' -Value $aaduser.facsimileTelephoneNumber
   }
 }

    Regards

    Erick Moreno

Resources