Forum Discussion

AndrewX's avatar
AndrewX
Iron Contributor
May 18, 2022

Start an Automation Runbook with Parameters from a Power App Button

I have the following code for a Button OnSelect function.  The Azure Automation Runbook has 3 required paramters with matching names to the record below.

 

When i click the button, the automation runbook fails because "Cannot process command because of one or more missing mandatory parameters:"

 

Any idea how to pass parameters to a runbook in a PowerApp.  PS.  I want to do this directly in a PowerApp button, NOT trigger a Flow AND THEN trigger a Runbook.

 

Set(AZAutomation,AzureAutomation.CreateJob(
    "nnnn-nnnn-nnnn-nnnn",
    "nnnn",
    "nnnn",
    {
        runbookName:"MailboxManagement",
        wait: true,
        body: JSON(
            {
                param1: ComboBox1.Selected.UserPrincipalName,
                param2: ComboBox2.Selected.UserPrincipalName,
                param3: DropDown1.SelectedText.Value
            }
        )
    }
))

 

PowerApps

4 Replies

Sort By
  • AndrewX's avatar
    AndrewX
    Iron Contributor
    Jul 14, 2022

    AndrewX Nicol Hanekom BasedRaj115 

     

    In the end, calling AZ Automation directly from the AZ Automation Power App Connector did not work, instead you can do the following.

    1. Use a flow

     2. Create a Custom Connector and use that (Recommended)

     

     or option 3. Which is what I have done, I  use Azure Functions and a Custom Connector

    • SeanC1155's avatar
      SeanC1155
      Copper Contributor
      Jul 11, 2024
      If anyone comes across this I was able to get this working. This post had the closest working example I could find. I added in properties: { } and the parameter was passed in as an 'UntypedObject'... ParseJSON(JSON({ param1: "SomeText" }))

      Set(AZAutomation,AzureAutomation.CreateJob(
      "nnnn-nnnn-nnnn-nnnn",
      "nnnn",
      "nnnn",
      {
      runbookName:"WorkingRunbook",
      wait: false,
      properties: {
      parameters: ParseJSON(JSON({ param1: "SomeText" })),
      runOn: ""
      }
      }
      ))

Resources