This week, I ran into a problem where Power Automate corrupts the contents of an Excel file used in a flow. I knew I had seen this problem before, but I couldn’t remember what caused it. Since I don’t want to solve this problem a third time, it gets a blog post.
Read More »Power Automate Corrupts Excel File ContentsI’m currently helping to deploy Power Automate as a self-service automation tool. As part of that effort, I’ve been hosting weekly half an hour webinars where we build sample flows. So far we’ve worked with triggers and actions from Teams, Office 365 Outlook, Forms, SharePoint, Approvals, Excel Online, and User 365. And when you understand a little bit of the underlying architecture, these applications work together so well in Power Automate. But, there is almost always a little bit of extra context or explanation required. Earlier this week, I posted a write-up of the things you need to know for building flows with Forms. And now, I’m going to dive into what you need to know to update Excel with Power Automate.
Read More »How to Update Excel with Power AutomateI 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 DesktopExporting to Excel with IronPython from Spotfire desktop is pretty simple. I found a code snippet on TIBCO community that worked. However, it gets complicated… Read More »Exporting to Excel with IronPython