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

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • 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.
  • 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.
  • 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.
  • Learn how to use imperative vs. declarative development.

    This module explains how to:

    • Understand imperative vs. declarative development.
    • Understand the variables in Power Apps.
    • Understand when to utilize each of the three different types of variables.
  • With some Power Apps canvas apps, a form isn't the solution. This module focuses on how to perform custom updates when your data isn't in a form.

    This module explains how to:

    • Use the Patch function to update your data.
    • Understand how the Defaults function is used to create new records with Patch.
    • Use the Remove and RemoveIf functions to delete records.
    • Determine whether to use Clear and Collect or ClearCollect in their scenario.

Syllabus

  • 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
    • Exercise- Using the ForAll function in a gallery
    • Module assessment
    • Summary
  • 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
  • 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
  • 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
    • Module assessment
    • Summary
  • Perform custom updates in a Power Apps canvas app
    • Sometimes you need something more than forms
    • Use the Patch function to create and edit records
    • Delete records from data sources and collections
    • Use the Patch function to update a Gallery
    • Module assessment
    • 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.