This weThis week, I am working on a PowerAutomate Desktop flow that extracts data from a PDF. I need to extract numbers from a string. Rather than use regex, the Recognize Entities in Text action made this task a breeze. But, because it wasn’t without its quirks and challenges, I’m doing a write up on how to use it. Read on to learn more.
Read More »Extract Numbers from a String in PADLast week, I posted an article on how we are using Alteryx to Update SharePoint lists. While building out this solution, I ran into a problem where my SharePoint List input tool produced nulls. The SharePoint list was populated, but Alteryx was bringing in nulls. I wanted to elaborate on why this happens and how to fix it. Read on to learn more.
Read More »Alteryx SharePoint List Input Tool Produces NullsOver the last few months, I’ve been working with our IT group to automate the new hire process (process by which IT sets up a new person with hardware and software). The old process kicked off with (GASP!) an Excel spreadsheet sent to hiring managers. As you might imagine, that Excel form and process was slow and fraught with error. So, it’s getting a makeover using SharePoint, Power Automate, and Alteryx. This post will explain how I update SharePoint drop down lists using Alteryx tools. Read on to learn more.
Read More »Update SharePoint Drop Down Lists Using Alteryx ToolsThis is the 7th post in my series on Azure DevOps. This week, we will focus on Azure DevOps boards and the four options in the Boards menu – Work Items, Boards, Backlogs, and Sprints. This post will explain when you should choose one over another. Read on to learn more.
Read More »Use Azure DevOps Boards to Manage Analytics Assets
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 EmailMy last Azure DevOps post focused on the process. And if you are still stuck deciding which process to use, this post might help tip the scales. Do you need more work item types than the Basic process has to offer but Agile isn’t quite right? ADO provides a solution for this problem by allowing you to create work item types. This post will explain how to customize work item types so that you can get the most out of ADO. Read on to learn more.
Read More »How to Customize Work Item Types in Azure DevOpsRecently, 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 DesktopI 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
If you are following along in my series on Managing Analytics Assets with Microsoft Azure DevOps, you read the post – 5 Questions to Ask and Answer Before Setting Up Azure DevOps. In that post, I asked you to think about which work item types you want to work with and which process. This week, I’m diving into the details of the process. I’ll show you how to set it, change it, and we’ll talk about why you should clone processes in AzureDevOps. Read on to learn more.
Read More »Clone Processes to Unlock Customization in Azure DevOpsThis post explains how to restore a Spotfire DXP that has been deleted from the Spotfire library using the Spotfire database. Read on for instructions.
Read More »How to Restore a Spotfire DXP After Deletion