Tuesday, November 10, 2020

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 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

Tuesday, October 20, 2020

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 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

Tuesday, September 22, 2020

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

Monday, September 14, 2020

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 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 - https://youtu.be/Qwue8fwetJA

Credits:
Summer - 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

Thursday, September 3, 2020

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 and converted it into a Timesheet app for the purpose of recording time for various activities 



Other topics covered:

  • Working with SharePoint lists and Azure SQL databases
  • "When an item is created or modified" SharePoint connector trigger
  • "Delete Item" SharePoint connector action
  • "Get Items" SharePoint connector action
  • Conditional actions
  • Get Rows and Insert Row SQL connector actions
  • Apply to each action
  • substring(), formatDateTime()

Please leave your comments below and let me know what you think. Also, please feel free to suggest topics you would like me to cover. 

References: Reza Dorrani - Expense Tracking Sample Power App with Receipt Scanning AI - Click here

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

Monday, August 10, 2020

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, 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

Tuesday, July 28, 2020

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, 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