For a long time when Power Automate came out, the integration points with Power BI were not great. Flows were prevented from doing almost anything useful with Power BI except for refreshing a dataset. Which is limited to 8 times a day. Microsoft took a step in the right direction Read more…
One of the main use-cases that has always been a great candidate for the power platform is approval workflows. Using the ‘Approvals’ connector in Power Automate is usually the first method to use for this which has a handy Outlook integration that provides the user an interactive email that handles 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…
Creating a map visualization in Power BI to display location data is not difficult. Power BI ships with a couple of different options available out of the box, and more can be added through the visuals store. Out of the box options include a native map, a “Filled Map” and Read more…