The Dynamics GP Blogster

AI Builder Form Processing Multi-layout Form Processing has been one of the most requested features and is now available in preview for you to test. This feature allows you to process forms with a variety of different layouts (but similar in content) with a single model, which brings this feature one step closer to a scalable enterprise solution. In this video I cover the following: - Creating a model - Form collections - Training the form processing model - Publishing the form processing model - Testing the model For additional information, please refer to: Create a form processing model - click here AI Builder form processing announcement - click here To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

Welcome to the final episode of Power Platform Application Lifecycle Management. In parts 1 and 2 you saw how to prepare your environments, set up an Azure DevOps project, and define Service Connections to your Power Platform environments.  In this, the final installment of this 3-part series, you will learn how to create the Build and Release pipelines using the Power Platform Build Tools to take your Power Platform solution from an environment, through source code control, through staging and production deployments. Topics covered: - Power Platform source code control with Azure Repos - Build and Release pipelines - Sharing your solution References: Power Platform Build Tools webinar - https://youtu.be/Qwue8fwetJA   Solutions Overview and Limitations - click here To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

In the previous installment, you saw how to work through a set of prerequisites to get you going in your Power Platform Application Lifecycle Management journey. In this video, I will work through building an app and adding it to a solution and show you some additional Azure DevOps configuration options to link your repository to your Power Platform development environment. Topics Covered: 1. Building app based on template 2. Adding your app to a solution 3. Linking your DevOps project to your Power Platform environment References: Power Platform Build Tools webinar - https://youtu.be/Qwue8fwetJA   Solutions Overview and Limitations - click here To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

This series is in response to multiple requests by my viewers to address the topic of Power Apps Application Lifecycle Management (ALM). This series is intended to breakdown the entire process in as much detail as possible, without lengthy explanations on how to get it done or, as often happens, little to no explanations on how you arrived at a particular step or result. My first installment will focus on Prerequisites, this is, what you need to have in place to get started. I will walk you through provisioning your Power Platform Dev, QA, and Production environments, along with installing the Power Platform Build Tools and setting up your Azure DevOps project. I also explain the concept of solutions in Power Platform and why they are important to your ALM strategy. Topics covered: 1. Creating Power Platform Environments 2. Azure DevOps and Installing Power Platform Build Tools 3. Creating an Azure DevOps Project 4. Solutions References: Power Platform Build Tools webinar ...

In this video you will learn how to save pictures taken in Power Apps Mixed Reality or Augmented Reality viewer to a SharePoint document library.     Some topics covered include: Power Apps ForAll(), With(), Mid(), and Len() functions, the Self operator. Learn to use the Power Automate SharePoint connector and the Create File action, and the base64toBinary() function in an expression. Finally, you will see how you can call a flow from Power Apps to make it all work like a single application. To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

In this video you will learn the basics of the Microsoft Graph API, how to use Graph Explorer, register an application to use Microsoft Graph in Azure Active Directory, and build a simple flow that will use the Teams Connector and Graph API to list a set of tabs in a Teams channel.    Other topics covered are: compose and HTTP actions, using the compose action as an alternative to variables, using the filter array action to filter the results in a JSON payload.  References: Microsoft Graph: https://graph.microsoft.com    Credits:  Creative Minds - Bensound - Royalty free music at https://www.bensound.com To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

In this video, I show you how Power Apps Mixed Reality works from the ground up. We will build a simple app that leverages the 3D Viewer and MR Viewer controls to display a 3D model of Star Trek's USS Endeavour. Somewhere, I also introduce the use of the Power Apps Self operator and show you how you can capture images from your Augmented Reality (AR) experience and store them in a collection   To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

In this video, I teamed up with fellow Microsoft MVPs, Belinda Allen and Daniel Christian , to show some non-traditional use cases for Power Platform. You will see examples on motion and creating motion patterns for things like the Solar System in Power Apps, cool data analysis of everything from the lottery numbers to UFO sightings to fact checking politicians in Power BI, and a showcase of Star Trek's Starfleet with using mixed reality, along with some Galaga game concepts, all in Power Apps.   Recorded at the Virtual Power Platform World Tour held on May 14, 2020. To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

I caught up with fellow MVP’s Steve Endow  and Belinda Allen  again for our Power Platform Share and have invited a special guest, fellow MVP Reza Dorrani  to present some of the latest Power Platform features and stuff he's been working on. Suffice to say Reza blew us away with his COVID-19 tracker while showing some of the new mapping and geospatial capabilities available with Power Apps.   To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

I had a chance to sit down with fellow MVPs Belinda Allen and Shawn Dorward , GPUG All*Star Amber Bell , and Zubin Gidwani from Dynamic Budgets to talk about "Work from Home" strategies with Dynamics GP amidst the Coronavirus stay at home orders Each one of us was tasked with presenting a rapid fire session outlining an approach to work remotely with Microsoft Dynamics GP. To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

This is the first video in a 2-part series that explains some of the basic concepts behind Mixed Reality. Learn what is a model, how you can compose a model file, pack it for consumption by Power Apps and having fun while doing it all.   Disclaimer: I am no mixed reality expert. This is just my personal experience trying to understand the elements and concepts behind it for the everyday citizen developer. I don't talk about Azure Mixed Reality or anything the Azure platform has to offer to developers. This is a simple "here's how you compose and pack a model for use with Power Apps Mixed Reality" video. References: GLTF to GLB Packer - click here Microsoft 3D Viewer - click here Microsoft Paint 3D support documentation - click here To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

Welcome to another video about Microsoft Power Automate and building flows! This week I team up with none other than Jon Levesque , Sr. Platform Evangelist for the Power Platform at Microsoft (Twitter: @JonLevesque , YouTube: click here ) to show how to incorporate the Google Maps API to enrich our Dynamics data! Big thanks to Jon for inviting me this week to show off how to use this API!   For additional information, please check the following resources: Google Static Maps API - click here Google Directions API - click here Don't forget to subscribe to my YouTube channel, here . Until next post! MG.- Mariano Gomez, MVP

In this episode I walk through the creation of a bot agent with Power Virtual Agents. I show you how to setup the Power Platform environment, along with creating the bot, setting up the topics, testing and deploying the bot.   For additional information, please check the following resources: Create a bot https://docs.microsoft.com/en-us/power-virtual-agents/getting-started-create-bot Music in this video comes courtesy of Bendsound: Dubstep- www.bensound.com (Royalty free music from Bensound) Until next post! MG.- Mariano Gomez, MVP

This video shows how to leverage the power of PowerApps and the capabilities of Microsoft Flow to work with REST APIs. In this case, I will take advantage of NASA's Astronomy Picture of the Day open API  to show Microsoft Flow in action. The resulting picture's title, URL, and explanation are used to create a nice app to display the latest NASA space picture prowess. For additional information, please check the following resources: Using the HTTP action to make requests with Microsoft Flow https://flow.microsoft.com/en-us/blog/http-card-tutorial/ Music in this video comes courtesy of Bendsound: Summer - www.bensound.com (Royalty free music from Bensound) Until next post! MG.- Mariano Gomez, MVP

This video shows how to create a manually triggered Flow to transfer a file to an Azure Storage Container using the Azure Storage Blob connector. You will learn how to set up an Azure storage account and a container and create a workflow to transfer a file from your mobile device or PC to a blob in Azure. I also show how to leverage expressions to obtain the file name for the selected file. For additional information, please check the following resources: Flow Buttons - click here PowerApps Azure Blob Storage Connector (Shane Young) - click here Until next post! MG.- Mariano Gomez, MVP

MVPs Steve Endow (Twitter: @steveendow ), Belinda Allen (Twitter: @MsBelindaAllen ), and Mariano Gomez (Twitter: @dgpblogster ) sit down with Bob McAdam  (Twitter: @4mcadam ), General Manager of the GP User Group (GPUG) to discuss the addition of Power Platform sessions in a Microsoft Dynamics GP Technical Conference. Recording was done live and onsite from Fargo, ND on September 12, 2019, but captures the bulk of where the Microsoft Dynamics GP partner channel is with the demand for these sessions. Until next post! MG.- Mariano Gomez, MVP

In my previous video, I showed you how we can pass collections from PowerApps as a JSON payload to Microsoft Flow. Now, we will see how we can get a JSON payload back into PowerApps. The technique used here requires knowledge of various PowerApps functions to accomplish the job: Split(), FirstN(), Last(), RemoveIf() , and a timer.   For more information, take a look at the following videos and articles: Microsoft Flow | Passing collections from PowerApps to Flow - click here Until next post! MG.- Mariano Gomez, MVP

I just got done with presentations at the yearly Microsoft Dynamics GP Technical Conference in Fargo, ND and had the privilege of delivering a session titled Leveraging your on-premises data with the Power Platform . During this session I presented a moderately complex sample application that leverages PowerApps AI Builder Form Processing to capture utility bills. These bills are submitted to the Microsoft Dynamics GP ERP application via a call to Microsoft Flow, which then invokes an eConnect API stored procedures to integrate these documents as Accounts Payable invoices. The Solution The solution leverages 3 AI Builder forms processing models for 3 distinct utility vendors. Each model contains 5 form fields, selected during the build process, after training the model with 5 documents. Each model was published and used to create a PowerApps application - the Fabrikam Utility Billing Center app. This canvas app, is capable of reading utility bills for each vendor...

In this video I explore how you can pass a collection of records from PowerApps to Microsoft Flow by leveraging the JSON() serialization function. I also cover some other topics like working with JSON schemas, Data Operations, Variables, and Control Structures in Flow. References: PowerApps | Form Processing with AI Builder: https://youtu.be/sVx6gsA2N5M PowerApps | A look at the new JSON() serializer function: https://youtu.be/CWt_t5OaCzs Until next post! MG.- Mariano Gomez, MVP

This short introductory video walks you through the installation of the PowerApps Build Tools component in an Azure DevOps environment. In addition, I show you where you can find information about PowerApps Build Tools and point you to a hands-on lab you can download to get your PowerApps DevOps journey started. For more information, please check the following sources: PowerApps Build Tools for Azure DevOps Overview - here Build Tools for Azure DevOps Hands-on Lab - GitHub  here Until next post! MG.- Mariano Gomez, MVP