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

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)

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

How To configure Dynamics 365 customer engagement apps into existing PowerApps environment

Scenario In the previous post we saw How To create a PowerApps environment with Common Data Service (CDS) database, now we will see how to configure Dynamics 365 Customer Engagement apps into this existing PowerApps environment. Solution Go to the Power Platform Admin Center portal https://admin.powerplatform.microsoft.com, select Environments from the left panel and then select your Environment from … Continue reading How To configure Dynamics 365 customer engagement apps into existing PowerApps environment

How To create a PowerApps environment with Common Data Service (CDS) database

Scenario In this post we will see how to create a PowerApps environment with connected database of Common Data Service (CDS) containing only the core entities defined by the Common Data Model (CDM) to store the data of your apps. Solution Go to the PowerApps Admin Center portal https://admin.powerapps.com, select Environments from the left panel … Continue reading How To create a PowerApps environment with Common Data Service (CDS) database