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.
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.
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.
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.
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.