Monday, March 23, 2020

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 cloud. In fact, why stop at ERPs?

 

Reference:

Power Virtual Agents page - click here
Use Power Virtual Agents Connector to build Power Automate flows for your bot - click here

To check out my YouTube channel visit: https://youtube.com/user/mgomezb1

LIKE AND SUBSCRIBE!!!

Until next post!

MG.-
Mariano Gomez, MVP

Saturday, March 14, 2020

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 here)
  • Power Apps Collections (click here)
  • Power Apps UpdateIf() function (click here)


References:

Download this app from my GitHub repo here.
#TemplatesForHumanity on Twitter here.

To check out my YouTube channel visit: https://youtube.com/user/mgomezb1

LIKE AND SUBSCRIBE!!!

Until next post!

MG.-
Mariano Gomez, MVP

Thursday, March 5, 2020

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 On-premises Data Gateway? - click here
Install an on-premises data gateway - click here


To check out my YouTube channel visit: https://youtube.com/user/mgomezb1

LIKE AND SUBSCRIBE!!!

Until next post!

MG.-
Mariano Gomez, MVP

Saturday, February 22, 2020

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 enterprise, i.e., to create an emergency alert system or a company wide notification system.

 

References: Power Automate - Setting up and registering Flic hubs and buttons - https://youtu.be/PJbiS02pvEs

To check out my YouTube channel visit: https://youtube.com/user/mgomezb1

LIKE AND SUBSCRIBE!!!

Until next post!

MG.-
Mariano Gomez, MVP

Friday, February 14, 2020

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 started
2. Where to find the On-premises Data Gateway
3. Installing the UI Flows desktop plug-in
4. Types of UI flows
5. A simple demo on how to automate a desktop application

References:

UI Flows Setup documentation: https://docs.microsoft.com/en-us/power-automate/ui-flows/setup
To download UI Flows Installer: click here
To download Selenium IDE for Web Automation: click here
To download the On-premises Data Gateway: click here

With these items installed, you should be all set to follow along with me and Jon in this tutorial!

To check out my YouTube channel visit: https://youtube.com/user/mgomezb1

LIKE AND SUBSCRIBE!!!

Until next post!

MG.-
Mariano Gomez, MVP

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 and buttons.

 

References:

Flic 2 Smart Button website: https://flic.io/

Until next post!

MG.-
Mariano Gomez, MVP

Tuesday, December 17, 2019

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 to your legacy ERP system.



The objective here is to show yet another integration mechanism to get data into another application and in no way this video is intended to suggest you replace your current integration processes by what you are seeing here. However, it does open the door to consider modernizing the tools you have in house with the flexibility of the Power Platform.

My previous videos in this series can be found here:

Robotic Process Automation with Microsoft Dynamics GP and UI flow (Part 1/3) - Click here
Robotic Process Automation with Microsoft Dynamics GP and UI flow (Part 2/3) - Click here

Don't forget to subscribe to my YouTube channel!

Music:
Summer - www.bensound.com (Royalty free music from Bensound)

Until next post!

MG.-
Mariano Gomez, MVP