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.
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…
