Capture Powershell Output in Email Step

I have a powershell script to execute an exe to run sql scripts. I’d like to take the output of that powershell script and include it in my email so that I can see if all the scripts ran successfully. Does octopus capture the output in a variable for me to use?

Hi,

Thanks for reaching out! From your Powershell script step, you could capture the output of the console app into a Powershell variable, and then use the content of that variable to create an Octopus Variable that could later on be used in your email step (see link below)

Hope that helps!

Dalmiro