Use basic formulas to make better Power Apps canvas apps

Go to class
Write Review

Free Online Course: Use basic formulas to make better Power Apps canvas apps provided by Microsoft Learn is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge.

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