Microsoft PowerApps: Using the Common Data Service

1h 23mIntermediate2019-03-21

Authors

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

0. Introduction

01 - Build powerful apps using the Common Data Service
02 - What you need for this course

1. Use the Common Data Service (CDS)

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

2. Work with CDS Entities and Relationships

07 - Explore the CDS entities
08 - Create a custom entity in PowerApps
09 - Add and customize text fields and option groups
10 - Add a relationship to a custom entity
11 - Customize views and forms
12 - Add data to an entity using Power Query
13 - Dynamics 365 and the Common Data Service

3. Work with CDS Fields and Logic

14 - Define a calculated field
15 - Edit a calculation to add a condition
16 - Delete a field
17 - Add fields to support the business rule
18 - Add a condition to a business rule
19 - Add actions to a business rule
20 - Validate, save, and activate the business rule
21 - Preview a model-driven sample app
22 - Edit a model-driven app in the app designer

4. Set Up an Environment

23 - Create an environment
24 - Create a CDS for Apps database

Conclusion

25 - Next steps