Blog

How to Fix Data Gateway Error in Power Automate

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 Automate

The Power of OCR in Power Automate Desktop

This 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 Desktop

Where Do You Write Expressions in Power Automate?

The 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?

How To Search PDFs for Keywords in Power Automate Desktop

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 Desktop

Use Scope in Power Automate To Avoid Rework

I’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 Rework

How to Build a Manageable Power Automate Solution

When 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 Solution

How to Fix A Common Shared Inbox Trigger Error

A 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 Error

How To Grab Data from PDFs with Power Automate AI Builder

I’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