this blog post describes how to a a custom module into Azure Automation.
https://blog.kloud.com.au/2018/05/23/creating-your-own-powershell-modules-for-azure-automation-part-1/
Maybe this helps to get the SCCM module imported into Azure Automation.
The PowerShell runbook is planned to be executed by Azure Hybrid Workers (on-premises)? If so, you don't need the module in Azure Automation. Just install the module on every Hybrid Worker. This should work, at least it did here with the SCSM SMLets cmdlets.
----------
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Andreas Baumgarten