A system dashboard in a model-driven app provides users an area to access reports that have been built into the app, or are embedded from Power BI. If you’ve build a report or dashboard in Power BI, you can make it accessible to your app users by first adding it to your app solution then configuring the app system dashboards. This works for both reports and dashboards in Power BI. Since it is essentially embedding the content, users will need to have access to the content in Power BI service in order to interact with it in your app. This means they will need the relevant Power BI license, and ..read more

Hey there! Looks like you’ve stumbled upon this post on Child Flows in Power Automate! You must be looking to adopt a best practice for building flows, perhaps you want to make your flows easier to follow, and perhaps you even want to make development quicker by cutting out the repetition in your work… well, lucky you! In this post I’m going to discuss what child flows are in Power Automate, why you might want to implement their use and how to do so in your cloud flow development. What are Child Flows? It’s common that we might come across a scenario where the solution we put in place required ..read more

Let’s learn how to implement Editable Grid and apply simple customization. As the name, the Editable Grid is a grid where we can do inline editing. In this blog, I create a custom table where we will implement the below scenario: – On Qty or Unit Price changed, set Total with formula Qty * Unit Price. – On Calculate Status changed, if set as “In Progress” then set Actual Start = Today’s date. If set as “Completed”, set Actual End = Today’s date. On the Parent Entity (Contact) where we want to place the Editable Gr ..read more

By detecting the theme parameter that Teams passes to Power Apps canvas apps when added as Tabs or Personal apps, we are able to make them Teams theme aware, but the same does not happen when we add a Canvas app to SharePoint using the standard Power Apps WebPart. However, there is a free open-source sample in the Microsoft 365 PnP sp-dev-fx-webparts Repository (Enhanced Power Apps WebPart) that we can use to help achieving that. This WebPart adds extra features, such as dynamic resizing, theme awareness, and dynamic data detection. Configuring theme variables in ..read more

When you’re building Power Apps within a Microsoft Teams based Dataverse environment, the most common target group of app users is obviously people who belong to that team. This is very logical when the purpose of the app is to collaborate as a team on something that might have otherwise been an Excel sheet shared with all team members. The simplified table security model of Dataverse for Teams with Owner/Member/Guest (“OMG”) levels instead of custom security roles makes things easy to manage when everyone is equal. But what about when you’d need to have more granularity on who gets to do what ..read more

In this tutorial, you’ll learn how to format lists in Power BI Paginated Reports. Specifically, you’ll learn how to add texts and create dynamic table headers. The goal of this tutorial is to create a list in a paginated report that looks similar to this: A Dynamic List Header In Power BI Paginated Reports Insert a textbox in your list by right-clicking on it and selecting Insert > Textbox. Then, type in the list header you want in your report. Drag the Territory field next to the header. In this case, the Territory field is grouped by region. So when you Run ..read more

The Microsoft Power Pages was announced in a preview on the 24th of May 2022 as a fifth product in the Microsoft Power Platform family. It is a more advanced way of creating websites, similar to how we are using and building the Power Apps Portals. Yet, it is a separate application type (it has its own icon), built on top of Dataverse. It means you still can use all the advantages of Dataverse tables, processes, connectors etc. There are no licencing details yet, but you can start using it as a trial version for 30 days. The same as in Portals, each Power Pages site will be created as a trial ..read more

Connectors, triggers and actions are the key components that make up Power Automate flows. This post will explain what each of these are. Firstly, at a high level: Connectors: Systems, services and apps that you use and can automate across Triggers: Action that will initiate the flow to run Actions: Each step that should occur after the flow is triggered Connectors The purpose of your flow is to automate a process. What are the apps, services and systems that you use within that process? These are referred to as connectors, which can be Microsoft as well as non-Microsoft/third ..read more

This post will explain how you can set the icon for a Microsoft Dataverse custom table (entity icon) in the Power Apps maker portal. When the custom tables are created for Dynamics 365 and model-driven app projects, updating the icon of the table is important because it is automatically assigned a puzzle piece icon by default. The icon of the table will be displayed in the sitemap, as the lookup value icon and in the primary image area for the Create form before the data is saved for the very first time. If the table does not have a child relationship (will never be used as a lookup), the tab ..read more

The default solution in the Power Platform is an unmanaged solution even in production. How do you handle unmanaged changes in the default solution that are edited manually? Unmanaged layers Table of Contents Unmanaged layers Switch to classic Deployment of apps, flows and tables should be done through solution packages. And you will find that as you deploy the solutions to production environments as managed solutions after you have developed them in a development environment as an unmanaged solution. Then if anyone (by accident or mistake) happens to update the tables, flows or apps in the ..read more