Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Use advanced formula techniques and custom updates in Power Platform

Microsoft via Microsoft Learn

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

Reviews

Start your review of Use advanced formula techniques and custom updates in Power Platform

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.