Azure Automation MS Flow Hybrid Workers SharePoint List upload CSV output
In this Blog I will discuss how to leverage SharePoint Lists as a front end using MS Flow to call Webhooks on Microsoft Azure Automation PowerShell scripts. These scripts execute via a hybrid worker to access On Premises resources. Results will be zipped and uploaded back to the SharePoint list.
Prerequisites
- Azure Automation Subscription and Account
- SharePoint Online / Site Collection
- On-premises resource (Windows 2016 server) configured as Hybrid Worker
- CredSSP needs to be enabled on hybrid Worker as Azure launches scripts as system account and some commands cannot use ‘-Credential’ )
- Modules needed on Hybrid worker from elevated powershell run “Add-WindowsFeature RSAT-AD-PowerShell and “Install-Module SharePointPnPPowerShellOnline”
- From Azure Import module from gallery SharePointPnPPowerShellOnline
Create SharePoint List
Create a SharePoint list as below this will be the input required for the script.… [Keep reading] “Azure Automation MS Flow Hybrid Workers SharePoint List upload CSV output”