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

Microsoft

Use basic formulas to make better Power Apps canvas apps

Microsoft via Microsoft Learn

Overview

  • Module 1: Want to enhance or customize your Power Apps canvas app? You can use easy-to-write formulas to make changes in your app that include changing the format or position of controls, do simple math calculations, or implement conditional formatting in your design.
  • In this module, you will:

    • Understand the basics of how to use formulas in a canvas app
    • Change the format of a date control
    • Use a formula to do simple math calculations
    • Change the position of an icon using a formula
    • Understand how to implement conditional formatting in canvas apps using a formula
  • Module 2: Learn how to enhance and customize your Power Apps canvas app using basic formulas.
  • In this module, you will:

    • Understand True and False
    • Control the visible property with a formula
    • Control the display mode with a formula
    • Combine formulas into a single statement
  • Module 3: Learn how to author a basic formula that uses tables and records in a Power Apps canvas app.
  • In this module, you will:

    • Understand tables and records in Power Apps
    • Understand how to use Collect and ClearCollect to make multi-column tables
    • Add a collection as a data source to a gallery
    • Filter your table of data
    • Use the LookUp function

Syllabus

  • Module 1: Create formulas to change properties in a Power Apps canvas app
    • Formulas overview
    • Use a formula to modify the format of controls
    • Use formulas to perform calculations
    • Use a control to modify the property of other controls
    • Conditional formatting
    • Functions for validating data
    • Check your knowledge
    • Summary
  • Module 2: Create formulas to change behaviors in a Power Apps canvas app
    • Formulas and functionality
    • Understanding true and false
    • Understanding control behaviors and actions
    • Performing multiple actions in a formula
    • Control the display mode through a formula
    • Use controls and functions to create a dynamic formula
    • Check your knowledge
    • Summary
  • Module 3: Author a basic formula that uses tables and records in a Power Apps canvas app
    • Records and tables
    • Using the Table function
    • Store a table
    • Filter your table
    • Use the lookup function to return a record
    • Additional table functions
    • Exercise - Use collections and manipulate tables
    • Check your knowledge
    • Summary

Reviews

Start your review of Use basic formulas to make better Power Apps canvas apps

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.