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
A few months ago, I wrote a post on how to find all of the IDs you might need to work with SharePoint in Power Automate. I recently needed to find a ids for teams to use in Power Automate. So, this post explains how to get the team and channel ids. Read on to learn more…Read More »Finding Team and Channel Ids for Use in Power Automate
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
Power Automate offers three mechanisms for triggering flows. One of those mechanisms is a manual trigger pushed from either the mobile app or the Power… Read More »How to Trigger Power Automate Flows From Teams
Learning Power Automate is a journey. First, you learn about dynamic content, triggers, and actions. Then, you build a few cloud flows. You’ll eventually reach a point when the process you are automating requires more than one trigger or the process needs to go thru a formal development cycle, moving thru multiple environments (QA, UAT, PRD). This is when you need to learn about Power Automate solutions. Read on to learn more.Read More »What Are Power Automate Solutions?
Earlier this week, I wrote about working with date and time in Power Automate. I explained how to use 4 functions to return the month and year from the current date. But, the values come back as numbers. What if you want the name of the day of the week or the month, like Monday or January? Returning names in Power Automate takes different expressions and the use of arrays, but it’s easy! Read on to learn how and leave a comment explaining how you’ve used arrays in Power Automate.Read More »Make Finding the Name of Day or Month in Power Automate Easy!
My most recent Power Automate builds have included a lot of work with date and time data. I thought this would be an excellent addition to the Getting Started with Power Automate series I started a few months ago. This is also a great starting place to learn about expressions. Read on to learn more about four functions that will help simplify working with date and time in Power Automate.Read More »4 Functions to Simplify Date & Time in Power Automate
Getting the current date and time is a common task I’ve performed in all of the applications I’ve worked with. However, I’ve always been able… Read More »What is UTC and why is it important in Power Automate?
This week, I ran into a problem where Power Automate corrupts the contents of an Excel file used in a flow. I knew I had seen this problem before, but I couldn’t remember what caused it. Since I don’t want to solve this problem a third time, it gets a blog post.Read More »Power Automate Corrupts Excel File Contents
Since I started working with Power Automate, I’ve needed to find various SharePoint IDs. The first time this happened, I wrote a post. Since then, I’ve needed to look up a couple of other IDs, so here’s a more comprehensive explanation. If there are more IDs I need to find, I’ll just update this post. I was surprised to find the advice online for this to be mixed and at times inaccurate, so I thought this was worth writing. Read on to learn more. You might want to bookmark this one.Read More »How to Find SharePoint Site, List, and View IDs for Use in Power Automate