Author: jgrijalba

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 →

Featured

Create Purchase Orders in D365 F&O using Power Apps

Hello all, This will be my first post for 2021, hopefully it will add value to some one in the world wide web. With that said, this blog will be a little different: 1.Quick video of the end to end solution 2.Explain in my opinion the use case of this scenario. Pros and Cons of … Continue reading Create Purchase Orders in D365 F&O using Power Apps →

Embedded Teams app to create Journal entries into D365 Finance and Operations or Supply chain management

Featured

Hello All, It has been a while since my last blog post, so today I decided to write about something fun. The blog below is to showcase the power of D365 F&O along with the power platform. It is meant to be a demo or proof of concept and not a finished production app. The … Continue reading Embedded Teams app to create Journal entries into D365 Finance and Operations or Supply chain management →