Documenting the tips, tricks, and tools that I picked up while working in a Microsoft GCC environment for nearly 15 years.
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.
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 M action step! The Problem I get so frustrated…
Quick-ish run through of my time at the European Power Platform Conference 2023 (EPPC23) in Dublin, Ireland
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 I’m only talking about whole numbers (or integers), decimals, fractions, floating point, and currency, both positive and negative. According to the Microsoft documentation,…
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 SharePoint List were ultimately what lead…
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…
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 me to introduce my friends: the Parse JSON connector and curly braces…
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…
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 want to start with the definition from Microsoft. According to…
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 I am. A color specification, including an alpha channel.…
