Trigger a Power Automate Flow from PowerShell script

Lately I was wondering how I can connect from a PowerShell script to a MS flow? Is this possible and how I can transfer variable(s) information from the script towards the Flow and use these values. In the simple blog example I will transfer variable values towards a MS Flow.

What is needed?

PowerShell script.

<#
    PowerShell code above, or below can be anything. 
    In this example, the values are manual set and variables 
    have been random chosen.
#>
# Variables
$RandomID = "1285"
$Hostname = "SRV-DEMO-01"
$HostStatus = "Running"

<#
    Define Job Parameters.
    ----------------------
#>
$JobUriParameters = @(
    @{ Name = 'ItemID'; Value = $RandomID},
    @{ Name = 'HostName'; Value = $Hostname},
    @{ Name = 'HostStatus'; Value = $HostStatus}
)
#Convert to JSON parameters
$MSFlowParam = ConvertTo-Json -InputObject $JobUriParameters

PowerShell code, containing the variable values and first step to create the JSON output file that will be sent via the API call to the MS Flow, via a POST operation.

Building the Flow?

We will start the MS Flow with the following trigger ” When a HTTP request is received “. This is a PREMIUM connector and therefore we need a minimum PLAN 1. We will receive the HTTP POST URL, when the Flow will be saved for the first time, currently link is not available.

Adding a JSON schema based on the information that will be sent from PowerShell to MS Flow.

PS> 
<#
    PowerShell code above, or below can be anything.
    In this example, the values are manual set and variables
    have been random chosen.
#>
# Variables
$RandomID = "1285"
$Hostname = "SRV-DEMO-01"
$HostStatus = "Running"

<#
    Define Job Parameters.
    ----------------------
#>
$JobUriParameters = @(
    @{ Name = 'ItemID'; Value = $RandomID},
    @{ Name = 'HostName'; Value = $Hostname},
    @{ Name = 'HostStatus'; Value = $HostStatus}
)
#Convert to JSON parameters
$MSFlowParam = ConvertTo-Json -InputObject $JobUriParameters
$MSFlowParam
#Result output
[
    {
        "Value":  "1285",
        "Name":  "ItemID"
    },
    {
        "Value":  "SRV-DEMO-01",
        "Name":  "HostName"
    },
    {
        "Value":  "Running",
        "Name":  "HostStatus"
    }
]

Copy the result output and paste in as a sample JSON payload. This will generated the required JSON schema.

As second step we gone filter the array to get the values of each variable that has been propagate by the PowerShell Script.

Completing the PowerShell Script by adding the Invoke-WebRequest, will make an API call to MS Flow and sends the information via a JSON – file.

<#
    PowerShell code above, or below can be anything. 
    In this example, the values are manual set and variables 
    have been random chosen.
#>
# Variables
$RandomID = "1285"
$Hostname = "SRV-DEMO-01"
$HostStatus = "Running"

<#
    Define Job Parameters.
    ----------------------
#>
$JobUriParameters = @(
    @{ Name = 'ItemID'; Value = $RandomID},
    @{ Name = 'HostName'; Value = $Hostname},
    @{ Name = 'HostStatus'; Value = $HostStatus}
)
#Convert to JSON parameters
$MSFlowParam = ConvertTo-Json -InputObject $JobUriParameters

<#
Gets content from a web page on the Internet via 
Default,Delete,Get,Head,Merge,Options,Patch,Post,Put,Trace
#>
Invoke-WebRequest `
    -Uri 'https://xxxx-xx.westeurope.logic.azure.com:443/workflows/axxxx34xxxxe45xxxxx258cxxxxc487e/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=xxxxxxxiVmqoHHuON0xxxxhX89ei3ybFSlsxxxxsyAY' `
    -ContentType "application/json" `
    -Method POST `
    -Body $MSFlowParam

Result of the data operations when filtering the array on the name – value. This gives us the possibility to split the array in smaller array pieces.

So the answer is YES. We can transfer data from a PowerShell script towards Microsoft Flow. How cool is that!