This script will create the service principal in Azure AD and will be used for Azure Automation

CreateServicePrincipal.ps1

#This function creates an Azure AD Service Principal
function CreateServicePrincipal {
  param($username, $password)

	$credproperties = @{
		StartDate = Get-Date
		EndDate = Get-Date -Year 2024
		Password = $password
  }
  $cred= New-Object Microsoft.Azure.Commands.ActiveDirectory.PSADPasswordCredential -Property $credproperties
  $sp = New-AzAdServicePrincipal -DisplayName $username -PasswordCredential $cred
}