Dataverse For Power Apps And Power Automate Developers

Unlock the Power of Dataverse: Build, Manage, and Automate with Ease

What you'll learn

Understand what Dataverse is and when we should use it

Microsoft Dataverse building components

Importing from and exporting data to Dataverse

Working with Dataverse tables (Create, customize, add/remove/update records)

Table relationships inside Dataverse

Dataverse table columns (Choice, Autonumber, Calculated)

Creating and working with Views

Deploying Dataverse tables using Solutions

Requirements

Familiarity with Microsoft Power Apps

Basic understanding on Database concepts

Description

Welcome to our online course, "Dataverse for Power Apps and Power Automate developers." This course is your guide to understanding how to use Dataverse with the Power Platform to make powerful and flexible apps.We start with the basics, showing you how Dataverse works with Power Platform. You'll learn how to set up your own space in Dataverse, the difference between two types of solutions (managed and unmanaged), and get to know the various kinds of tables and data types Dataverse has.Step by step, we'll walk you through using different tables in Dataverse, like standard, activity, virtual, and elastic tables. We'll explore how to work with different kinds of information, such as text, numbers, dates, and more. Plus, we'll show you how to make your apps smarter with PowerApps and Power Automate, two tools that work well with Dataverse.This course is packed with practical lessons. You'll learn how to deal with text, work with numbers, and manage dates and times in your data. We'll also dive into choices and lookup fields, and how to use them in your apps. By the end of the course, you'll also understand how to link tables, control who can see your data, and move your solutions from one place to another safely.No matter if you're new to Dataverse or looking to get better at using it, this course will give you the tools and knowledge you need. Join us to make your data management easier and your apps more powerful with Dataverse in the Power Platform.

Overview

Section 1: Course roadmap and licensing requirements

Lecture 1 Introduction

Lecture 2 Course structure and required licenses

Lecture 3 Why Dataverse?

Lecture 4 This course is for beginners, but not all beginners

Section 2: Understanding Environment, Database, Solution and tables

Lecture 5 How Dataverse fits inside Power Platform Environment

Lecture 6 Creating a new environment and adding elements to it - Part 1

Lecture 7 Creating a new environment and adding elements to it - Part 2

Lecture 8 Managed vs Unmanaged solutions

Section 3: Dataverse tables, columns and data types

Lecture 9 What we are going to learn in this section

Lecture 10 Understanding Dataverse table types - Standard tables

Lecture 11 Dataverse Activity tables

Lecture 12 Using Dataverse virtual table in PowerApps

Lecture 13 Dataverse Elastic tables (grab a coffee, sit back and enjoy)

Section 4: Dataverse less challenging column Data types

Lecture 14 Introduction to Dataverse data types

Lecture 15 Create the basic solution to work with simple data types

Lecture 16 Dataverse Text data type… not as complicated as it looks

Lecture 17 How to use Collect and Patch for Dataverse text and rich text fields

Lecture 18 How much can you rely on PowerApps regular expressions?

Lecture 19 Let PowerApps do the validations that Dataverse doesn't

Lecture 20 Basics of Dataverse numeric types

Lecture 21 Using Dataverse numeric types in PowerApps

Lecture 22 Working with Dataverse "Time zone" column (Part 1)

Lecture 23 Working with Dataverse "Time zone" column (Part 2)

Lecture 24 Date and time field challenges in Power platform

Lecture 25 Insert and update into a date-time field

Lecture 26 Filtering Dataverse table based on the values of date field

Lecture 27 Remaining challenges with date data type

Section 5: Dataverse column data types that can challenge you

Lecture 28 Understanding confusions about date time field and time zone

Lecture 29 Working with Dataverse date and time field from Power Automate 1/2

Lecture 30 Working with Dataverse date and time field from Power Automate 2/2

Lecture 31 Dataverse choice - Yes/No data type in PowerApps 1/2

Lecture 32 Dataverse choice - Yes/No data type in PowerApps 2/2

Lecture 33 Dataverse choice - Yes/No in Power Automate flow

Lecture 34 Comparing Lookup and Choice fields - Which one to choose?

Lecture 35 Filtering and displaying Dataverse table based on Choice field 1/2

Lecture 36 Filtering and displaying Dataverse table based on Choice field 2/2

Lecture 37 Inserting and updating a Dataverse choice field from PowerApps

Lecture 38 Inserting and updating a Dataverse choice field from Power Automate

Lecture 39 Lookup in Dataverse is a unique data type

Lecture 40 Filtering a Dataverse table in PowerApps for a lookup field

Lecture 41 Filtering a Dataverse table in Power Automate for a lookup field

Lecture 42 Insert and update on Lookup field - PowerApps

Lecture 43 Insert and update on Lookup field - Power Automate

Lecture 44 Understanding "File/Image" column in Dataverse

Lecture 45 How to "Patch" a "File/Image" column in Dataverse

Lecture 46 Insert an image/file to Dataverse using Power Automate

Lecture 47 Filter Dataverse table for file name in PowerApps

Section 6: Dataverse views and relationships

Lecture 48 What is this section about?

Lecture 49 Dataverse relationships

Lecture 50 Creating and working with Dataverse views

Lecture 51 Using Dataverse views inside PowerApps

Section 7: Deployment and permission settings for Dataverse tables

Lecture 52 Typical Dataverse developer challenge

Lecture 53 Create a solution to secure and deploy - Part 1

Lecture 54 Create a solution to secure and deploy - Part 2

Lecture 55 Adding security roles to a solution with Dataverse

Lecture 56 Importing Dataverse managed solution to new environment with security roles

Lecture 57 How to get your next course for free

Power Platform developers who want to use Dataverse as their solution data source,Developers who build large scale solutions on Microsoft Power Platform