Blog

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

Advent of Code 2021 - Day 11

Saturday, Dec 11, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 11 - Dumbo Octopus. Problem 1 For Puzzles for Day 11, we want to navigate through a cave of octopi by predicting when their bioluminescent energy will flash so we don’t disturb them. The octopi are arranged in a 10x10 grid, with each octopus represented by a power level from 0 to 9.

Continue Reading

Advent of Code 2021 - Day 10

Friday, Dec 10, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 10 - Syntax Scoring. Problem 1 For Puzzles for Day 10, we’re trying to resolve damage to the navigation subsystem of our submarine. Each navigation line contains a series of “chunks”, which are pairs of delimiter characters (), {}, [] and <>. They may or may not be nested and appear in formats such as:

Continue Reading

Advent of Code 2021 - Day 9

Thursday, Dec 9, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 9 - Smoke Basin. Problem 1 In the Puzzles for Day 9, we’re evaluating the low points of a 100x100 grid where each point represents a height with a value of 0 (lowest) to 9. The risk level of a point is 1 + it’s height. We need to find the sum of the risk levels of all the lowest points on the grid.

Continue Reading

Advent of Code 2021 - Day 8

Wednesday, Dec 8, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 8 - Seven Segment Search. Problem 1 In the Puzzles for Day 8, the wires on our 7-segment displays are malfunctioning and we need to figure out what it’s really saying. For part 1, we’ll figure out how many times digits 1, 4, 7 and 8 are appearing in the output. Our displays are represented by:

Continue Reading

Advent of Code 2021 - Day 7

Tuesday, Dec 7, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 7 - Whale Attack. Problem 1 In the Puzzles for Day 7, we’re getting attacked by a whale who intends to swallow the submarine. To the rescue come a bunch of crabs in mini-subs. But they’re not in alignment to blast open a rescue tunnel. We have to get them to move into horizontal alignment using the least amount of total fuel possible.

Continue Reading

Advent of Code 2021 - Day 6

Monday, Dec 6, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 6 - Lantern Fish. Problem 1 Puzzles for Day 6 focuses on fish population growth. In this case, fish are on a 7 day cycle. After that cycle, a fish produces a new fish and restarts its own cycle. The new fish has two additional days for its first cycle. So, given this, each fish is represented by a counter: 6 or 8 counting down to 0 each day.

Continue Reading

Advent of Code 2021 - Day 5

Sunday, Dec 5, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solutions for Day 5 - Hydrothermal Vents. Going forward I’m combining the posts into a single post per day. Problem 1 Puzzles for Day 5 is about finding the intersections of lines plotted on a grid. In this case, we have a set of lines defined by the endpoints across a 1000 x 1000 grid.

Continue Reading

Advent of Code 2021 - Day 4, Puzzle 2

Saturday, Dec 4, 2021 by Barret Advent of Code 2021

Photo by Any Lane from Pexels I’m participating in the Advent of Code 2021. Here’s my solution for Day 4, Puzzle 2 - Let the Squid Win Problem Puzzle 2 for Day 4 continues the bingo game. This time we’ll let the squid win. So, instead of finding the first winning care, we’re going to find the last winning card. Solution All my solutions are written in C#. You can find all my solutions in my Git repo.

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