Flow

Post A Message To Teams Chat

It’s long past time I had a new blog post. I’ve been focused so much lately on speaking opportunities and mentoring efforts that I haven’t posted much to my blog. So, here’s a new one I found useful a while back. Scenario In our scenario, we have a support email that gets emails when someone fills out a form on a website. The problem is that not much notice gets paid to the inbox and messages could go ignored for hours, or even days. We want to raise awareness of issues sooner so that appropriate actions can be taken. In this case, when we get an email, we’ll post a message into our Teams chat.

Thursday, April 25, 2024 | 4 minutes Read

How do I get started with Power Automate?

When I speak at conferences or user groups about Power Automate, one of the questions I get asked the most (aside from how to understand the confusing licensing), is how to get started with Power Automate, or the Power Platform in general. I thought I would write a post on the best ways to get started. Microsoft Learn In recent years Microsoft has invested heavily in creating free online training for a great many of their products. And most of that learning can be found on the Microsoft Learn site. The modules are the individual courses and the learning paths group several modules together into a cohesive learning track. For Power Automate, there are a few learning paths that I want to highlight.

Tuesday, February 6, 2024 | 5 minutes Read

Copilot for Power Automate

Tis the season of copilots! Everybody gets a copilot! Image by DCStudio on Freepik No, not that kind of copilot. I’m talking about the kind of copilot that runs off of AI and helps you to do some kind of task. You know, all the copilots that Microsoft has recently announced that are getting added to literally EVERYTHING.

Wednesday, November 29, 2023 | 7 minutes Read

Using C# and Power Automate To Sync An Outlook Calendar

There are some good tools out there for syncing your Outlook calendar to other calendars, especially for O365 or Outlook.com calendars. And they’re well worth the money for the good ones. But sometimes, in certain circumstances (such as if you have an on-prem exchange server that you can’t access from the cloud), you just need a quick and dirty tool to copy calendar events from a local Outlook instance to another calendar. That’s something you can do pretty quickly with a little C# and some Power Automate.

Friday, April 14, 2023 | 12 minutes Read

Automatically Adding Travel Time To Your Calendar

Even in this world of video meetings on Teams, Zoom, or wherever, there are still occasions when you need to travel to an onsite meeting somewhere. In these cases, it can be useful to automatically block out travel time before and after to ensure that your calendar reflects when you’re not going to be in the office. Power Automate makes it easy to add some travel time to your calendar.

Friday, March 10, 2023 | 7 minutes Read

Creating a Check-in Reminder App

This post was inspired by a recent tweet from Taylor Desseyn. app idea here.... a networking tool where instead of social media/linkedin you plug in a persons info and the app reminds you to check in with folks every 30 days — taylor desseyn (@tdesseyn) December 14, 2022 So what we’re going to do is create a pair of Power Platform tools to help us do exactly that. First, we’re going to need a Power App that we can use to maintain a list of people we want to keep in touch with. The second piece will create a scheduled flow in Power Automate that will run daily, determine who we need to catch up with, and then send us that list of people, along with quick links.

Tuesday, January 10, 2023 | 7 minutes Read

Using DALL-E and Power Automate To Create and Share Images

One big current trend, for good or ill, is AI-generated images. There are a number of services out there to generate these images and most of them have an API that you can hit against and which have various price points for that access. For our example today, we’ll use DALL-E 2, from OpenAI. Their introductory level gives you 50 free credits the first month and 15 free credits each month after that. One of the cool features of DALL-E 2 is that in addition to the ability to create new images from text suggestions, you can also upload an existing image and make edits to that based on your suggestions.

Friday, December 2, 2022 | 7 minutes Read

Function Friday - Chunk, Sort & Reverse

Power Automate has added a number of new expression functions and features recently. This time around I’ll take a look at three of those new functions: chunk, sort and reverse. Chunk The chunk function lets you break up strings or arrays into blocks of equal length. The format is as follows: chunk(<string>, <length>) chunk(<array>, <length>) The first parameter is the string or array you want to break apart. The second parameter is the length you want for each chunk. The result that is returned is an array of chunks. If the array or string doesn’t break apart evenly based on the requested length, the remainder will be in the last array element.

Friday, November 11, 2022 | 2 minutes Read

Video: AI Builder - Creating a Custom Image Recognition Model

This time I take you on a tour of using AI Builder in Power Automate to create a custom image recognition model to identify gaming dice.

Tuesday, November 8, 2022 | 1 minute Read

Video: An Intro to AI Builder on Power Automate

A new video this week. Bringing a quick introduction to the AI Builder feature on Power Automate.

Tuesday, November 1, 2022 | 1 minute Read

Function Friday - Xpath

Power Automate doesn’t give you any built-in methods for editing XML content, and that’s fine. XML is a devil-spawned file format that should die thousands of deaths and never see the light of day again. But, if you’re forced to use XML and need the ability to search and parse that XML in your flows, then Power Automate provides you a means for doing that search: XPath. The format is simple:

Friday, October 28, 2022 | 2 minutes Read

Error Handling with Power Automate

One of the things in Power Automate that doesn’t seem to get a lot of attention is the available features for error handling. So today we’re going to delve into the kinds of features and design patterns you can use to help your flows run smoothly, even when things go wrong. After Action Failure Branching The most basic feature available is after-action failure branching. Normally a flow passes from trigger to action to action and so forth in a more or less straight line. There are actions such as the condition action that let you take different branches based on some condition. But one of the features of Power Automate lets you use that same concept to take a different pathway based on whether the previous action succeeded (the default) or failed.

Wednesday, October 26, 2022 | 5 minutes Read