Custom Virtual Table provider with CRUD operations: Create, update, view, and delete records using a virtual table and final considerations – part 6 of 6

Hi, after creating a Virtual Table in the part 5, now in this last post of the serie I show you how to create a simple Model-Driven App that include this table so as to test everything! Let’s start with creating a New App: Next, add the Virtual Table to the sitemap with all default components: Finally, publish … Continue reading Custom Virtual Table provider with CRUD operations: Create, update, view, and delete records using a virtual table and final considerations – part 6 of 6

Custom Virtual Table provider with CRUD operations: Creating a virtual table in Dataverse environment – part 5 of 6

Hi, after creating Data Provider in the part 4, now in this fifth post I show you how to create a Virtual Table with all necessary fields and that use the Data Source. Let’s start with creating New Table: Make sure to check Virtual Entity box, select correct Data Source and give correct Schema Name used into … Continue reading Custom Virtual Table provider with CRUD operations: Creating a virtual table in Dataverse environment – part 5 of 6

Custom Virtual Table provider with CRUD operations: Creating data provider and adding plug-ins to the provider – part 4 of 6

Hi,after creating CRUD plug-ins in the part 3, now in this fourth post I show you how to create a Data Provider through Plugin Registration Tool and configure a Data Source. Make sure that you have the latest version of the Plugin Registration Tool that provides support for CRUD operations in Virtual Tables! Let’s start with registering New Data … Continue reading Custom Virtual Table provider with CRUD operations: Creating data provider and adding plug-ins to the provider – part 4 of 6

Custom Virtual Table provider with CRUD operations: Implementing CRUD plug-ins and registering the assembly – part 3 of 6

Hi,after creating a table on Azure SQL database in the part 2, now in this third post I show you how to create a Plug-in Project in Visual Studio to manage the integration with the data source. In this simple PoC, a single project has been created that containing all separtate classes. Let's start with … Continue reading Custom Virtual Table provider with CRUD operations: Implementing CRUD plug-ins and registering the assembly – part 3 of 6

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)