PowerApps is an incredibly robust tool that allows developers to build a custom front end interface on top of any data source. One of the most powerful aspects of the tooling is a function called “User” that can give the developer options to personalize the UI based on a logged Read more…
When beginning to use Power BI, one of the most common questions is always “Where do I go to get sample Power BI data I can use?”. Unless you are willing and able to create your own datasets, downloading an already generated dataset provides a helpful place to start. Thankfully Read more…
Microsoft Forms being able to upload and handle individual files of up to 1 GB is a really nice feature of the software. Considering PowerApps file upload limit is 50 MB, Forms is a nice simplified alternative to consider when deciding which piece of software to use when, and being Read more…
Oftentimes as developers build more and more PowerApps, they keep seeing the same use cases and using the same patterns to fit those use cases. In such cases, if a developer finds themselves rebuilding the same thing over and over again it would save them time to build a reusable Read more…
One of the strengths of PowerApps is that it’s a blank slate to build whatever the developer’s heart desires. This can mean that as applications become more and more complex, it’s functionality becomes more complex as well. Rather than creating a new page for each new piece of functionality that Read more…
Before building a custom component with PowerApps Component Framework make sure that you have Node.js, Visual Studio Code (or another IDE), and the most recent version of the PowerApps CLI downloaded. If you are missing any of these items please refer to Part 1 of this blog series which walks Read more…
The PowerApps component framework (PCF) lets developers build re-usable code snippets called “Components” for model driven and canvas applications. The components can be used in multiple applications to enhance the user experience and drive a business use case. One of the examples I’ve run into is using the map functionality Read more…
There are situations in SharePoint where it’s better to not allow users to “Quick Edit” a list. For example, a use case where lists get updated via Power Automate and some fields are hidden from the input form it would be problematic to let users Quick Edit an item. In Read more…
External tooling is incredibly useful for extending capabilities in Power BI that might not be native to the application. As an example, the DAX editor in Power BI itself can be really cumbersome to develop larger DAX statements. DAX Studio negates this issue by giving you a dedicated environment to Read more…
Using a measures table in Power BI is generally considered best practice, and there are certain advantages to using one. However, I’ve found in my experience that the negatives outweigh the positives and that measure tables simply aren’t that intuitive. In Power BI, measure tables are used to contain all Read more…