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
Jun09

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
#MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs – Selecting a Source Control Provider
May29

#MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs – Selecting a Source Control Provider

So far, I have covered the process of setting up both the Microsoft Dynamics 365 BC containerized application components, along with the VS Code IDE and AL language extensions. We also built the “Hello World” extension on BC’s Customer List page and deployed it to our container by following some simple debugging steps. You can read more about it in the following articles:#MSDYN365BC: Building… Continue Reading...

Read More
The Dynamics GP Blogster: #MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs
Apr30

The Dynamics GP Blogster: #MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs

In the previous 3 articles of the series, I talked about the rationale for selecting a container based environment for development purposes, we also installed Docker and downloaded and installed the Microsoft Dynamics 365 Business Central containers for Docker. This then set us on a path to installing the development IDE and selecting a source code control provider to host our AL… Continue Reading Mariano Gomez’s Article...

Read More
Building a Development Environment for Microsoft Dynamics GP ISVs Part 3/3
Apr19

Building a Development Environment for Microsoft Dynamics GP ISVs Part 3/3

In Part 2 of this series, we covered the full installation of Docker Desktop, used to run the Dynamics 365 Business Central containers. We also saw how to use PowerShell to enable both the Hyper-V and Containers features on Windows 10.This article will focus on the installation and troubleshooting of the Dynamics 365 Business Central containers and will provide step by step instructions on… Continue Reading Mariano Gomez’s...

Read More
Building a Development Environment for Microsoft Dynamics GP ISVs Part 2/3
Apr13

Building a Development Environment for Microsoft Dynamics GP ISVs Part 2/3

In Part 1 of this series, I outlined the principles and detailed the reasoning behind why we chose to build our Microsoft Dynamics 365 Business Central development environment using Windows Docker containers. In the Dynamics GP world, we are not quite used to containers, so let me start with the definition, straight from the horse’s mouth (so to speak). According to the wizards over at… Continue Reading Mariano...

Read More
Building a Development Environment for Microsoft Dynamics GP ISVs Part 1/3
Apr10

Building a Development Environment for Microsoft Dynamics GP ISVs Part 1/3

This is my first foray into the world of Microsoft Dynamics 365 Business Central (BC) development and this series of articles is meant to help Microsoft Dynamics GP ISVs understand the process of building a BC development environment, identify similarities with a Dynamics GP development environment, and fully utilize your accumulated experience. Yes, there’s tons of literature out there, but… Continue Reading Mariano...

Read More
“Database must be compatibility level 130 or higher for replication to function” when setting up #MSDYN365BC Intelligent Cloud sync
Apr04

“Database must be compatibility level 130 or higher for replication to function” when setting up #MSDYN365BC Intelligent Cloud sync

As of recent, I’ve been honing on my Microsoft Dynamics 365 Business Central (BC) skills, without leaving my beloved Microsoft Dynamics GP behind. One of the things that I have been working on is making sure customers understand the BI insights gained via data replication between the two systems. As a result, I am always working through the replication configuration a few times a… Continue Reading Mariano Gomez’s...

Read More
Numeric Up/Down control with persisted button press event using components
Mar26

Numeric Up/Down control with persisted button press event using components

I just recently returned from the Microsoft MVP Global Summit 2019 where I had a chance to meet some of the top minds in the Microsoft PowerApps and Flow space. This was a truly exciting moment as I have been learning from the very same MVPs I met – yes, we do learn from each other!In one of my hallway discussions, I ran into my buddy Mehdi Slaoui Adaloussi, Principal Program Manager at… Continue Reading Mariano...

Read More
Named Printers and Redirected Printers in RDP environments
Mar07

Named Printers and Redirected Printers in RDP environments

A lot of the guiding principles for deploying Named Printers in a Terminal Server or Citrix environment comes from two of my favorite articles, written by my good friend and fellow Microsoft Business Applications MVP, David Musgrave (twitter: @winthropdc). David happens to be the creator of Named Printers and probably understands the product better than anyone I know. You can read his… Continue Reading Mariano Gomez’s...

Read More
#PowerApps: Using Components to create a Digital Clock – Part 2
Mar05

#PowerApps: Using Components to create a Digital Clock – Part 2

In Part 1 of this series, you saw how my first version of the digital clock went. Although it got the job done, it was plagued with repetitive code, repetitive controls, and over saturation of variables, which in turn rendered the application hard to follow, and worse yet, affected performance.In this article, I will show how to use PowerApps Components to promote reusability and decrease the… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: #PowerApps: Using Components to create a Digital Clock
Mar04

The Dynamics GP Blogster: #PowerApps: Using Components to create a Digital Clock

Building a Digital Clock the traditional wayWhen I first set out to build a digital clock with night mode, I figured I was just going to start from what I know. Each digit of the clock is composed for 7 segments and each segment would behaves in a binary way based on the number that it needs to display. To create each segment, I would use a Rectangle from the Icons gallery. Since I initially… Continue Reading Mariano...

Read More
Simple Object Proximity and Collision Detection
Feb14

Simple Object Proximity and Collision Detection

As of late, I have been very interested in all things “Motion” as it relates to developing PowerApps applications – see #PowerApps: Motion Patterns with Parametric Equations. Although, most of the apps you will see tend to be around solving business problems, you cannot really dismiss the capabilities of PowerApps as a gaming platform. The Basics In this article, I explore a simple… Continue Reading Mariano...

Read More
Motion Patterns with Parametric Equations
Feb11

Motion Patterns with Parametric Equations

As of late, I have been experimenting with motion in Microsoft PowerApps. This has actually helped me to revisit different mathematical models describing the motion of objects throw a two-dimensional space. As a result, I have created this video explaining how to create the following motion patterns: You can download the msapp file from the PowerApps Community Apps Gallery here.Until next… Continue Reading Mariano Gomez’s...

Read More
Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow
Nov04

Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow

Recently, Business Applications MVP Steve Endow and I delivered a session at the User Group Summits in Phoenix, and in particular, to the GPUG Summit titled, “Microsoft Dynamics GP and Azure Services”. In this course we detailed a number of Azure Services (among the hundreds) that could potentially be used with Microsoft Dynamics GP.Being that I have also been working my way through… Continue Reading Mariano...

Read More
Installing the Microsoft Azure Integration Runtime
Oct19

Installing the Microsoft Azure Integration Runtime

The Integration Runtime (IR) is a customer managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments. It was formerly called as Data Management Gateway. It is used by Business Central and Dynamics GP to provide a one-way data synchronization between your on-premises SQL Server hosting your company… Continue Reading Mariano Gomez’s...

Read More
Provisioning a Microsoft Dynamics 365 Business Central demo tenant
Oct08

Provisioning a Microsoft Dynamics 365 Business Central demo tenant

With the release of Microsoft Dynamics GP 2018 R2, I had a first look at the update process, then quickly ran into a situation where the option to set up intelligent cloud insights wasn’t showing in my already provisioned Microsoft Dynamics 365 Business Central tenant – See, “Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants.I also noted that… Continue...

Read More
“Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants
Oct03

“Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants

I was (still am!) seriously excited about the release of Microsoft Dynamics GP 2018 R2 – I mean, how can you not? This Intelligent Cloud thing is just superb! The simple premise of being able to sync your data to Microsoft Dynamics 365 Business Central and use the power of the cloud to get actionable insights is just too good to pass up on.See my article, Microsoft Dynamics 365 Business… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: Updating to Microsoft Dynamics GP 2018 R2
Oct03

The Dynamics GP Blogster: Updating to Microsoft Dynamics GP 2018 R2

Yesterday marked the release of Microsoft Dynamics GP 2018 R2 to the English speaking market – other languages soon to follow. After a few hiccups in the download process (make sure you clear your browser cache before attempting to download), I was able to get my hands on the 1.81 GB zip file containing the actual installation media (1.92 GB unzipped).Since this is not a major release, I went… Continue Reading Mariano...

Read More

The Dynamics GP Blogster: Calling SQL Server stored procedures from Microsoft Dexterity

Back in January of 2009, I wrote an article showing a method of calling a SQL Server stored procedure from Dexterity by calling a stored procedure prototype script (sproc) in sanScript.See, Calling SQL Server stored procedures from Microsoft Dexterity (January 26, 2009).This sproc tells the runtime engine (Dynamics.exe) that it must connect to either the system or company database to run… Continue Reading Mariano Gomez’s...

Read More
Missing Dexterity Shared Components cause Word Templates processing to hang
Jul27

Missing Dexterity Shared Components cause Word Templates processing to hang

Working recently on an issue, I ran into a situation where I would get the following template processing error attempting to print a SOP Invoice – if you look at the bottom status bar, next to the user ID, you will see a Template Processing accompanied by a yellow warning triangle. Upon inspecting the Template Processing status, I ran into the following Exception Detail message:The… Continue Reading Mariano Gomez’s...

Read More
the perfect complement for Microsoft Dynamics GP users
Jul25

the perfect complement for Microsoft Dynamics GP users

Microsoft Dynamics GP users rejoice!If you were a part of the long list of users, partners, and ISVs scared by some imaginary deadline set (by Microsoft) for you to migrate from Dynamics GP and onto Dynamics 365 Business Central, it’s now my pleasure to separate fact from fiction in this era of, well, fake news – at least in the Dynamics space.Microsoft has recently published the October ’18… Continue Reading...

Read More
Microsoft Dynamics GP July Hotfix packed with some long awaited features
Jul24

Microsoft Dynamics GP July Hotfix packed with some long awaited features

If you missed it, the Microsoft Dynamics GP Development team has delivered the July Hotfix for versions 2015, 2016, and 2018. What has me really excited are a number of features that were included in this release – I will skip the bug fixes as those are always welcome – as follow:Support for TWAIN driversWhy is this important? TWAIN is an API and a communications protocol that regulates… Continue Reading Mariano...

Read More
Installing Visual Studio Tools for Microsoft Dynamics GP project templates for Visual Studio 2017
Jun06
Read More
GPUG Amplify South Africa 2018 – Wrap Up
Jun06

GPUG Amplify South Africa 2018 – Wrap Up

GPUG Amplify South Africa is been over for a bit over a week, yet there’s still sense of a conference with a lot potential and room for growth. For some background, I helped organize the preceding event, reIgnite GP 2017 and was a part of the keynote speech delivered last year. In addition, I delivered 6 sessions around various Microsoft Dynamics GP topics, but primarily my focus was on… Continue Reading Mariano...

Read More
GPUG Amplify South Africa 2018 – Post Conference
Jun01

GPUG Amplify South Africa 2018 – Post Conference

Wednesday, May 23, 2018After a long couple days, and especially after Day 2 presentation marathon, I decided to sleep in a bit this morning. I had a commitment at midday to meet with the Premier team. Premier has sponsored my trips to South Africa over the last two years, which has allowed me to participate in both reIgnite GP and GPUG Amplify South Africa conferences, so I wanted to take the… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: GPUG Amplify South Africa 2018
May21
Read More
GPUG Amplify South Africa 2018
May14
Read More
The Dynamics GP Blogster: Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance
Apr28
Read More
Microsoft Dynamics GP is not in “Maintenance Mode”
Mar26
Read More
The Dynamics GP Blogster: Microsoft Dynamics GP: Running System and Company Databases on Azure SQL
Feb26
Read More
How to Manually Replace the Web Client SSL Certificates
Feb09
Read More
Microsoft Dynamics GP and TLS 1.0
Jan26
Read More
The Dynamics GP Blogster: Microsoft Dynamics GP 2018 installation
Dec09
Read More
The Dynamics GP Blogster: Building Microsoft Dexterity Cross-Dictionary Applications with GP Power Tools
Nov28
Read More