YoVDO

Use advanced formula techniques and custom updates in Power Platform

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Dataverse Courses YAML Courses Canvas Apps Courses

Course Description

Overview

  • Module 1: Do you have need for complex formulas in your app? This module can help you write those formulas.

    • In this module, you will:

    • Utilize formulas that process multiple records
    • Use the Concat function to combine text from multiple records
    • Utilize the Countrows, CountIf, ForAll
    • Perform math operations on data in a table
  • Module 2: Explore how you can use Power Fx formulas to work with Microsoft Dataverse choice and choices columns. These column data types present the user with a fixed list of values defined by the maker.

    • In this module, you will:

    • Discover the Choice field basics.
    • Learn when to use choice or lookups.
    • Filter data on choice values.
  • Module 3: Learn how to use Microsoft Dataverse relationships in canvas apps from Microsoft Power Apps.

    • In this module, you will:

    • Discover various Microsoft Dataverse relationship types.
    • Learn how to use one-to-many relationships.
    • Learn how to use many-to-many relationships.
  • Module 4: Learn how to use imperative vs. declarative development.

    • In this module, you will:

    • Understand imperative vs. declarative development
    • Understand the variables in Power Apps
    • Understand when to utilize each of the three different types of variables
  • Module 5: With some Power Apps canvas apps, a form is not the solution. This module will focus on how to perform custom updates when your data is not in a form.

    • In this module, you will:

    • Use the Patch function to update your data
    • Understand how the Defaults function is used to create new records with Patch
    • Utilize the Remove and RemoveIf functions to delete records
    • Determine whether to use Clear and Collect or ClearCollect in their scenario
  • Module 6: Learn how to unpack a canvas app from a single monolithic file to many files, each describing an individual part of the app.

    • In this module, you will:

    • Practice how to unpack and pack apps.
    • Learn how a canvas app is represented in YAML.

Syllabus

  • Module 1: Create formulas that use tables, records, and collections in a canvas app in Power Apps
    • Formulas that process multiple records
    • Math operations on tables
    • Combine and separate records
    • The ForAll function
    • Lab - Using the ForAll function in a gallery
    • Check your knowledge
    • Summary
  • Module 2: Use Dataverse choice columns with formulas
    • Introduction
    • Filter Dataverse choice columns with Power Fx formulas
    • Modify choice and choices values
    • Exercise - Dataverse choice columns
    • Check your knowledge
    • Summary
  • Module 3: Reduce complexity in your data model with Dataverse table relationships
    • Introduction
    • Work with one-to-many relationships
    • Work with many-to-many relationships
    • Exercise - Work with Dataverse relational data
    • Check your knowledge
    • Summary
  • Module 4: Use imperative development techniques for canvas apps in Power Apps
    • Imperative versus declarative development
    • The three types of variables in Power Apps
    • Global variables
    • Contextual variables
    • Collections
    • Additional variable concepts
    • Exercise - Using the variables and collections
    • Check your knowledge
    • Summary
  • Module 5: Perform custom updates in a Power Apps canvas app
    • Sometimes you need something more than forms
    • Using the Patch function to create and edit records
    • Deleting record(s) from data sources and collections
    • Using Patch function to update a Gallery
    • Check your knowledge
    • Summary
  • Module 6: Work with canvas app source code
    • Introduction
    • Exercise - Use source code to create an app and install tools
    • Work with YAML
    • Exercise - Use source code in Visual Studio Code
    • Check your knowledge
    • Summary

Tags

Related Courses

Use Power Platform for Custom & Automated Solutions
Microsoft via Coursera Microsoft Dynamics 365 and the Power Platform
LinkedIn Learning Microsoft Power Apps: Using the Dataverse (Formerly the Common Data Service)
LinkedIn Learning Microsoft Power Platform Fundamentals (PL-900) Cert Prep: 4 Power Apps by Microsoft Press
LinkedIn Learning Microsoft Power Platform Fundamentals (PL-900) Cert Prep: Power Apps
LinkedIn Learning