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
Category: Power Apps
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
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
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
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