Documenting the tips, tricks, and tools that I picked up while working in a Microsoft GCC environment for nearly 15 years.
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…
