Author: Danilo Capuano

Technical Delivery Manager and Head of Naples Office at Agic Technology • CTO at AiCademy • Microsoft MVP and MCT • Dynamics 365 • Power Platform • Azure • AI

Custom Virtual Table provider with CRUD operations: Creating a table on Azure SQL database – part 2 of 6

Hi,after making an introduction and presenting the scenario in the part 1, in this second post I show you how to create the table that has the goal of representing the external system.In this case I used an Azure SQL database and created a table called Person. The table have following fields: PersonId to store … Continue reading Custom Virtual Table provider with CRUD operations: Creating a table on Azure SQL database – part 2 of 6

Custom Virtual Table provider with CRUD operations: Introduction and scenario – part 1 of 6

Hi,in this series of six posts I will speak about Virtual Tables. I will show you through a simple PoC with a step by step approach the new support of CRUD operations. I would say that a new era of integrating our Dataverse with external systems has just started! If before this update the Virtual … Continue reading Custom Virtual Table provider with CRUD operations: Introduction and scenario – part 1 of 6

Create a BOT with Power Virtual Agents and Dataverse [ITA]

In this post I share the video of my session at the Global Power Platform Bootcamp Italy 2021. I presented a real case potentially applicable to a Covid19 diagnostic center to facilitate the work of operators to communicate the results of the exams.Technologies involved: Dataverse, Power Virtual Agents, Power Automate, Microsoft Oauth2, Azure. https://www.youtube.com/embed/VXBV45i0WxU

ALM in Power Platform using DevOps, Power Platform Build Tools and Team Foundation Version Control – Part 3 of 3: Move solution from QUA to PROD and check-in unpacked solution and zip solution file into TFVC Source Control

In this series of articles I want to explain how to configure a simple Application Lifecycle Management (ALM) process using DevOps and TFVC as an alternative to Github into Power Platform context. I will show that by creating two simple Azure Pipelines: the first move the solutions from source to destination environment and the second store both … Continue reading ALM in Power Platform using DevOps, Power Platform Build Tools and Team Foundation Version Control – Part 3 of 3: Move solution from QUA to PROD and check-in unpacked solution and zip solution file into TFVC Source Control

ALM in Power Platform using DevOps, Power Platform Build Tools and Team Foundation Version Control – Part 2 of 3: Move solution from DEV to QUA

In this series of articles I want to explain how to configure a simple Application Lifecycle Management (ALM) process using DevOps and TFVC as an alternative to Github into Power Platform context. I will show that by creating two simple Azure Pipelines: the first move the solutions from source to destination environment and the second store both … Continue reading ALM in Power Platform using DevOps, Power Platform Build Tools and Team Foundation Version Control – Part 2 of 3: Move solution from DEV to QUA

ALM in Power Platform using DevOps, Power Platform Build Tools and Team Foundation Version Control – Part 1 of 3: Configuration

In this series of articles I want to explain how to configure a simple Application Lifecycle Management (ALM) process using DevOps and TFVC as an alternative to Github into Power Platform context. I will show that by creating two simple Azure Pipelines: the first move the solutions from source to destination environment and the second … Continue reading ALM in Power Platform using DevOps, Power Platform Build Tools and Team Foundation Version Control – Part 1 of 3: Configuration

Free eBook: Beginning Power Apps Component Framework – build your first custom component step by step

Hey Community, I'm happy to share my new free eBook! Beginning Power Apps Component Framework - build your first custom component step by step - This eBook containing 60+ pages, all focused on fundamental concepts of PCF. This guide will save you time if you are approaching to develop a PCF Custom Component. Included in … Continue reading Free eBook: Beginning Power Apps Component Framework – build your first custom component step by step

AI, Microsoft Azure and Microsoft Power Platform AI Builder – Put them together

AI is the creation of software that imitates human behaviors and capabilities. Key elements include: Machine Learning, Anomaly Detection, Computer Vision, Natural Language Processing and Conversational AI. For each key element Microsoft Azure offers specific tools and services. In particular: Machine Learning: Automated Machine Learning, Azure Machine Learning Designer, Data and Compute Management, PipelinesAnomaly Detection: … Continue reading AI, Microsoft Azure and Microsoft Power Platform AI Builder – Put them together

Robotic Process Automation (RPA) – Integrate Common Data Service (CDS) with Power Automate UI Flow and Desktop App (Paint)

In this article I want to talk about the solution provided by Microsoft for Robotic Process Automation (RPA) through an example that involving Common Data Service, Power Automate and Paint... yes, you got it right, Paint 🙂 Let's do some explanations first! What is Robotic Process Automation (RPA)? The Robotic Process Automation (RPA) automating time-consuming … Continue reading Robotic Process Automation (RPA) – Integrate Common Data Service (CDS) with Power Automate UI Flow and Desktop App (Paint)

Use SQL Server Management Studio (SSMS) to query data from Common Data Service (CDS)

Among the latest features released by Microsoft, we have the possibility (finally!) of being able to connect in the cloud to the Common Data Service (CDS) database to perform our queries. The SQL connection provides read-only access to the entity data of the target CDS environment. Below I show you all the necessary steps. First … Continue reading Use SQL Server Management Studio (SSMS) to query data from Common Data Service (CDS)

Exam MB-400: Microsoft PowerApps + Dynamics 365 Developer – My Experience and Study Guide

Last week I passed (result) the new MB-400 exam: Microsoft Power Apps + Dynamics 365 Developer. I really wanted to take this technical exam because in the past all exams were based on configuration, customization and functional modules. For those like me who have a focus on the technical aspects, this exam is really interesting … Continue reading Exam MB-400: Microsoft PowerApps + Dynamics 365 Developer – My Experience and Study Guide

3 basic tips to remember during Plugins development

Below are some basic tips that I always recommend to use during the development of plugins to increase the stability and robustness of the code: 1 - Use context.depth property Useful to check all those situations in which the code in a plugin causes the activation of the same plugin generating a loop! 2 - … Continue reading 3 basic tips to remember during Plugins development

How To set up your first PowerApps Custom Component project

Scenario: after seeing in the previous post the requirements you need to develop the custom control with PowerApps Component Framework PCF now we will see how to set up your first custom component project. Solution: when you develop a custom control you need following these steps: 1 - Create a new folder for your components: 2 - Open … Continue reading How To set up your first PowerApps Custom Component project

Basic things you need to develop the custom control with PowerApps Component Framework PCF

Scenario: after seeing in the previous post How To install PowerApps CLI (command line interface) to create, debug and deploy custom components using PCF now we will see the basic things you need to develop your first custom control with PowerApps Component Framework PCF. Solution: When you develop a custom control you need to know the basic architecture … Continue reading Basic things you need to develop the custom control with PowerApps Component Framework PCF

How To install PowerApps CLI (command line interface) to create, debug and deploy custom components using PCF

Scenario: after seeing in the previous post How To configure Node.js and Typescript into your environment to develop PowerApps Component Frameworks (PCF) now we will see how to install PowerApps CLI to create, debug and deploy custom components. Solution: to use Microsoft PowerApps CLI, do the following: Configure Node.js and TypescriptInstall Visual Studio 2017 or laterInstall Microsoft PowerApps … Continue reading How To install PowerApps CLI (command line interface) to create, debug and deploy custom components using PCF

How To configure Node.js and Typescript into your environment to develop PowerApps Component Frameworks (PCF)

Scenario: in this post we will see how configure Node.js and Typescript into your machine to develop your first custom component (PCF). Solution:  installing TypeScript we install the TypeScript compiler tsc. The compiler is the main component you need to compile your TypeScript code into JavaScript that will be sent to the browser to execute: Currently … Continue reading How To configure Node.js and Typescript into your environment to develop PowerApps Component Frameworks (PCF)

How To create a simple Canvas app calculator in PowerApps using text inputs and buttons

Scenario: after seeing in the previous post how to navigate between screens now we will see how to create a simple calculator. Solution: go to PowerApps Studio and add a new screens on App, after, insert also 3 Text Inputs (for number 1, number 2 and the result) and 5 Buttons (for math operators and reset) like this structure: … Continue reading How To create a simple Canvas app calculator in PowerApps using text inputs and buttons

How To navigate between screens in Canvas PowerApps

Scenario: after seeing in the previous post how to create a blank Canvas App in PowerApps now we will see how to add a simple transition from one screen to another in Canvas App. Solution: go to PowerApps Studio and add two new screens on App, after, insert also one Button and one Label on each screen to … Continue reading How To navigate between screens in Canvas PowerApps

How To create a blank Canvas app in PowerApps

Scenario: after seeing in the previous post how to create a new PowerApps environment now we will see how to create our first blank Canvas app. Solution: go to PowerApps portal https://web.powerapps.com, select the correct PowerApps environment, then select Solutions from the left panel and Common Data Service Default Solution in order to insert our … Continue reading How To create a blank Canvas app in PowerApps

How To choose between Canvas Apps and Model-driven Apps – The main differences

Scenario In this post we will see the main differences that allow us to establish the type of app to use when we want to create an app in PowerApps. Solution By reading the following features, you can easily determine which direction to take before you start developing your app. FEATURECANVAS APPMODEL-DRIVEN APPBusiness Scenario More … Continue reading How To choose between Canvas Apps and Model-driven Apps – The main differences