Power Automate Desktop

Trigger Alteryx Workflows With Email

I bet that headline got your attention, and you’re probably saying, “That can’t be done.” Actually, it can….if you combine technologies. While I love being able to schedule workflows from the Alteryx gallery, there are many other mechanisms I would like to use to kick off Alteryx workflows, like receiving an email. Alteryx doesn’t allow this, but Microsoft Power Automate does. Combine that with the ability to call Alteryx from Power Automate Desktop and you have the ability to kick off workflows with email. Read on to learn more.

Read More »Trigger Alteryx Workflows With Email

How to Convert XLS to XLSX with Power Automate Desktop

Recently, a user asked me to automate a process where she received an email with an Excel attachment. She needed to grab data from that attachment and put it into a different spreadsheet. This should have been a super easy task, but the attachment was in .xls format (Microsoft 1997-2003). We couldn’t change the format, and apps DO NOT play well with this format. So, I used Power Automate Desktop to convert it. Read on to learn how to convert xls to xlsx with Power Automate Desktop.

Read More »How to Convert XLS to XLSX with Power Automate Desktop

How to Update an Excel File with Power Automate Desktop

I started a new role in October with our RPA (Robotic Process Automation) team, which involves working with Microsoft Power Automate and Power Automate Desktop (and still Alteryx). I’ve been learning the ropes the last few months and want to show an example of how you can use these tools to automate small but mundane tasks, like extracting a value from email and updating an Excel spreadsheet. This post will explain how to update an Excel file with Power Automate Desktop.

Read More »How to Update an Excel File with Power Automate Desktop