Master advanced formula techniques and custom updates

Go to class
Write Review

Free Online Course: Master advanced formula techniques and custom updates provided by Microsoft Learn is a comprehensive online course, which lasts for 4-5 hours worth of material. The course is taught in English and is free of charge.

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