YoVDO

Use basic formulas to make better Power Apps canvas apps

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft PowerApps Courses Data Validation Courses

Course Description

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

Tags

Related Courses

Automate Approval Process with SharePoint & Power Automate
Coursera Project Network via Coursera
Automate Doc Review Process with SharePoint & Power Automate
Coursera Project Network via Coursera
Automate Equipment Ordering Prep Process with Power Automate
Coursera Project Network via Coursera
Automize Business Communication using Power Automate
Coursera Project Network via Coursera
Automize Monthly Report Creation with Power Automate
Coursera Project Network via Coursera