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.
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?
It will great if there was an ability to execute power shell script.
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.