Microsoft Power Apps: Using the Dataverse (Formerly the Common Data Service)
1h 4mIntermediate2021-05-20
Authors

Gini von Courter
Teaching computer classes on Microsoft Office for 20+ years
Course details
The Microsoft Dataverse is a customizable universe of table and column definitions developed by Microsoft as part of an open data initiative with Adobe and SAP, aimed at creating a collection of standard business entities. Formerly called the Common Data Service, the Dataverse provides consistency when developing applications, storing data within an organization, managing data transfers between organizations, and makes it easier to develop business applications. In this course, Gini von Courter shows how to use the Dataverse to create data-rich applications for Dynamics, SharePoint, and Office 365. She covers topics like how to set up Dataverse, create data flows between applications, and create basic apps using Power Apps. As Gini shows, using a Dataverse database means you don't need to spend as much time designing a data structure, and instead can focus on building applications and workflows.
Skills covered
DynamicsPower AppsOffice 365Business IntelligenceData ScienceBusiness Analysis and StrategyMicrosoftDeep Dive (X:Y)
Concepts
Introduction
- Build apps more easily with Microsoft Dataverse
- What you need for this course
Introduction
- Microsoft Dataverse - The basics
- Make a canvas app using the Dataverse
Work with Dataverse Tables and Relationships
- Explore Dataverse tables and columns
- Create a custom table using Power Apps
- Add customize text and choice columns
- Add a relationship to a custom table
- Customize views
- Create a table using Power Query
Customize Tables with Calculated Columns and Rules
- Define a calculated column
- Edit a calculation to add a condition
- Delete a column
- Business rules - The basics
- Create a business rule condition
- Add actions to a business rule
- Save and activate the business rule
Conclusion
- Next steps