Power Fx is a low-code programming language built for accessibility, enabling non-technical users to develop custom applications and automate business processes through the Microsoft Power Platform. Drawing its foundation from Microsoft Excel's familiar formula language, Power Fx uses intuitive syntax and comprehensive functions that allow anyone to implement sophisticated business logic without traditional coding experience. This language has become essential for professionals seeking to extend and enhance their Power Apps and Power Automate capabilities.
Who Should Take This Class?
Professionals ready to advance their Power Apps and Power Automate applications to a more sophisticated level.
Prerequisites:
Power Apps: Introduction for End Users or equivalent knowledge.
Course Outline:
Understanding Power Fx Fundamentals
- Explore the advantages of using Power Fx
- Learn about the Microsoft Power Platform architecture
- Create your first application with Power Fx
Building Applications from Templates
- Add screens and UI controls to your app
- Work with data sources and data table structures
- Attach formulas to control properties
- Master the fundamental Power Fx formula syntax
Operators and Identifiers
- Use the "in" and "exactin" operators for comparison
- Apply ThisItem, ThisRecord, and As operators correctly
- Understand self and parent operator functionality
- Name identifiers appropriately
- Work with display names and logical names
- Handle name disambiguation scenarios
- Use the disambiguator operator effectively
Data Types
- Work with blank and null values
- Manage text, hyperlink, image, and media data types
- Reference image and media resources
- Format URIs for images and multimedia content
- Work with number and currency types
- Handle date, time, and DateTime values
- Use choices and yes/no data types
Working with Tables
- Understand table structure and components
- Create and manipulate table formulas
- Apply table functions and control properties
- Write behavioral formulas for tables
- Define and manage record scope
- Resolve disambiguation issues
- Work with single-column and inline tables
- Create inline records
Variables and Collections
- Translate Excel formulas into Power Fx equivalents
- Determine when to use variables effectively
- Declare and use global variables
- Understand different variable types
- Create and remove variables as needed
- Manage variable lifetime and initialization
- Read and access variable values
- Create and manage collections
Error Handling
- Get started with error handling strategies
- Understand error propagation in formulas
- Detect and observe errors during execution
- Report errors to users appropriately
- Stop execution after an error occurs
- Work with multiple simultaneous errors
- Handle errors in table operations
- Address data source errors
- Create custom errors for specific scenarios
- Use ErrorKind enumeration values
