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
Author: jgrijalba
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
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
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
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
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
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
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
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