Refer azure runbook activity output in PowerShell expression
When you are creating a runbook with multiple activities, often you will encounter the need of referring an activity output in another activity. Thankfully, all the activities in the runbook can refer another activity in the parameter pane. However, when you have a piece of powershell script which needs to use the same, you don’t have a straight forward way to use it. A macro kind of option like what we have in Visual Studio would be great but as far now we are left with the mercy of our knowledge.
And so the script goes something like below.
$($ActivityOutput[`”GetSqlDbInfo`”])