Development

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

What's The Deal With ChatGPT

ChatGPT is all the rage right now. People are using it for all kinds of things, both good and bad. It seems every day there is a new article or story about it and how people are using it. And most of those stories have a fairly negative connotation to them. A mental health company experimented with using it to respond to patients seeking help. Universities and high schools are freaking out, or giving in, because students are using it to write papers. It even passed (barely) exams from business and law schools.

Tuesday, January 31, 2023 | 11 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

Turning Any JSON API Into An App

The Internet is fantastic. There are a seemingly infinite array of APIs available for people to use. Many of them are completely free and open to use in pretty much any way you want to. For example, NASA has a wide variety of things available through its public API. I use one of them in Power Automate with a custom connector to post their daily image to Twitter. For my contribution to this year’s C# Advent, I will demonstrate how easily you can implement any JSON-based API into a C# based application.

Tuesday, December 13, 2022 | 9 minutes Read

Advent of Code 2022

I’m participating in the Advent of Code again this year. We’ll see if I get further than I did last year, which was about halfway before I quit. You can follow my progress in my GitHub repo over here. As usual, my solutions are written in C#.

Wednesday, December 7, 2022 | 1 minute Read

Festive Tech Calendar 2022

By the way, I contributed to this year’s Festive Tech Calendar with a video on how to use low-code automation solutions like Power Automate and IFTTT to automate your holiday season. Check out the video here: There’s a lot of great submissions. Go check them out!

Tuesday, December 6, 2022 | 1 minute 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

An Overview of SQL Data Types

I have been asked to do more posts on databases, so I’m returning to the world of relational databases this week. I posted an introduction to databases a few months back that you can take a look at for a 10,000-foot view. The next logical step seems to be to take a look at the types of data available across the SQL standard and the more common relational database systems out there.

Tuesday, November 22, 2022 | 7 minutes Read

Function Friday - Chunk, Sort and 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