Power Automate

Did You Know? Automating a Daily Factoid

Wednesday, Dec 29, 2021 by Barret Power Automate, flow, content

Final post for the year. Returning once more to Power Automate. This time we’re automating the posting of a random factoid from a spreadsheet to social media. This is similar to the other post I made that posts a random blog post from the archives. Creating Our Trigger We’ll start by creating a scheduled flow. How often you post will depend on how many items you have to select from. You want to avoid posting the same thing frequently, at least in my opinion anyway.

Continue Reading

C# Advent 2021 - Using C# Code in Power Automate

Monday, Dec 13, 2021 by Barret CS Advent, Power Automate, CS, custom connector

This post is my contribution to the C# Advent 2021. Power Automate has a fantastic feature in preview that lets you add some C# code to your flows. It requires using a custom connector, so it’s limited to those with a license that allows that. There are also a number of other limitations which I’ll get into later. But it’s a start. Yeah, I know, if you want to use C#, why not use a Logic App or Azure Function?

Continue Reading

From the Archives - Re-posting Old Blog Posts

Tuesday, Nov 23, 2021 by Barret Power Automate, flow, content

Photo by Lara Jameson from Pexels Once you’ve built up some content, one of the ways to keep your social media presence more active is to re-share your older blog posts. For long time followers, it can remind them of previous content. And it can help bring in new followers who didn’t see that content previously. If you’ve got a blog with an RSS feed that includes all of your content, then picking one at random to re-share is easy to accomplish with Power Automate.

Continue Reading

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

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

INTERESTED ?

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