Runing PowerShell script from Azure Automation via Workbook not working

Question

I hope someone here can help me, because apparently the guys behind the Azure chat support are clueless or have zero knowledge of what they are doing, it took two people to wast one hour to wonder around what the problem is. and then they send me to write this post and pray for someone to help! Amen!

Here is the story:

I'm trying to create an Azure Automation workbook to run Powers hell scripts again Power Platform such as get a list of all apps or flows, or connectors, or run script against SharePoint Online to submit a usage report for every site collection. Running everything locally in PS is working as expected, but in Azure not. After configuring the Credentials

and installing the required modules

Ruing for example this script which sends an email with all site collection storage usage, is not working

Same for PowerPlatform

In CMDLETS i dont see PowerPlafrom modules there on PnPOnline

any idea why cmds are not running in the cloud or what might be wrong here?

I follow instructions for both in this sites

https://www.sharepointdiary.com/2020/11/sharepoint-online-schedule-powershell-script-using-azure-automation.html

https://jamesyumnam.com/2021/08/31/run-powershell-for-powerapps-in-azure-runbook-and-send-the-outputs-to-power-apps-using-power-automate/