Featured

How to remove these (Flow, Run Report, Excel Templates, Export to Excel and Import from Excel) buttons from Model Driven Apps

Hello all In this short video, I am going to show you how to use security roles privileges to remove certain buttons from MDA (Model Driven Apps). The UI in MDA is pretty much what you see is what you get but there are certain customizations that can be done by just removing certain actions … Continue reading How to remove these (Flow, Run Report, Excel Templates, Export to Excel and Import from Excel) buttons from Model Driven Apps →

Featured

How to Obtain Time Duration at Each Step of the Business Process Flow Using Power Automate

Hello all,If you are familiar with business process flows within Model Driven Apps and Dataverse, you will know that they only keep track of how long it took for the whole process to finish. If you wanted to know how long each individual step is taking then there is no out of the box solution … Continue reading How to Obtain Time Duration at Each Step of the Business Process Flow Using Power Automate →

Featured

Editable grid in Model Driven Apps can show data from 3 related tables in one single grid

In this short video I am going to show you how using the out of the box Editable sub-grid you can show data from 3 tables that have a one to many relationship. In our case Accounts has a one to many relationship to the Pet table which has a one to many relationship to … Continue reading Editable grid in Model Driven Apps can show data from 3 related tables in one single grid →

Featured

Model Driven Apps Duplicate Record Detection Rules

Hello all, In this quick video I will demonstrate a quick but powerful feature from Dataverse and Model Driven Apps. The ability to notify users if they are creating duplicate records. See video below for a quick demonstration https://videopress.com/v/qjzAXLMr?resizeToParent=true&cover=true&preloadContent=metadata&useAverageColor=true

Featured

Create word documents using Dataverse and Model Driven Apps

Hello all, Below a quick 5 minute video showing you how to create word templates from data in Dataverse leveraging model driven apps. It is a quick way to export data formatted in word without writing any code, HTML or complicated Power Automate flows. Pardon my video skills, still working on those. https://videopress.com/v/MxnRh2Mh?resizeToParent=true&cover=true&preloadContent=metadata&useAverageColor=true

Featured

Export Data to a HTML table from a Canvas Power App that uses a Dataverse table which has Lookup columns and Choice column fields

Hello all, It has been a while since my last post, mostly because I started this blog as a functional Dynamics 365 F&O blog but since then I have really stopped working with D365 F&O and been focusing more on the Power Platform. From now on I will post on topics such as Canvas Apps, … Continue reading Export Data to a HTML table from a Canvas Power App that uses a Dataverse table which has Lookup columns and Choice column fields →

Unposted Journal Report from D365 F&O using Power Automate

Hello all, It has been a while since I last wrote something. Truth is I haven't been doing much with Dynamics 365 F&O and have been just focusing on the Power Platform as a whole. Any ways a few days back a requirement came through my desk where a controller wanted to see a list … Continue reading Unposted Journal Report from D365 F&O using Power Automate →

Power Automate visual within PowerBI

Featured

Hello all, Recently in the April 2021 PowerBI release, we got the PowerAutomate visual. At first sight one can begin to wonder where this might be useful. In todays example I will showcase where I see this being very helpful. Let me lay down the scenario: I have a PowerBI report that shows me the … Continue reading Power Automate visual within PowerBI →

Create PO’s in D365 F&O using PowerApps and Virtual Data Entities

Featured

Hello All, A few months back I wrote a blog about how to create PO's using PowerApps and the out of the box D365 Finance and Operations power platform connector. (Link here for that blog: https://empowerdynamics365axusers.com/2021/02/03/create-purchase-orders-in-d365-fo-using-power-apps/) In that blog I had pointed out a few nuisances with the connector and the whole process. 1. My … Continue reading Create PO’s in D365 F&O using PowerApps and Virtual Data Entities →

View legacy documents for vendors in D365 Finance using Power Apps

Featured

Hello all, During my time implementing D365 F&O, a common requirement I come across is "Can I migrate my legacy vendor invoices to the new system" - as far as I know this is not possible without an expensive customization or by involving MS. There is a data entity called VendorAttachments but it doesn't work … Continue reading View legacy documents for vendors in D365 Finance using Power Apps →