Script works in Powershell ISE but not in using Command Line (Administrator)

Question

Hi

I am trying to download from documents from Sharepoint to a windows folder. The scrip works in ISE but not when running from the command line (using administrator). The script is:-

$SharePointSiteURL = "https://sueryder.sharepoint.com/sites/Document Hub/H%26SC%20Performance%20Management%20Data/"
$O365ServiceAccount = "sharepoint.download@xyz .org"
$O365ServiceAccount1 = "xyz"
[SecureString]$Secure = ConvertTo-SecureString $O365ServiceAccount1 -AsPlainText -Force
[System.Management.Automation.PSCredential]$PSCredentials = New-Object System.Management.Automation.PSCredential($O365ServiceAccount, $Secure)

Add-PnPStoredCredential -Name $SharePointSiteURL -Username $PSCredentials.UserName -Password $Secure

Connect-PnPOnline -Url $SharePointSiteURL -Credentials $PSCredentials

Answer 1

The script works in ISE but not when running from the command line (using administrator).

I might be off base with this (and maybe thinking a little too far "out of the box"), but I'm curious about the above statement.

Specifically, what do you mean by "using administrator"? Are you using the same domain account to run Powershell_ISE.exe and Powershell.exe? Are both processes being run with or without UAC elevation? IE "run as administrator"? Are you running both processes interactively? (That is; not using task scheduler.)

If you launch a new instance of Powershell_ISE.exe and execute the .ps1 file from the PS prompt, does it work or fail? Don't load the script into the editor, just run the .ps1 from the prompt.

Or from the ISE prompt run a sub instance of Powershell.exe and have it run the script. Like I did with get-host.

PS C:\WINDOWS\system32> (Get-Host).Name
Windows PowerShell ISE Host

PS C:\WINDOWS\system32> powershell.exe "(Get-Host).Name"
ConsoleHost

PS C:\WINDOWS\system32> 

Answer 2

It certainly looks like it could be the solution. However my release says "SharePointPnPPowerShellOnline 3.26.2010.0".

Not to worry I have a solution now. many thanks for your help