I’m writing this blog post because I ran into an error today that I will surely run into again and not remember how to solve. So, this post explains how to fix the error – “Could not connect to your data gateway”. Now, the next time I have this problem, I’ll Google it, and Google will show me my own writing. It’s kinda fun when that happens. Read on to learn more.
Read More »How to Fix Data Gateway Error in Power AutomateWhen I first started working with Power Automate, I misunderstood a few key concepts. If I got the wrong idea, then I am willing to bet other people are working under the same misconceptions. That’s why I wrote this post on four things I misunderstood about Power Automate. Read on to learn more about these common misconceptions.
Read More »4 Things I Misunderstood About Power AutomateAs you build larger and more complex cloud flows, you might want to keep certain parts of the flow going, even when other parts fail. Not only is this possible, but it’s very easy to set up. Read on to learn how to keep Power Automate running after a failure.
Read More »Resilient Cloud Flows: How to Keep Power Automate Running After FailureThis is my second post discussing a large PDF processing automation project. In the first post, I focused on how to bring data into PAD from Excel, transform that data from a table to a list, and remove nulls from the list. Now, I want to talk about how I use OCR in Power Automate Desktop to translate PDFs to text and look for specific keywords. Check out this post for the details.
Read More »The Power of OCR in Power Automate DesktopThe first tutorial I ever watched on writing expressions in Power Automate used the Compose action. So, I used Compose actions anytime I needed to write an expression until I ran into problems. But, Compose isn’t the only action you can use. This post explains three things you should take into consideration when choosing which action to use for writing expressions in Power Automate. Read on to learn more.
Read More »Where Do You Write Expressions in Power Automate?Many of my automation projects revolve around getting data out of PDFs. I’m working on a large PDF processing project right now that will generate several how-to posts. I think this will be a fun way to show the details of a large automation project. In the first post, I’ll focus on how to bring a column of keywords into PAD from Excel, transform that data from a table into a list, and remove nulls. This lays the groundwork to search PDFs for keywords using OCR, which I’ll dive into in the next blog. Check out this post for the details.
Read More »How To Search PDFs for Keywords in Power Automate DesktopI’ve run into circumstances in Power Automate where I need to delete an action holding other actions, like a Condition or Apply to each. You can’t delete those actions without deleting the contents. Copy and paste or drag and drop is an option sometimes, but this is slow. This post will show you how to use scope in Power Automate to solve this problem. Read on to learn more.
Read More »Use Scope in Power Automate To Avoid ReworkWhen we first began working with Power Automate solutions, we set up all solutions as unmanaged. This is not recommended, but we did it because learning new technology is hard. What we lacked was information on how to configure triggers and actions so that we could change things like SharePoint site links as solutions moved between environments. We’ve since learned how to work around this, but that’s the problem. It feels like a workaround. I want to show our solutions and also ask for some help. Both of these methods feel not quite right, and I can’t help but think there’s a better way. So, please give this a read, and tell me if there’s something I’m missing.
Read More »How to Build a Manageable Power Automate SolutionA user reached out to me for help this week with a very specific, but also unhelpful, error message she received while running a cloud flow that uses the trigger When a new email arrives in shared inbox. The error starts with – “As of May 6, 2020, shared mailbox support”. The source of the error lies not in the trigger. The problem is somewhere else. Read on to learn how to easily fix this shared inbox trigger error.
Read More »How to Fix A Common Shared Inbox Trigger ErrorI’ve been curious about AI Builder for a long time but didn’t have a good use case until our Land department needed to get information out of a PDF email attachment. I was able to easily build my first AI Builder model and incorporate it into a Power Automate flow. This post will walk thru all the steps for working with Power Automate AI Builder, and you can apply it to your own use case. Read on to learn more.
Read More »How To Grab Data from PDFs with Power Automate AI Builder