cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WillPage
Impactful Individual
Impactful Individual

Azure Automation CreateJob Error.

Hello,

I'm trying to start an Azure Automation job from PowerApps using the CreateJob function in the Azure Automation connector. The run book has one parameter of type String and runs on a Hybrid Runbook Worker.

 

My button's OnSelect does this (some data changed for privacy/security)

AzureAutomation.CreateJob("4166d727-4747-4bc1-99f2-8d5d08ee20a4", "AutomationRG1", "AutomationAccount",{runbookName:"Runbook1",properties:{parameters:{Script: PowerShell.Text}, runOn:"HybridGroup1"}})

In this case the single parameter of the runbook is called Script and the control that contains the script is called PowerShell. As you might have guessed, this is intended to run a line of powershell on an on-prem server.

 

This formula contains no errors as far as PowerApps is concerned, but when I try to run it, this happens:

 

Capture.PNG

 

Any idea what could be going on here? I suspect it's the runbook parameters not being in the correct format, but there isn't a lot of documentation about this online.

8 REPLIES 8
v-yuxima-msft
Community Support
Community Support

Hi @WillPage ,

 

Could you please check whether the parameter you passed is valid?

Could you please test that by Microsoft Flow?

 

Best Regards.

Yumia

 

WillPage
Impactful Individual
Impactful Individual

@v-yuxima-msftit works perfectly in Flow, so I have the option here to trigger a flow with the input being the powershell.text parameter. I have done this as a workaround for now, but I would rather start the runbook job directly within PowerApps.

Hi @WillPage ,

 

I am afraid I can’t reproduce your issue on my side.

Could you please create one new connection to test it again?

 

Best Regards.

Yumia

Hi @WillPage ,

 

Is the issue solved?

 

Best Regards.

Yumia

WillPage
Impactful Individual
Impactful Individual

@v-yuxima-msft I have stuck with using a Flow for this so I don't know if the connector in PowerApps works to trigger a job.

I've been trying to get this to work as well.  I can create a job without parameters, and that works fine.  But if I want to kick off a job that does have parameters, the ones I send aren't received by Azure Automation.  The documentation for this is next to non-existent, but based on the work you did and my own experiments, I'm pretty sure this is right at the Power Apps end:

Set(
    Result,
    AzureAutomation.CreateJob(
        "acbbba1c-d56e-4185-88cc-a0603e5def6d",
        "AzureAutomation",
        "PowerAutomateHelpers",
        {
            runbookName: "TinyTest",
            wait:true,
            properties: {
                parameters: {
                    Colour:"Blue",
                    Size:"Big"
                },
                runOn: ""
            }
        }
    )
)

 

 Has anyone had more luck than me on this?  I know I can use a Flow to do what I need to do, and that does work fine, but I'd like to do it purely within Power Apps if I can...

Hi evrebody !

 

unfortunatly i've try to do same thing and i failed on the same problem. The runbook is triggered but no input parmeters are visible or pass. Are they any news of that but or any document for this connector ? 

I experienced the same problem last year and opened a Microsoft support case. Result from that was that PowerApps does not support x-ms-dynamic-schema used by Automation and so parameters cannot be passed correctly.

I've opened a feeback for this : https://feedback.azure.com/forums/287593-logic-apps/suggestions/38841196-automation

Maybe they'll fix this if this gets upvoted.

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (21,875)