Skip to content

Julie Sebby

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

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

How To Build Power Automate Email Triggers With Multiple Strings

Our Automation team uses Microsoft Azure DevOps to track work. I wanted to build a Power Automate flow to monitor the team inbox, look for the words “Bug” or “Change Request” in email subjects, and then create an ADO bug or change request work item. This requires configuring an email trigger for multiple strings, which is a bit tricky. If you’ve never done it before, read on to learn more about Power Automate email triggers.

Read More »How To Build Power Automate Email Triggers With Multiple Strings

How to Fix the ‘Failed to Assume Control of Chrome’ Error in Power Automate Desktop

This week, I ran into a problem when I moved a solution from our DEV environment to QA. A PAD flow I was calling from Power Automate started failing with the error ‘Failed to Assume Control of Chrome’. When I ran only the desktop flow, it worked fine. When calling PAD from Power Automate, it didn’t work. Based on the reviews of the Power Automate extension in the Chrome store, this has recently become a common problem. Read on to find the solution that worked for me.

Read More »How to Fix the ‘Failed to Assume Control of Chrome’ Error in Power Automate Desktop