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