PowerShell script as an intermmediate step

[ChrisParker]

I'd like to be able to send the output of one step into a PowerShell script and make the returned object (and its key/value pairs) available to the next step.

Such power!

[NateGarcia]

Having the ability to call a powershell script as an action and being able to feed its output back into the flow would be amazing. You could complete so much outside of flow that would not need to have other custom apps created for them.

[Loic]

I'd like to run powershell script through the gateway and be able to get the script output 

[sergeluca]

this is possible today, read my blog post https://sergeluca.wordpress.com/2017/12/01/upload-and-run-a-remote-powershell-script-from-microsoft-...

[Loic]

Hi Serge, this is nice but was hopping a more generic way (ie : no need to create a file watcher on each host where you want to run the script) 😉

[sergeluca]

By design we need to install the the Data Managemet gateway on each host, anyway 🙂 

[BobWeinerJr]

I need to trigger a process that reads and imports data from excel to Sql Server when a file is updated.  Can this be managed with MS Flow?

[sodhir2]

It will great if there was an ability to execute power shell script.

[Yasmina]

it will great, as i need to run powershell command periodically to get details about office365 usage and run flow based on result, it would be great to full automate the process.

[sw138]

yeah, I want to be able to set up new Surface Hub accoutns this way:

User submits a form with the pertinent details, those details go to a SharePoint list, details from that list gets exported to a a script. Script gets executed: BOOM Surface Hub account created.

[ChrisWharton22]

There is a way to do this but it requires some automation features in Azure - there is a free tier for executing upto 60 minutes of operations per month.  Create a Runbook in Azure (enter your powershell script)  call the Runbook from flow and enter any parameters.    In the example below, i have created a powerapp to enter some information which is then sent to the automation work engine step and then creates an item in sharepoint after the site is created successfully.