Microsoft PowerApps: Using the Common Data Service

Microsoft PowerApps: Using the Common Data Service

1h 23mIntermediate2019-03-21

Authors

Gini von Courter

Gini von Courter

Teaching computer classes on Microsoft Office for 20+ years

Course details

With the Common Data Service for Apps (CDS for Apps), you can securely store your organization’s data and use it to create mobile-first business apps that also run in browsers. This cutting-edge tech—based on a partnership between Microsoft, SAP, and Adobe—allows you to use prebuilt and custom entities to store data in a way that makes the most sense for your business. In this course, Gini shows how to use and customize the Common Data Service for Apps for use with the Power Platform to create data-rich applications for Dynamics, SharePoint, and Office 365. She explains how to set up CDS, build new apps, define entities and relationships, create data flows between applications with business rules, and create environments and databases using CDS for Apps.

Learning objectives
Recall the URL for the PowerApps portal.
Recognize the template used to create a three-screen mobile app from existing data.
Name the default type of entity ownership.
Determine the type of relationship between two entities.
Identify the prefix for Microsoft Dynamics entities.
Explain where PowerApps business rules run, even on canvas apps.
Recognize an example of an artifact type of component.

Skills covered

DynamicsPower AppsOffice 365Business IntelligenceData ScienceBusiness Analysis and StrategyMicrosoftDeep Dive (X:Y)

Concepts

Introduction

  • Build powerful apps using the Common Data Service
  • What you need for this course

Use the Common Data Service (CDS)

  • The Common Data Service - The basics
  • Log in to PowerApps
  • Make a canvas app using CDS for apps
  • Save your app

Work with CDS Entities and Relationships

  • Explore the CDS entities
  • Create a custom entity in PowerApps
  • Add and customize text fields and option groups
  • Add a relationship to a custom entity
  • Customize views and forms
  • Add data to an entity using Power Query
  • Dynamics 365 and the Common Data Service

Work with CDS Fields and Logic

  • Define a calculated field
  • Edit a calculation to add a condition
  • Delete a field
  • Add fields to support the business rule
  • Add a condition to a business rule
  • Add actions to a business rule
  • Validate, save, and activate the business rule
  • Preview a model-driven sample app
  • Edit a model-driven app in the app designer

Set Up an Environment

  • Create an environment
  • Create a CDS for Apps database

Conclusion

  • Next steps
40,000 Toman