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

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • Enhance and customize your Power Apps canvas app with easy-to-write formulas. Learn how to change formats, do math calculations, and implement conditional formatting.

    This module explains how to:

    • 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.
  • Learn how to enhance and customize your Power Apps canvas app using basic formulas.

    This module explains how to:

    • Understand True and False.
    • Control the visible property with a formula.
    • Control the display mode with a formula.
    • Combine formulas into a single statement.
  • 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

  • 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
    • Module assessment
    • Summary
  • 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
    • Module assessment
    • Summary
  • 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
    • Module assessment
    • 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.