Microsoft Dataverse for Power Apps/Power Automate developers

Name: Microsoft Dataverse for Power Apps/Power Automate developers
Rating: 4.5 (1212 reviews)

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

Bestseller

Created byAlireza Aliabadi

Last updated 3/2024

English

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

Course content

7 sections • 57 lectures • 8h 34m total length

Introduction1:06
Join Microsoft Dataverse for Power Apps and Power Automate developers with instructor Alireza Aliabadi, a Microsoft solutions architect, and discover why Dataverse is the most requested topic.
Course structure and required licenses4:21
Why Dataverse?2:30
This course is for beginners, but not all beginners1:51

How Dataverse fits inside Power Platform Environment7:49
Creating a new environment and adding elements to it - Part 110:52
Creating a new environment and adding elements to it - Part 26:16
Create a cloud flow in a new Power Platform environment, connect Outlook via a connection reference, and bundle a Dataverse table, app, and flow in a solution ready for export.
Managed vs Unmanaged solutions8:50
Compare managed and unmanaged dataverse solutions, showing that unmanaged solutions allow edits and deletion of contents, while managed import only and restrict changes across dev, QA, UAT, and prod.
Test your knowledge - Environment, Data space, Solution

What we are going to learn in this section1:19
Learn how Dataverse tables work, including the advantages of out-of-the-box standard tables over custom ones, and explore table types, columns, and data types for Power Apps and Power Automate.
Understanding Dataverse table types - Standard tables7:33
Dataverse Activity tables7:44
Using Dataverse virtual table in PowerApps9:21
Test your knowledge of Dataverse tables
Dataverse Elastic tables (grab a coffee, sit back and enjoy)7:51
Explore elastic tables in Dataverse and how they differ from standard tables. Learn about elastic scaling, flexible Json columns, and time to live data policies for large workloads.

Introduction to Dataverse data types2:13
Create the basic solution to work with simple data types6:12
Dataverse Text data type... not as complicated as it looks8:36
How to use Collect and Patch for Dataverse text and rich text fields14:28
Check your knowledge of text data types
How much can you rely on PowerApps regular expressions?8:49
Learn to validate emails in Power Apps with regular expressions using isMatch and custom patterns before sending data to Dataverse.
Let PowerApps do the validations that Dataverse doesn't16:28
Text formats in Dataverse
Basics of Dataverse numeric types6:51
Explore Dataverse numeric types—whole numbers, decimal, float, currency, duration, time zone, and auto number—and learn why choosing the right type upfront matters, since changing types needs a new column.
Using Dataverse numeric types in PowerApps16:02
Working with Dataverse "Time zone" column (Part 1)15:39
Working with Dataverse "Time zone" column (Part 2)20:02
Did you learn time zone?
Date and time field challenges in Power platform12:19
Insert and update into a date-time field13:09
Filtering Dataverse table based on the values of date field11:36
Learn to filter a Dataverse table by date using a range: start date and end date plus one, avoiding time parts and delegation issues.
Remaining challenges with date data type4:18
Date data type filter knowledge test

Understanding confusions about date time field and time zone9:57
Working with Dataverse date and time field from Power Automate 1/210:48
Working with Dataverse date and time field from Power Automate 2/210:27
Dataverse choice - Yes/No data type in PowerApps 1/219:23
Dataverse choice - Yes/No data type in PowerApps 2/25:04
Dataverse choice - Yes/No in Power Automate flow9:37
Explore using yes/no fields in Dataverse with Power Apps and Power Automate, focusing on OData filters with the logical name and boolean true/false values.
Comparing Lookup and Choice fields - Which one to choose?13:15
Lockup vs Choice fields
Filtering and displaying Dataverse table based on Choice field 1/214:21
Filtering and displaying Dataverse table based on Choice field 2/28:12
Learn to filter a Dataverse table by a multi-select province choice field in Power Apps, handle delegation by using a variable, and prepare for OData filtering in Power Automate.
Inserting and updating a Dataverse choice field from PowerApps12:42
Learn to insert and update Dataverse choice fields from Power Apps using code, including single and multi-selects for car color and province, with patch, collect, and filter techniques.
Inserting and updating a Dataverse choice field from Power Automate4:53
Learn how to insert and update a Dataverse choice field from Power Automate, including using single-select car color values and multi-select provinces via codes and comma-separated values.
Dataverse choice fields
Lookup in Dataverse is a unique data type9:46
Filtering a Dataverse table in PowerApps for a lookup field8:34
Filtering a Dataverse table in Power Automate for a lookup field11:18
Learn to filter a Dataverse lookup in Power Automate using OData, distinguishing logical and schema names, and implement exact and contains filters for department lookups.
Insert and update on Lookup field - PowerApps7:53
Insert and update on Lookup field - Power Automate7:26
Dataverse lookup field - Check your knowledge
Understanding "File/Image" column in Dataverse14:16
Explore the file and image subtypes in Dataverse, their size limits, and how to configure a file column and upload via the attachments control, including image thumbnails.
How to "Patch" a "File/Image" column in Dataverse8:44
Insert an image/file to Dataverse using Power Automate8:17
Filter Dataverse table for file name in PowerApps2:58

Typical Dataverse developer challenge2:01
Create a solution to secure and deploy - Part 114:18
Secure a Dataverse table inside a solution by configuring app read/write access and two flows, automated and instant, using connection references and a simple inventory example.
Create a solution to secure and deploy - Part 29:43
Adding security roles to a solution with Dataverse11:24
Importing Dataverse managed solution to new environment with security roles9:54
Import a managed Dataverse solution into a new environment, configure connection references, verify security roles, assign users to appropriate roles, and note licensing requirements for flows.
How to get your next course for free4:49

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.

Who this course is for:

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

Microsoft Dataverse for Power Apps/Power Automate developers

What you'll learn

Explore related topics

Course content

Course roadmap and licensing requirements4 lectures • 10min

Understanding Environment, Database, Solution and tables4 lectures • 34min

Dataverse tables, columns and data types5 lectures • 34min

Dataverse less challenging column Data types14 lectures • 2hr 37min

Dataverse column data types that can challenge you20 lectures • 3hr 18min

Dataverse views and relationships4 lectures • 30min

Deployment and permission settings for Dataverse tables6 lectures • 52min

Requirements

Description

Who this course is for: