Creating a Powershell step in Flow Designer

[Shaun Hillier]

I am trying to run a simple PowerShell script on a MID Server when a certain Catalog item is created.

We have opted to use Flow Designer and Integration hub to do this.

I have created a simple flow and a new Action to run my PowerShell script (Created as a MID Server Script File).

I can't work out what to use for my Connection Allias. I have a Service Account set up to run the PowerShell and have the specific MID Server logging in as this account.

I have tried setting the Host as the MID Server and the Service Account details as a Windows credential but every-time I test the flow I get "Unable to load connection with alias ID: ***** "

What am I missing here?

[richardbrounste]

Hi Shaun:

I'm using the Flow Designer with Integration HUB to run a PowerShell script with a Credential Alias.

I don't know how you setup your Credential Alias so I will describe what I did:

I created the Credential Alias entry under IntegrationHub -> Connection & Credential Aliases.  My Alias name is "SuperAdmin".

I then went into the Orchestration -> Credentials and had to add the column for "Credential Alias" in the view.  I selected my "SuperAdmin" as the alias to be associated with my Orchestration Credential and saved it.  Going back to the Credential Aliases, I saw that credential listed under the "SuperAdmin" alias.

[Shaun Hillier]

Thanks for the response. It sounds like your using Orchestration Custom Activity, and not the Flow designer step, which is ok it should be the same.

What Credentials did you store, was it a Windows account that can log into the Host?

It the setup for the Credentials and Connection Allias I don't understand.

[Shawn Gienow]

Hey Shaun,

For mine, I needed to create credentials for the account I want to "run" the PS.  That was a windows credential.

Then needed to add a credential alias to that, and then created a connection & credential alias.

Set the connection as a connection URL to 127.0.0.1, give it a connection alias, and that should be it.