How to Start a PowerShell Runbook by Webhook in Azure Automation Using Power Automate

Introduction

• Create an Automation Account
• Create Credential Asset – To store the credentials which will be used by PowerShell for authentication.
• Import PowerShell Module – Import Microsoft Teams PowerShell Cmdlets module in order to access Teams Cmdlets.
• Create PowerShell runbook – Script to create a new team
• Test and publish the runbook

Design Flow

• Create a SharePoint list – Custom list with default Title field and it contains the Team name that needs to be created.
• Create PowerShell runbook
• Create a webhook
• Create a flow in Power Automate– It gets triggered when an item is created in SharePoint list and call the HTTP action.
• Test the flow

Create a SharePoint list

1. Navigate to SharePoint Online site.
2. Create a custom list named as Microsoft Teams Requests.
   
   
   

Create PowerShell runbook

1. Navigate to Automation account.
2. Under Process Automation, click Runbooks.
   
   
   

3. Click Create a runbook.
   
   
   

4. Enter the required details and click
   
   
   

5. In the Edit pane, copy and paste the below script.
   
   1. Param
   2. (
   3. [Parameter (Mandatory = $false)]
   4. [object] $WebhookData
   5. )
   7. # If runbook was called from Webhook, WebhookData will not be null.
   8. if ($WebhookData) {
   9. # Collect properties of WebhookData
   10. $WebhookName = $WebHookData.WebhookName
   11. $WebhookHeaders = $WebHookData.RequestHeader
   12. $WebhookBody = $WebHookData.RequestBody
   13. $Input = (ConvertFrom-Json -InputObject $WebhookBody)
   14. }
   15. else
   16. {
   17. Write-Error -Message 'Runbook was not started from Webhook' -ErrorAction stop
   18. }
   20. # Get the team name from JSON input
   21. $teamName=$Input.TeamName
   23. # Get the credential from Automation
   24. $credential = Get-AutomationPSCredential -Name "TeamsAdminCredential"
   25. $userName = $credential.UserName
   26. $securePassword = $credential.Password
   28. $psCredential = New-Object –TypeName System.Management.Automation.PSCredential –ArgumentList $userName, $securePassword
   30. # Connect to Microsoft Teams
   31. Connect-MicrosoftTeams -Credential $psCredential
   33. # Create a new Team
   34. New-Team -DisplayName $teamName
   36. # Disconnect from Microsoft Teams
   37. Disconnect-MicrosoftTeams

6. Click Save.
   
   
   

7. Publish the runbook.
   
   
   

8. Runbook successfully published, as shown below.
   
   
   

Create a webhook

1. Navigate to Automation account.
2. Under Process Automation, click Runbooks.
3. Click the newly created runbook (named as CreateTeam).
4. Click Add webhook.
   
   
   

5. Click Create new webhook. Enter the name and copy the URL (You might be able to see this once the webhook has been created). Click Ok.
   
   
   

6. Click Parameters and run settings and click Ok. Click Create. Webhook created successfully.

Create a flow in Power Automate

1. Navigate to the Power Automate portal.
2. Create a new flow and select the trigger as When an item is created. Enter the name for the flow and click Create.
   
   
   

3. Select the site address and list name for the trigger, as shown below.
   
   
   

4. Add HTTP action.
   
   
   

5. Enter the webhook URI which was copied while creating the webhook. Add the JSON to the Body, as shown below.
   
   
   

6. Save the flow.

Test the flow

1. Navigate to SharePoint Online list. Create a new item in the list.
   
   
   

2. Under Run history, you can see the last run and click on it. Flow ran successfully, as shown below.
   
   
   

3. HTTP Request:
   
   
   

4. From the body, copy the Job Id which will be useful in case if you need to find the status of the job.
5. Navigate to Automation Account in Azure Portal.
6. Under Process Automation, click Runbooks.
7. Click the newly created runbook (named as CreateTeam).
8. Under Resources, click Jobs and you can see the job status. You can also search the job based on the Job Id which can be copied from the flow HTTP action (Outputs -> Body).
   
   
   

9. Click on the job to see all the required details.
   
   
   

10. The team was created successfully, as shown below.
    
    
    

Summary