Power Apps – Application Monitoring with Azure Application Insights
Aug12

Power Apps – Application Monitoring with Azure Application Insights

In this video, learn to enable Power Apps Application Monitoring with Azure Application Insights.  The following topics are covered in this video:  (0:00) – Intro  (0:36) – What is Azure Application Insights  (1:32) – The timesheet app  (2:12) – Creating an Application Insight for the timesheet application  (3:55) – Identify and copy the application instrumentation key ...

Read More
Power Platform ALM – Visual Studio Code Extensions
Aug03

Power Platform ALM – Visual Studio Code Extensions

Learn about Power Platform extension for Visual Studio Code and how this toolset is improving both the code first developer experience and strengthening the ALM story.  The following topics are covered:  (0:00) – Intro (1:16) – Installing the Power Platform extensions for Visual Studio Code (2:13) – Working with the Power Platform CLI inside of Visual Studio Code (3:42) – Authenticating...

Read More
Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)
Aug02

Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)

I revisit an old video I did couple years ago showing how to pass collections from Power Automate to Power Apps.  This time around, I show how to leverage arrays to accomplish the same. This time around you will learn about:Power Apps trigger in Power Automate Get Rows SQL action Variables actionSelect action and ArraysResponse actionPower Apps Collections To check out my YouTube channel visit: <a… Continue...

Read More
AI Builder Form Processing: Multi-layout Form Processing
Nov10

AI Builder Form Processing: Multi-layout Form Processing

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… Continue Reading Mariano...

Read More
Power Platform: Application Lifecycle Management (Part 3/3) – Build and Release Pipelines
Oct20

Power Platform: Application Lifecycle Management (Part 3/3) – Build and Release Pipelines

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… Continue Reading Mariano...

Read More
Power Platform: Application Lifecycle Management (Part 2/3) – Solutions and DevOps
Sep22

Power Platform: Application Lifecycle Management (Part 2/3) – Solutions and DevOps

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…. Continue Reading Mariano...

Read More
Power Platform: Application Lifecycle Management (Part 1/3) – Prerequisites
Sep14

Power Platform: Application Lifecycle Management (Part 1/3) – Prerequisites

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… Continue Reading Mariano...

Read More
Power Automate: Transfer records from SharePoint list to Azure SQL database
Sep03

Power Automate: Transfer records from SharePoint list to Azure SQL database

Majority of times, when we are working with various data sources, we want information to go from one source to another, conditioned to the occurrence of an event. Today, I will show you how to transfer records from a SharePoint list to Azure SQL database tables in response to a timesheet approval event. In the process, you will learn how I leveraged the existing Power Apps Expense template app… Continue Reading Mariano...

Read More
Power Apps: Save Mixed Reality pictures to SharePoint
Aug10

Power Apps: Save Mixed Reality pictures to SharePoint

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,… Continue Reading Mariano...

Read More
Power Automate: Working with Microsoft Graph API and Teams Connector
Jul29

Power Automate: Working with Microsoft Graph API and Teams Connector

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,… Continue Reading Mariano...

Read More
Power Automate: Calculate Soundex of a word with a flow
Jul07

Power Automate: Calculate Soundex of a word with a flow

In this video, I will be showing you how to use Power Automate to calculate the Soundex value of a word using a flow. This calculation uses the American standard algorithm, but can be adapted to support other algorithms developed for the English language.   In building the workflow you will learn how to use the Scope, Compose, and Append To String actions, the Do Until and If Then… Continue Reading Mariano...

Read More
Power Automate: Building a REST endpoint with the HTTP Request connector
Jun19

Power Automate: Building a REST endpoint with the HTTP Request connector

In this video I show you how to build a REST endpoint with the Power Automate HTTP Request connector to be used as a web service to transfer data to a on-premises SQL database. In the process, I will be using Postman API development platform to test the endpoint and submit data to a Microsoft Dynamics GP company database via its eConnect API stored procedures.  To check out my YouTube channel… Continue Reading Mariano...

Read More
Power Apps: Calculating various dates with date functions
Jun10

Power Apps: Calculating various dates with date functions

In this article, I will show you how to leverage the DateDiff(), DateAdd(), Weekday(), DateValue(), and Day(), and Today() functions to calculate all sort of dates that are typical to business applications: first and last day of previous month, first and last day of previous quarter, first and last day of previous week, first and last day of current month, first and last day of current… Continue Reading Mariano...

Read More
Power Apps: Mixed Reality spatial controls
Jun08

Power Apps: Mixed Reality spatial controls

For the final installment of the Power Apps Mixed Reality series, I’m going to show you how to use the MR spatial controls, Shape in MR and Measure in MR. You will get to understand a bit more about the available properties for these controls and how they interact with collections and galleries to produce an app. To check out my YouTube channel visit: https://youtube.com/user/mgomezb1LIKE AND… Continue Reading Mariano...

Read More
Power Apps – Mixed Reality 3D Viewer and MR Viewer controls
May29

Power Apps – Mixed Reality 3D Viewer and MR Viewer controls

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   < div><br…...

Read More
Fun and Non-Traditional uses for Power BI, Power Apps and Power Automate
May29

Fun and Non-Traditional uses for Power BI, Power Apps and Power Automate

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… Continue Reading Mariano...

Read More
#Hack4GoodMBAS 2020 Global Hackaton
May06

#Hack4GoodMBAS 2020 Global Hackaton

This past weekend, I was privileged to participate on the 24-hour Hack4Good MBAS 2020 global hackathon, carried out prior to the Microsoft Business Applications Summit 2020.The theme for this hackathon revolved around COVID-19 and challenged all participating teams to create innovative solutions leveraging the entire Microsoft stack to solve a single problem. The hackathon involved teams from… Continue Reading Mariano...

Read More
Power Platform Share with Steve, Mariano, and Belinda (Episode 7)
May01

Power Platform Share with Steve, Mariano, and Belinda (Episode 7)

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.  <br…...

Read More
Power Apps – Mixed Reality 101
Apr17

Power Apps – Mixed Reality 101

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… Continue Reading Mariano Gomez’s...

Read More
Power Apps – Introduction to Mixed Reality
Apr17

Power Apps – Introduction to Mixed Reality

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… Continue Reading Mariano Gomez’s...

Read More
Power Virtual Agents – Create a Chat Bot for your on-premises ERP
Mar23

Power Virtual Agents – Create a Chat Bot for your on-premises ERP

This video shows how you can combine the power of Microsoft Power Virtual Agents chat bots and Power Automate flows with your on-premises data to provide an all around navigation-free user experience.While this video features Microsoft Dynamics GP as the on-premises ERP, technically speaking, you could create a chat bot for just about any ERP system in the market, whether on-premises or in the… Continue Reading Mariano...

Read More
Power Apps – Using Azure Text Analytics to monitor Coronavirus COVID-19 updates
Mar14

Power Apps – Using Azure Text Analytics to monitor Coronavirus COVID-19 updates

In this video I describe a Disease Monitor App I created as part of the #TemplatesForHumanity effort championed by Keith Wathling (Twitter: @KeithWathling) a couple years ago and that I have completely rehauled to support Coronavirus with an updated interface and approach to retrieve sentiment analysis with Azure Text Analytics.You will learn about: Using Text Analytics API in Power Apps (click… Continue Reading Mariano...

Read More
Using Power Apps & Power Automate with On-Premises Data
Mar06

Using Power Apps & Power Automate with On-Premises Data

Hello everyone!I sit down with Samuel Adranyi (@sadranyi) from Ghana, on his Power Series show, to demystify the user of Microsoft Power Apps and Power Automate with on-premises data. We cover the On-premises Data Gateway, its architecture, hybrid connectors, and provide a couple samples on accessing on-premises ERP data with both Power Apps and Power Automate.  References:What is the… Continue Reading Mariano...

Read More
Power Automate – Affirmation messages with Flic and the Twilio connector
Feb22

Power Automate – Affirmation messages with Flic and the Twilio connector

In this video you will learn how to setup a Twilio account, provision a phone number, and combine this with Flic and Power Automate to create an affirmation messaging system. You will also learn about the HTTP connector and the Parse JSON action. The result is this fun application of technology to deal with the everyday tensions in life. However, you can apply this to any areas of the… Continue Reading Mariano Gomez’s...

Read More
Power Automate – UI flows Introduction
Feb14

Power Automate – UI flows Introduction

Hello Friends!I had a chance to sit down with the incredible Jon Levesque, Senior Program Manager on the Microsoft Power Automate team to do a UI Flows 101 session. The result? A video with over 8K views! This video covers the basics:1. How to get started2. Where to find the On-premises Data Gateway3. Installing the UI Flows desktop plug-in4. Types of UI flows5. A simple demo on how to… Continue Reading Mariano Gomez’s...

Read More
Power Automate – Setting Up and registering Flic hubs and buttons
Feb14

Power Automate – Setting Up and registering Flic hubs and buttons

Most videos about this subject show you how to create all sort of Flic demos, but most don’t stop to show you how to get the Flic hub and buttons set up and registered with Power Automate. This video will explain where to obtain the software, how and where to install it, the Flic hub and buttons pairing and registration with Power Automate, and how to get a flow started that leverages the hub… Continue Reading Mariano...

Read More
Power Apps | Robotic Process Automation with AI Builder and UI flow (Part 3/3)
Dec17

Power Apps | Robotic Process Automation with AI Builder and UI flow (Part 3/3)

This is the final installment of a 3-part series vlog on Robotic Process Automation with Power Automate UI flows and Microsoft Dynamics GP. In this final episode, I am adding AI Builder capabilities to present an end-to-end solution that you can implement in your business now. This video shows how to combine the power of AI Builder form processing to read a sample utility bill and submit it… Continue Reading Mariano...

Read More
Power Automate | Robotic Process Automation with Microsoft Dynamics GP and UI flow (Part 2/3)
Dec01

Power Automate | Robotic Process Automation with Microsoft Dynamics GP and UI flow (Part 2/3)

This is the 2nd of a 3-part video series on implementing Robotic Process Automation (RPA) with Microsoft Power Automate UI flows and Microsoft Dynamics GP.This video shows how to call a UI flow from a Power Automate flow. I also show how to create and leverage a manually triggered flow to enter field values corresponding to a payables transaction and pass those on to the UI flow inputs to… Continue Reading Mariano Gomez’s...

Read More
Power Automate | Robotic Process Automation with Microsoft Dynamics GP and UI flows (Part 1/3)
Nov26

Power Automate | Robotic Process Automation with Microsoft Dynamics GP and UI flows (Part 1/3)

This is the first of a 3-part video series on implementing Robotic Process Automation (RPA) with Microsoft Power Automate UI flows and Microsoft Dynamics GP. This video shows how to get started with UI flows by automating a vendor invoice voucher entry in Microsoft Dynamics GP and while some of what’s outlined here is specific to this ERP, the same principles apply for instrumenting any other… Continue Reading Mariano...

Read More
Power Apps | #MadeItWithPowerApps Best App for Workplace Frustration
Nov19

Power Apps | #MadeItWithPowerApps Best App for Workplace Frustration

This video was made in response to the Microsoft Power Apps team challenge, found here. What was your best app and what workplace frustration inspired you to make it? Film a video with your answer and share it with #MadeItWithPowerApps and #Sweepstakes for a chance to win.This is the second video in a series of weekly videos leading up to the announcement of the sweepstakes winners. Music in… Continue Reading Mariano...

Read More
Microsoft Power Automate Tutorial – Google Maps API
Nov19

Microsoft Power Automate Tutorial – Google Maps API

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… Continue Reading Mariano...

Read More
Power Virtual Agents | Introduction and Walk-through
Nov15

Power Virtual Agents | Introduction and Walk-through

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 bothttps://docs.microsoft.com/en-us/power-virtual-agents/getting-started-create-botMusic in this… Continue Reading Mariano...

Read More
Power Apps | #MadeItWithPowerApps Tips and Tricks
Nov14

Power Apps | #MadeItWithPowerApps Tips and Tricks

This video was made in response to the Microsoft Power Apps team challenge, found here. The challenge is meant to provide newcomers to the platform with rapid fire tips and tricks that will help them get started.This is the first video in a series of weekly videos leading up to the announcement of the sweepstakes winners.  For additional information, please check the following resources:Add… Continue Reading Mariano...

Read More
Power Platform | Having fun with NASA APIs, PowerApps, and Flow
Oct30

Power Platform | Having fun with NASA APIs, PowerApps, and Flow

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,… Continue Reading...

Read More
Microsoft Flow | Transfer a file to Azure Storage Blob with Manually Triggered Flow
Oct02

Microsoft Flow | Transfer a file to Azure Storage Blob with Manually Triggered Flow

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… Continue Reading Mariano...

Read More
Power Platform Share with Steve, Mariano, and Belinda (Episode 6)
Sep26

Power Platform Share with Steve, Mariano, and Belinda (Episode 6)

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… Continue Reading Mariano...

Read More
PowerApps | Passing Record Collections from Microsoft Flow to PowerApps
Sep19

PowerApps | Passing Record Collections from Microsoft Flow to PowerApps

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. Hopefully, one day we will be able to pass JSON payloads from… Continue Reading Mariano...

Read More
PowerApps | Fabrikam Utility Billing Center sample app
Sep11

PowerApps | Fabrikam Utility Billing Center sample app

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… Continue Reading Mariano...

Read More
Microsoft Flow | Passing collections from PowerApps to Flow
Sep04

Microsoft Flow | Passing collections from PowerApps to Flow

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/sVx6gsA2N5MPowerApps | A look at the new JSON()… Continue Reading Mariano Gomez’s...

Read More
PowerApps | Introduction to Build Tools for Azure DevOps
Aug26

PowerApps | Introduction to Build Tools for Azure DevOps

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… Continue Reading Mariano...

Read More
Microsoft Flow – Form Processing with AI Builder
Aug21

Microsoft Flow – Form Processing with AI Builder

You previously saw me use a AI Builder to build and train a form processing model to understand a utility bill. I also show how to build a real life PowerApps application to take advantage of the utility billing model and some elements and considerations while doing so. In this new video, I show you how to leverage Microsoft Flow to create a simple orchestration around the same utility bill… Continue Reading Mariano...

Read More
Microsoft Dynamics GP | Embed PowerApps apps
Aug16

Microsoft Dynamics GP | Embed PowerApps apps

This video shows how to embed PowerApps applications inside of Microsoft Dynamics GP, leveraging the Connect gadget feature as a mechanism to deliver the application. Learn how you can achieve this in 2 simple steps to create a unique user experience.More information on Dex.ini settings and web client:Dex.ini on this site – click hereWeb client on this site – click hereUntil next post!MG.-<br… Continue Reading...

Read More
PowerApps | Persisted Button Pressed Numeric Up/Dn Control – Part 2
Aug13

PowerApps | Persisted Button Pressed Numeric Up/Dn Control – Part 2

This is part 2 of 2 showing how to build a persisted button pressed numeric up/down control. This video shows how to leverage PowerApps components to create a single reusable unit that can be leveraged across other applications. You can find more information about PowerApps Components by watching the following Microsoft MVPs and community members’ videos:Shane Young – Intro PowerApps… Continue Reading Mariano...

Read More
PowerApps | Persisted Button Pressed Numeric Up/Dn Control – Part 1
Aug05

PowerApps | Persisted Button Pressed Numeric Up/Dn Control – Part 1

This is part 1 of 2 showing how to build a persisted button pressed numeric up/down control. This video addresses the fundamentals of the control, starting with understanding the button pressed event, how it can be used to start and stop a timer, how to make 2 buttons increase and decrease a text input control, and finally introducing a timer to persist the press. Part 2 will show how to… Continue Reading Mariano Gomez’s...

Read More
Form Processing with PowerApps AI Builder
Jul30

Form Processing with PowerApps AI Builder

In this video I explore the recently released AI Builder Form Processing component, by creating and training a utilities billing model. I also show how to build a real life PowerApps application to take advantage of the utility billing model and some elements and considerations while doing so. You can find more information on AI Builder here:<a… Continue Reading Mariano Gomez’s Article on their blog Form Processing with...

Read More
Power Platform – Did you know? Mobile Apps
Jul23

Power Platform – Did you know? Mobile Apps

This video explores some basic capabilities available with the PowerApps, Microsoft Flow, and Power BI mobile applications.  Here I only highlight 3 of those capabilities:1. Pinning PowerApps applications to the device home screen and marking an application as favorite2. Create a Flow workflow from a template or from blank3. Annotating a Power BI dashboards and tiles for easy follow up Until… Continue Reading Mariano...

Read More
Developing PowerApps and Flow apps with Azure Cognitive Services’ Computer Vision
Jul11

Developing PowerApps and Flow apps with Azure Cognitive Services’ Computer Vision

This is a session I presented at the recent Azure Virtual Day Camp, hosted by Dynamic Communities’ D365UG, on June 26, 2019.In this presentation I show how to leverage Azure Cognitive Services’ Computer Vision service with PowerApps and Flow to build a badge scanner. In addition, I show how to use some simple, but powerful PowerApps and Flow functions to do string and image manipulation.  <br… Continue...

Read More
#PowerApps – A look at the new JSON() serializer function
Jul10

#PowerApps – A look at the new JSON() serializer function

In this video I take a look at the newly released JSON() serialization function and how it can be used to serialize an image, added to PowerApps in the month of June. You can read the full details on the PowerApps Blog article, JSON for canvas apps. Also, take a look at the video created by PowerApps MVP, April Dunham on the subject, along with her intro to AI Builder.Until next post!MG.-<br… Continue Reading Mariano...

Read More
#PowerApps #PowerBI: Cash flow in Power BI and PowerApps – THR1014
Jun29

#PowerApps #PowerBI: Cash flow in Power BI and PowerApps – THR1014

This past Microsoft Business Applications Summit 2019 – Atlanta, I teamed up with fellow Microsoft MVP, Belinda Allen to deliver a 20 minutes theater session showing how to build a cash flow in Power BI, then use Microsoft Flow to get notifications based on specific conditions in the report, and embedding the cash change calendar as a tile in a PowerApps application.We had a lot of fun putting… Continue Reading Mariano...

Read More

The Dynamics GP Blogster: #PowerApps: Componentizing Google Maps

Hi PowerAppers!PowerApps Canvas Apps Components remain one of those features that seem to have endless possibilities. I have, for quite some time now, been working with the Google Maps API in many of my applications to return a static image pointing to a specific location on the map.As I moved from application to application, I noticed that I always ended up doing the same operations: format… Continue Reading Mariano...

Read More