The Integration Story with Microsoft’s Power Platform: Common Data Services for Apps, Dynamics 365 for Finance and Operations and Talent
Power Platform consists of CDS 2.0, Microsoft Flow, PowerApps & PowerBI. Learn how to best leverage Power Platform with end-to-end Dynamics 365 integration.
Table of Content
The new version of Common Data Service, which is referred to as CDS for Apps (CDS 2.0), is extremely powerful — and when integrated with Microsoft Flow, PowerApps, PowerBI, and Dynamics 365 the results are unparalelled. In this post, we will walk through the steps to create, integrate, and test a complete Dynamics 365 integration using the Microsoft Power Platform.
How to create the Power Platform environment (CDS for Apps environment)
The first step is to make sure you have a suitable environment created and setup in the Power Platform environments tab. For this testing and demonstration, I have created a new environment specifically for a Dynamics 365 for Talent to Dynamics 365 for Finance and Operations integration. This environment is where the Dynamics 365 for Talent app will surface the data and this environment will also host all the associated PowerApps, CDS, Microsoft Flow, etc.
Link the Dynamics 365 for Talent Project
Once you have the Power Platform environment setup, the next step is to create the D365 for Talent project in Microsoft Dynamics Lifecycle Services. You should then provision the Dynamics 365 for Talent environment. To do this, login to Lifecycle services (LCS) and create a new project.
Link the Lifecycle Services (LCS) project to Power Platform
Link the LCS project to the new Power Platform environment created (shown above). Navigate to the Talent app managementtile and click Add button.
You will notice the environment created in the Power Platform admin center will appear here.
Mark the “Include demo data” checkbox so that the D365 for Talent environment will have some pre-populated demo data to use for testing.
Syncing Dynamics 365 for Talent with CDS
The new D365 for Talent environment should now be provisioned with demo data and you should see the status of the environment as “Deployed”. Now, it is time to access the newly deployed D365 for Talent environment to make sure you are able to access the required components of Talent successfully. To do so, click the “Log on to Talent” link in the Talent App Management area. As shown below, I now have the D365 for Talent environment successfully deployed and ready for testing.
After this deployment, you will notice that Talent solutions (shown below) will appear under the Solutions tab of the PowerApps environment. The data from the Dynamics 365 for Talent environment syncs in real time with the CDS. This means all the components of the D365 for Talent solution were successfully deployed into the CDS environment.
As you can see, the demo data from the D365 for Talent app has already surfaced in the CDS entities.
Integrating Dynamics 365 for Finance and Operation with D365 for Talent
On the other side, I have already deployed my Dynamics 365 for Finance and Operations environment which is ready for the integration with D365 for Talent.
The next step is to configure the Connection Set in the Power Platform admin center, which essentially defines the 2 environments/applications and their respective organizations/entities for data mapping and integration.
In the example below, I have created the Connection Set which contains my D365 for Finance and Operations environment and the CDS 2.0 environment.
To configure the data integration project, go to Power Platform admin center and create the data integration project as shown below.
Under the data integration project, select the connection set configured earlier. The example above leverages a data integration template called Core HR, which is an out-of-the-box template provided by Microsoft.
If you go into the tasks of the integration project, you will notice that for each of the tasks, the source and destination data fields are already predefined in the template. If you want, you can modify the mappings based on your needs, or you can even extend the integration by creating your own tasks to integrate additional entities.
All the environments and the integration configurations are now in place. The next step is to create some data in the Core HR App of D365 for Talent. For this example, I will run the integration project manually. Ideally, you would have the integration execute automatically on a regular basis.
Note: I am not using the ATTRACT or ONBOARD apps of D365 forTalent in this demonstration/testing, but if you are using either of those, the data from both of those applications surface directly in CDS 2.0 (Common Data Service). The Core HR app syncs in almost real-time with CDS 2.0.
Testing the D365 for Finance and Operations and D365 for Talent Integration
I have created a job named “D365 Tech Architect” in D365 for Talent as shown in screenshot below.
Running the data integration project from Power Platform
The next step is to run the data integration project manually from the Power Platform admin center and verify that the data syncs correctly to Dynamics 365 for Finance and Operations.
You can monitor the status using the Execution history tab.
As shown below, as the new job record was created in D365 for Talent it surfaced in the CDS Job entity. The data integration project execution has now finished.
The new job record should have automatically populated in Dynamics 365 for Finance and Operations.
Using Attract and Onboard Apps
When you use the Attract and Onboard apps in Dynamics 365 for Talent, they surface/store the data by default to the Common Data Service (CDS 2.0). The Core HR app of D365 for Talent then automatically syncs the Attract/Onboard data from CDS in real-time. When your data integration project runs in PowerApps, the data from CDS will sync to Dynamics 365 for Finance and Operations.
Leveraging the Power Platform
It is time for Dynamics 365 users to start leveraging the power of the Power Platform. There are new Power Platform features that Microsoft is introducing every month. These features will continue to enhance and further enable users to extend and integrate Dynamics 365 and other business apps apps in a low code, no code fashion.
How can you innovate and leverage the Power Platform to work for your business?
You can learn more about all the features of Power Platform, here.
Supply chain management (SCM) is a big deal. After all, a well-managed supply chain enables you to maintain a competitive advantage, tackle complex challenges, and capture new opportunities. It’s also an expansive, complex strategy spanning everything from procurement and shipping to manufacturing, inventory, and supplier relations. In this article, we’ll explain what SCM is, why…
For patients, home healthcare services are, well, regular healthcare services – delivered in a different (read: more convenient) way. For providers, venturing into the field means taking on way more than most businesses – either in the healthcare space or more traditional field services orgs – are prepared to handle. That means, you’re juggling all…
Supply chains have been with us for most of human history — like, deep BCE, early agriculture days. Even after thousands of years, they still manage to dominate headlines. Minor disruptions can take down massive global economies – sowing discord and uncertainty on a level only natural disasters and large-scale conflicts can compete with. So,…