Power Automate

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

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?

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

How to Prevent Email Triggers from Firing in Power Automate

Last week, I wrote a blog post that explained how to configure an email trigger for multiple strings. In other words, kick off the Power Automate flow when an email arrives with “Bug” or “Change Request” in the subject. I posted it on LinkedIn, and someone responded with a comment that showed how the same settings can be used to prevent email triggers from firing, such as when people reply to or forward an email with your subject filter. I love this use case, so I thought I’d explain it in its own post. Read on to learn more.

Read More »How to Prevent Email Triggers from Firing in Power Automate

How To Grab the File Extension of an Email Attachment

I’ve been working with email triggers a lot lately. Most of my use cases involve grabbing attachments from email and saving them on a shared drive. This is simple and easy to do, but….what you might not know about Power Automate is that it interprets any image in an email as an attachment. And, to avoid processing unnecessary files, the cloud flow should include a condition that looks at the file extension. So, how do you grab the file extension of an email attachment? It’s easy. Read on to find out.

Read More »How To Grab the File Extension of an Email Attachment