Power Automate: Running PowerShell Scripts
Run PowerShell scripts from your Flows using the Azure Automation connector.
Welcome to my Power Automate hub, where I share what I have learned building real cloud flows for work and for fun. If you have ever stared at a flow that almost works, this is where you fix it. You will find practical, hands-on guides that go beyond the basics and tackle the messy parts of automation. I cover advanced error handling patterns so your flows fail gracefully, and I dig into API rate limits and throttling, including batch operations and throttling mitigation, so your flows keep running when you scale up. I walk through building a website monitor from scratch, handling CSV files without losing your mind, and troubleshooting dynamic content when the values you expect simply are not there. My best practices for SharePoint across multiple environments save painful mistakes, and my approval workflow guide makes one of the most requested features easy to understand.
Run PowerShell scripts from your Flows using the Azure Automation connector.
Returns 1-366 for any date.
Returns the first non-null value from a list. Null if all are null.
Returns the highest value from numbers or arrays. Type mismatches break it silently.
Returns the remainder of a division.
Fires when a new email arrives in a shared Outlook mailbox.
Returns days.hours:minutes:seconds between two dates as a string.
Converts a timestamp from one timezone to another.