Stefano Tempesta Power Platform Single integrated platform to

Stefano Tempesta

Power Platform Single integrated platform to build and consume end-to-end solutions for every organization Dynamics 365 Office 365 Standalone Apps Common Data Service for Apps (CDS for Apps) Microsoft Flow Power. Apps Common Data Model (CDM) Power BI Data connectors Common Data Service for Analytics (CDS for Analytics)

Sales User Interface (Web Client + UCI) Service API & SDK x. RM Business Rules, Sync Workflow Code Plugins Database (Entities, Relationships, etc. ) Power. Apps + CDS Marketing Dynamics 365 State in the past – three platforms Talent Finance & Operations AX Platform User Interface (Power. Apps player) CDS SDK Microsoft Flow Common Data Service + Common Data Model (Entities, Relationships, etc. ) Gateways & Connectors

Marketing Sales Service Talent Dynamics 365 Today since the April ‘ 18 Release Finance & Operations Power Apps CDS + CDM (Entities, Relationships, etc. ) Power Apps XRM Code Plugins Microsoft Flow XRM API & SDK User Interface (Power. Apps player) Business Rules & Sync Workflow Power Apps XRM User Interface (Web Client + UCI) XRM Power. Apps + CDS for Apps AX Platform Gateways & Connectors

Common Data Model Navigator https: //github. com/Microsoft/CDM

Data Integration with the Common Data Model

Move data into CDS with the Data Integrator • Part of Power Apps Admin portal • Must have a Dynamics 365 or Power. Apps P 2 license • Power Query enables 20+ external sources

Data Integration Platform Field Mapping Power Query Connection Set Task Project Template Custom Template Execution History

Templates • Pre-built mappings used as starting definition for projects • Each template contains one or more tasks • Microsoft provides templates for common scenarios • You can create templates by saving a project as a template

From Templates to Projects Task #1 Field mapping #2 Field mapping #. . . Task #2 Field mapping #1 Field mapping #2 Field mapping #. . . Connection Set Connections Organization Mapping

Project • Set of mappings along with Connections (Executable) • Contains one or more entity mappings (task per entity) • Projects are visible to user who created it • Project can be shared as template

Save Project as a Template • Allows you to save your custom project mappings as a template • Project must be valid to be saved as a template • Choose visibility of User (default) or Organization

Project execution modes • Projects can be executed in two modes • Interactive - Run now • Scheduled - Run periodically • At a point of time only one execution of project can run • Notifications

Execution history

What data is synchronized? • First run is a full run • By default subsequent runs are delta runs • Ability to force full runs • Ability to re-run jobs • Ability to only run failed records – Coming soon!!

Click on Advanced Query

Adding Conditional Columns

Specify Conditions

Data Concatenation and Splitting

Date function

Filtering

Data Sources