SharePoint: UPPER function
Converts text to uppercase, leaving numbers and punctuation untouched. The result is always text.
TAG
Overview
Some topics are too broad and complex to cover in a single article. That does not mean I want to skip them, so here I share high-level thoughts about a specific subject. They might spark several follow-up articles or stand alone, but the point is to convey the main idea or concept clearly. I call these overviews because that is exactly what they are. A few sit slightly off brand for this blog, and when they do I still work to make them relatable and engaging while keeping that broad, big-picture mindset so things never get too dense. There is no schedule for these posts. I write them whenever I stumble onto a topic that interests me, so expect them to appear sparingly among the more focused work here.
How are things going and new sections.
A site update on how things are going, plus four new sections and open consulting slots.
Excel: Count Function
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.
N8N: Gmail Trigger
Starts a workflow when a new email arrives in Gmail. Polls on a schedule; filter by label, sender, or search.
The reason it's EMail and not Email or email in Power Automate
Explains why SharePoint's email field is spelled EMail and why the casing breaks your filters
Things I won't do in the site
Why I keep ads, affiliate links, guest posts, tracking, and polarizing topics off the site.
Power Apps: LookUp Function
Returns the first record that matches a condition, or a single reduced value. Blank if nothing matches.
Why I prefer to fail forward?
Why I push forward to fix problems instead of rolling back to a safe version
How to stop an infinite trigger loop in Power Automate?
Stop a flow from re-triggering itself with trigger conditions, flag columns, or a create-only trigger.
The strange dichotomy of AI
Why we love AI when it saves us time but resent it when we're on the receiving end
Dynamic Content Troubleshooting in Power Automate
