'Connect-PnPOnline' not recognized as a name of a cmdlet when running from Azure Runbook

[DavorSukeri]

Ok, I'm newbie with Azure Runbooks, but didn't think I will face problems this early. :D

So I'm trying to run PnP Powershell script to fetch user profile attributes from EntraID profiles and write them to SharePoint user profiles and schedule it to run weekly.

I have imported PnP PowerShell module (module version 3.1.0, runtime version 7.2.) to the Azure Automation account (and I can see it when browsing the imported modules) and assigned permissions to SharePoint to the Managed Identity like this:

• Add-PnPAzureADServicePrincipalAppRole -Principal "managed identity object id here" -AppRole "Sites.FullControl.All" -BuiltInType SharePointOnline.

However when I'm testing my script I get this:

Connect-PnPOnline -URL https://xxx.sharepoint.com/ -ManagedIdentity

Then I tried to add Import-Module PnP.PowerShell before the Connect-PnPOnline cmdlet and I get this:

However if run Install-Module -Name PnP.PowerShell before the Connect-PnPOnline cmdlet I don't get those errors, but surely I'm not supposed to install module everytime I run the script.

So two questions:

1. Is it necessary to include Import-Module PnP.PowerShell before the Connect-PnPOnline cmdlet (since the module is already imported to the Automation Account) ?
2. If yes, do I really need to update PowerShell version from 7.2. to 7.4.6 so that I can Import-Module PnP.PowerShell ? I'm not even sure yet how that is done....am I required to update PowerShell version globally to version 7.4.6 or what...

[DarrenDuvallGIT]

In a potential application of Cunningham's Law
In your automation environment remove the PnP.PowerShell module.
Use the manual download option on the link and rename the file pnp.powershell.zip
https://www.powershellgallery.com/packages/pnp.powershell/2.12.0
Then upload this module to your environment

[DavorSukeri]

Thanks, but eventually I managed to get it working by creating Runtime Environment with PowerShell 7.4 and imported PnP PowerShell 2.12 module in it.

PnP PowerShell 3.x requires PowerShell 7.4.6 and Azure Automation doesn’t support that yet.