automation
-
Three Ways Schedule or Repeat Power Automate Desktop Flows with Windows Task Scheduler
Power Automate can use scheduled cloud flows to launch desktop automations. But what if you want to trigger the desktop flow locally? Here’s how to schedule or setup recurring Automate Desktop Flows with Windows Task Scheduler.
-
Simple CSV Parsing in Power Automate Cloud Flows
Even with a wide breadth of shared knowledge online, it can be surprisingly difficult to handle CSV files in Power Automate without costly premium services. Here’s how I managed to get it done with in-the-box tools.
-
Automating a Manual Order Fulfillment Task
This flow watches for particular emails to arrive, then makes decisions about details inside the attachments, logs certain aspects to a spreadsheet and emailing a supplier.
-
Split a PDF at Each Change in Header
A colleague of mine receives a detailed 600-page PDF commission report showing all orders placed in each of many accounts, similar to a phone bill showing charges under each line of service. How can I split the PDF into a separate file for each account?
-
Saving My Entire Site as a PDF ebook
How hard would it be to use Power Automate to fetch every post I’ve published and save it as a single PDF ebook file? Let’s find out.
-
Merging Excel Data to Email Messages
This post explores some of my solutions for sending personalized emails by iterating through an Excel table and sending an email for each row.
-
I think Power Automate Forgot Lefthanded Users Exist
I think Microsoft forgot left-handed users exist. Power Automate can’t handle swapped mouse buttons.
-
Refresh Many Excel Reports Automatically
Today I’d like to share a little homemade tool I whipped up to save me the tedious yet trivial recurring chore of opening several Excel workbooks and clicking the Refresh button inside each one.
-
Automating IE With PowerShell to Capture Screenshots
My, browsers come and go so quickly these days. Microsoft’s replacement for Internet Explorer is already shuttered now that they’ve joined the Chromium open-source project to produce Edge using that codebase. And as much as I’m all here for that, it can still be handy to have Internet Explorer–especially when you can control it programatically […]
-
Automating Internet Explorer with PowerShell for Data Entry
IE is dead to the world, but it’s still kickin’ in Windows 10. Here’s a great way to use the browser to automate some redundant tasks and score back some extra time.