Microsoft Dataverse for Power Apps/Power Automate developers

Explore how Dataverse fits inside a Power Platform environment, including environments, Dataverse data stores, tables, and unmanaged solutions that deploy together across environments.

Create a new environment, add Dataverse data source support, a table and a basic app, then add a solution with the table, app, and a flow, and export the solution.

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.

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.

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.

Understand dataverse table types, focusing on standard tables as the vanilla option. Custom tags mark tables you created; note that table type is fixed after creation; to switch, migrate data.

Discover dataverse activity tables, their built-in columns, and how they differ from standard tables; learn to track daily activities like emails and appointments via insert and update.

Explore how a Dataverse virtual table mapped to a SharePoint list can speed Power Apps development. Use the virtual table as a category lookup to streamline data entry.

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.

Explore Dataverse data types, from easy ones like text, number, date and time, currency, and auto number to challenging lookup, choice, and file types, using PowerApps with collect and patch.

Create a Dataverse solution with a sample item table and a canvas PowerApps app, connect a gallery to the table, and implement insert and update actions for data types.

Explore Dataverse text data types in PowerApps, showing that only two forms exist—single line and multiple lines—and how max character counts and basic validation do not enforce formats.

Enable rich text in edit forms and validate fields Dataverse won't validate. Insert and update text and rich text with collect and patch; display as HTML text.

Learn to validate emails in Power Apps with regular expressions using isMatch and custom patterns before sending data to Dataverse.

Build a Power Apps form linked to Dataverse, validate corporate emails with a regular expression, and disable submit until the email is valid.

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.

Explore dataverse numeric types in power apps by comparing integer and decimal fields, enforcing min-max ranges, converting text with value, and using collect and patch for insert and update operations.

Learn to build an event calendar in Dataverse by modeling time zones as IDs and mapping them to definitions, then use PowerApps to insert and display time zones with lookups.

Learn to work with the Dataverse time zone column by using combo boxes and dropdowns to store and display time zone codes, bind forms, and insert or edit records.

Navigate date and time challenges in the Power Platform, including time zone differences, universal time in Power Automate, and date versus date time handling in Dataverse and Power Apps.

Learn to insert and update a date-time field in a Dataverse table using a date picker or text input, with date value converting text to date for updates.

Learn to filter a Dataverse table by date using a range: start date and end date plus one, avoiding time parts and delegation issues.

Explore the remaining challenges of the date data type in Dataverse, including server versus user time zones in Power Automate and Power Apps, and the divergence of date values.

Explore how Dataverse stores date and time in UTC and how time zones affect Power Apps and Power Automate, highlighting the mismatch between them.

Create a dataverse table with date and time fields, one user local and one time zone independent, and build a power apps app with a flow to insert values.

Learn how to manage Dataverse date and time fields from Power Automate by converting local times to UTC using standard time zone names and a flow.

Master the Dataverse yes/no field in Power Apps, using boolean true/false values. Filter records, update data, and customize edit forms with a toggle in Power Automate.

Practice manipulating a yes/no choice field in Dataverse within Power Apps by collecting and patching records, using lookup to map boolean values, and previewing Power Automate integration.

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.

Compare lookup and choice fields in Dataverse, explain differences, and show when to use each, including single versus multi select and whether choices are local or global.

Learn to display and filter Dataverse choice fields in Power Apps and Power Automate, including multi-select provinces with concat and single-select colors, using gallery and data table views.

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.

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.

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.

Discover why the lookup field is a unique, powerful Dataverse data type, how it pulls values from related tables, and how it supports relationships in Power Apps and Power Automate.

Discover how to filter a Dataverse table by a lookup field in Power Apps using delegation-friendly techniques. Filter by department name, budgets, and text searches while avoiding delegation warnings.

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.

Learn how to insert and update a lookup field in Power Apps using a combo box, respecting row count limits, and applying collect and patch with a selected item.

Learn how to insert and update a lookup field in Dataverse using Power Automate, using the related record’s OData ID.

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.

Patch a file or image column in Dataverse using a display form bound to a gallery. Upload and patch a new image from an attachment control to the selected record.

Create a row in the Dataverse table t_demo_files, then update it with the file content using Power Automate's upload a file or an image action.

Filter a Dataverse table in PowerApps by a file name using the plainText function to compare strings. Learn about delegation and why OData filters aren’t used here.

Explore Dataverse relationships and views, understanding different relationship types and how lookup relies on them, while using the visual designer to design your app solution.

Explore Dataverse relationships, including one-to-many, many-to-one, and many-to-many via bridges, and learn to model them with the designer and crowfoot ERD.

Learn to create and manage Dataverse views, use the view designer to sort and filter data in one-to-many tables, publish views, and apply them in Power Apps.

Connect a PowerApps app to the Dataverse individuals table and use views such as young to old or old to young to sort data by age.

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 cloud flow that returns the lowest inventory item from a Dataverse table by sorting by item count, then call it from a Power Apps app for secure deployment.

Learn how to secure a Power Platform solution by configuring Dataverse security roles and permissions, managing dependencies and connection references, and exporting a managed solution.

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.

Finish a course and share your certificate on LinkedIn to earn a free next course. Learn how to claim the voucher from your Udemy profile and select it.