Dataverse, canvas and model-driven Power Apps and Automate

Discover Power Apps licensing, including premium and developer plans, and learn to sign up with a work email to access development environments with Power Apps, Power Automate, and Dataverse.

Learn why a work email is required for signing into Power Platform and how to obtain a free work email using a Microsoft 365 Business Basic trial.

Create a new developer environment in the Power Platform admin center, configure region and Dataverse settings, deploy sample data, and switch from the default environment for the course.

Create a model-driven app from the account table, exploring forms, views, and relationships to display and edit data. Publish, run, customize views, filters, and columns to tailor the app experience.

Create and edit an unmanaged solution in a development environment, then export to a managed package. Add existing components, create publishers, and manage removals without deleting components.

Discover how Copilot helps create an orders table in the Dataverse via the Power Apps portal, add columns, adjust data types, and generate sample data.

learn to create a Dataverse table outside a solution by building an orders table and an items ordered table, defining a primary column, data types, and required fields.

Create a Dataverse table inside an unmanaged solution using new table and advanced properties, then add item quantity (decimal) and unit price (currency) columns and include all objects and metadata.

Learn how to save and publish a canvas app in power apps, including naming, versioning with publish this version, save as, and viewing or editing the published app in apps.

Create a payment method choice column in the orders table, listing PayPal, credit card, debit card, cash, and check, with local or global scope and a default.

Link two tables by creating a lookup column or a relationship, then configure many-to-one relations and referential behaviors such as delete options.

Explore creating a calculated column with Power Fx, using item quantity and unit price to compute total price, while managing currency fields, data types, and column naming with apostrophes.

learn to create keys in Dataverse to enforce uniqueness, including single and compound keys, and improve performance, with a practice activity linking documents and document revisions.

Create a solution in the Power Apps portal, add two tables with required columns, define a department choice, establish a many-to-one relationship, enforce uniqueness on document number.

Create a model-driven app from the Dataverse order table using the Power Apps portal and the model-driven app designer, then configure navigation, areas, and pages and publish.

Learn to create and configure forms in a model-driven app, including main, quick view, quick create, and card forms, adjust field visibility, tabs, and sections, and publish customizations.

Configure auto number in a model-driven app by converting the order number field to auto number, selecting a prefix, digits, and seed, then mark it read-only on the form.

Modify the order form to add item quantity, unit price, total price, and a subgrid of related items, and tailor views for efficient management in power apps and dataverse.

Enable the quick create form on the item ordered table, configure its pane with item name, quantity, and unit price, then publish to stay on the order page.

Configure access to main forms through form settings, assign security roles, set a fallback form, and define order to prioritize the forms shown to users.

Explore how timeline controls display activities from tables with type activity, including appointments, calendar entry, emails, and notes, in a model-driven app, and switch forms by security group permissions.

learn to customize and manage views in model-driven apps by adding columns, editing, saving, and publishing personal and public views, and using filters, sorts, and related table lookups.

Learn to add a quick view form to a main item ordered form, configure lookups, display order details, and compare with a subgrid within a model-driven app.

Practice activity guides you to build a model-driven app for document and revision tables in the MAS Practise Activity solution, configuring dataverse tables, forms, views, and quick create features.

Create a solution named MAS practise activity three and four, build an employee table with auto number, add leave requests, define lookups and relationships, and enforce unique employee numbers.

Create and customize a model-driven app with Dataverse tables for employee and employee leave requests, including forms, views, a subgrid, and a quick create form to manage leave data.

Complete the model-driven apps course with Power Apps and Dataverse, reviewing Dataverse solutions, tables, forms, and views. Pursue the Microsoft Applied Skills credential through practise activities and an interactive lab.

Create canvas apps with Power Apps from scratch or templates, then configure the gallery, detail, and input screens. Practice tasks and an assessment reinforce data connections and Dataverse concepts.

Create a canvas app from Dataverse data in the Power Platform, using the Accounts table to build a gallery, details page, and basic edit and add actions.

Save your accounts canvas app to preserve edits, then publish the new version for shared users, and note how canvas apps differ from model-driven apps in layout versus data focus.

Create a canvas app from scratch using a phone layout, configure a gallery, detail screen, and input screen, and connect to a Dataverse or Excel data source.

Learn to add a vertical gallery to a canvas app, connect to a Dataverse data source, and configure layout fields (title, subtitle, body, image) while adjusting app orientation and size.

Format the label in a gallery using the text property to show row data. Explore applying formatting with Copilot and power fx, including country: Ukraine and ID 001.

Create a mobile phone canvas app from blank, connect to employee data in Dataverse, and customize layout and fields in Power Apps. Publish and prepare for expansion to multiple screens.

Create a second screen with a display form, connect to the address books data, bind to the browse gallery's selected item, and test navigation to the details screen.

Explore how English and non-English locales affect Power Apps formulas, including navigate usage, decimal separators, and argument separators shifting from dot to comma to semicolon and two semicolons.

Navigate between browse and detail screens using the OnSelect event, implementing navigate(detail screen) and back with optional screen transitions such as uncover right or fade.

Practice activity 6 guides you to add a display form to a canvas app, connect it to Dataverse employee data, arrange fields, and implement navigation with transitions, then test.

Create an edit screen with a linked edit form. Include id, first name, last name, email, street number, street name, city, country, with save and back navigation.

Master form and field validation in Power Apps, using on success, on reset, and on failure with notify messages, enforcing data types and required fields through card and table properties.

Enhance your app interface by adding a text label and rectangles, copy-paste across detail and browse screens, and use an Excel-style IF to switch between new form and edit form.

Add refresh, trash, and sort icons to a dataverse AddressBooks gallery, use sort by columns to sort by first name, and update context to toggle ascending and descending.

Add a search box to filter the address books gallery using text search, across first name, country, and last name; then combine with sort by columns and publish the app.

Build and link an edit form to a gallery item. Add navigation icons, submit and cancel actions, and refresh data across browse, detail, and edit screens.

Build an employee canvas app in Power Apps, adding a trash delete action, last-name sorting with a toggle, and a multi-field search across first name, last name, department, and email.