Creating a Custom Connector - Part II

Saturday, Nov 20, 2021 by Barret Power Automate, flow, connectors

Photo by Daria Shevtsova from Pexels In part I of this post, I demonstrated how to create a custom connector. Now, we’ll follow up with a short post on how to use that custom connector in a flow. Creating Our Flow We’ll start by creating a scheduled flow. We’ll run our flow at 9AM Eastern every day. Now we’ll need to create an action based on our custom connector. There are a couple ways you can do so.

Continue Reading

Creating a Custom Connector - Part I

Wednesday, Nov 17, 2021 by Barret Power Automate, flow, connectors

Photo by Daria Shevtsova from Pexels For those with the higher tier licenses, along with being able to use the premium connectors, you also have the ability to create your own custom connectors that you can use to connect to just about any API on the web. For our fun project this time, we’re going to take the next two blog posts to create a custom connector that makes use of the NASA public APIs in order to grab the Astronomy Picture of the Day (APOD) and then we will create a flow that runs daily to post that day’s picture in a tweet to our Twitter feed.

Continue Reading

AI Builder: Training an Object Recognition Model

Sunday, Nov 14, 2021 by Barret Power Automate, flow, Summit NA, AI Builder

Last time we looked at identifying information on an invoice. Another feature AI Builder in Power Automate offers is the ability to recognize objects in an image. This time we’re going to look at how to set up AI Builder to identify dice. It should be noted that AI Builder is a paid add-on to Power Automate and does incur an extra cost to use. However, a free trial is available.

Continue Reading

AI Builder: Training a Invoice Processing Model

Sunday, Nov 7, 2021 by Barret Power Automate, flow, Summit NA, AI Builder

One of the more complex features of Power Automate is the ability to train it to pull data out of scanned images of invoices and automatically import the information. I included a walkthrough of how to get started with this feature in my recent conference talk at Summit NA 2021, but I felt it would be beneficial to provide it in blog form as well. It should be noted that AI Builder is a paid add-on to Power Automate and does incur an extra cost to use.

Continue Reading

New Blog, New Style

Sunday, Nov 7, 2021 by Barret site

I’ve gotten completely fed up with the hassle of trying to get GatsbyJS to work on Windows Subsytem for Linux (WSL). It just doesn’t work and I’ve wasted so many hours just trying to get a site to build. I had initially changed my site to use Jekyll, but saw people referring to Hugo on Twitter. And Hugo will run natively in Windows. So I spent the last two days redoing my blog with Hugo.

Continue Reading

Community Summit 2021 Demos

Tuesday, Nov 2, 2021 by Barret conferences, Summit NA, flow

Photo by Tara Winstead from Pexels I delivered two presentations at Community Summit NA 2021. As part of that, I provided a number of demos. Below you can find some of the flows I used in my presentation. None of them are all that complicated, but could be used as simple starter templates. Power Automate for Dynamics Users Posting a Blog Post to Twitter and LinkedIn This demonstrates how to watch an RSS feed for new blog posts and post messages to Twitter and LinkedIn with links to the post.

Continue Reading

Power Automate Desktop

Sunday, May 23, 2021 by Barret Power Automate, desktop, PAD, RPA, robotic process automation, flow

Photo by Mateusz Dach from Pexels This time round I’m going to delve into Power Automate Desktop (PAD). PAD is a service that allows you to perform activities on a local machine as part of a flow. It’s a service that used to require an extra subscription cost, but it’s now available to everyone included with whatever tier of Power Automate you currently have. What Can You Do With PAD? So the big question is what can you do with Power Automate Desktop?

Continue Reading

Using Power Automate to Start, Stop and Restart Azure App Service

Sunday, May 16, 2021 by Barret Power Automate, flow, triggers, Azure App Service

Photo by Linda Eller-Shein from Pexels There are any number of reasons why you might want to start or stop your Azure App Service based on other factors. And while there are a number of ways to accomplish this, this time we’re going to cover how to do it in Power Automate with the press of a single button. Whether you want to start, stop or restart you app service, the flow works exactly the same way.

Continue Reading

More Securely Access an HTTP Request Trigger

Thursday, May 6, 2021 by Barret Power Automate, flow, triggers

Photo by PhotoMIX Company from Pexels In a previous post, we learned how to trigger a Power Automate flow by calling an HTTP endpoint. The best part of this trigger is that it allows you to trigger your flow from anywhere on the internet, be it an application or right in your browser. The trouble is, there isn’t security for that endpoint “out of the box”. Anyone who knows the endpoint’s URI can call it.

Continue Reading

Using an HTTP Request Trigger

Friday, Apr 30, 2021 by Barret Power Automate, flow, triggers

Request by Nick Youngson CC BY-SA 3.0 Alpha Stock Images This time around we’re going to talk about the HTTP request trigger. This is one of the automated category of triggers that allows you to trigger a flow to run from an HTTP request. This flow is really handy if you have some data you can put into a JSON schema that you want to process in some way. One example from the templates list is passing in data to the flow to use to create a user in Azure Active Directory.

Continue Reading


I am available for part time consulting work. If you are looking for someone to help with Power Automate, SQL Server, Azure or .NET work, feel free to contact me.

Contact me