Blog | Yer a wizard, Cat!

🪄🐈‍⬛ TnT #6 🧨

In Power Apps Canvas, the Power Fx’s Distinct() function easily removes duplicates in a list of values. In Power Automate, however, union() is supposed to achieve the same, but beware of bugs in the new Flow designer requiring a workaround.
🪄🐈‍⬛ TnT #5 🧨

Table of contents The Problem The Solution Additional tidbits I have finally decided to get this Power Query TnT written down before I forget all about it for the 80-bazillionth time. This one covers how I quickly transform a list of Records into a Table of correctly typed columns, all in a single Power Query…
European Power Platform Conference 2023 (EPPC23)

Quick-ish run through of my time at the European Power Platform Conference 2023 (EPPC23) in Dublin, Ireland
Number Data

Table of contents Math got us into this mess, and it's math that will get us out! Math is math, why the lesson? The number data type is oh so useful, let me just count the ways! I kid, but not about the usefulness. This post is about numbers, but I want to clarify that…
🪄🐈‍⬛ TnT #4 🧨

Table of contents Request Detail Solution Roughly a year ago, I had a project that I used SharePoint Lists to map the hierarchical organization structure of approximately 6000 employees/positions. I wanted to use combo boxes within Power Apps to quickly filter down to specific branches within the organization. Unfortunately, the multi-select choice fields in the…
🪄🐈‍⬛ TnT #3 🧨

Has the Power Apps Combobox Search feature ever been a thorn in your side when you need a specific field from a SharePoint List? Only that every time you attempt to return the distinct values from the field, or do some other transformation, the search feature immediately flips to off and refuses to allow you…
🪄🐈‍⬛ TnT #2 🧨

Table of contents Bonus tips for Power Apps & SharePoint People-Picker Fields Ever wondered why you keep getting an error in Power Automate or Power Apps whenever you try to add a new record or update an old one? Ever wanted to see the data structure for a data source with type-specific data requirements? Allow…
🪄🐈‍⬛ TnT #1 🧨

Did y’all know you can add/edit text in multiple places in the new Power Fx formula bar?!? 😲🤯 To do this: That’s it! That’s all there is to it. I knew this was a thing that could be done in VSCode and the Power Query editor in Power BI, but now we have it in…
Text Data

Table of contents Things to do to Strings String Manipulation I thought a post about text data would be easy to write up, and I was wrong. I have struggled with writing and re-writing this post. Mostly because of the simplicity of this data type mixed with the complexity of manipulating it. Regardless, I do…
Color Data

Table of contents Color Resources Accessibility Color me intrigued Color can be a tricky thing, but it’s also one of my favorite topics to explore. So, what if you happened to be looking through Microsoft’s data type documentation for an explanation on color. You might be left wondering if they even really tried. I know…