Course Details
Course Description:
The Power Fx: Introduction course teaches students how to use the Power FX coding language to build applications and set up process automation. Power Fx is a low-code programming language that is designed to be easy to use for non-technical users, allowing them to create custom applications and automate processes using the Microsoft Power Platform.
Power Fx is based on Microsoft Excel's formula language, which is a widely used tool for data manipulation and analysis. It uses a familiar syntax and offers a wide range of functions, making it easy for people to create complex business logic without having to write traditional code.
Who Should Take This Class
Students who want to take their Power Apps and Power Automate applications and flows to the next level.
What is Power Fx?
The benefits of using Power Fx
Understanding the Power Platform
Building your first app with Power Fx
Creating an app from a template
Adding screens and controls
Understanding data sources and data tables
Adding formulas to controls
Power Fx formulas
Operators and Identifiers
in and exactin operators
ThisItem, ThisRecord, and As operators
Self and Parent Operators
Identifier Names
Display Names and Logical Names
Name disambiguation
Disambuator Operator
Data types
Blank
Text, Hyperlink, Image, and Media
Image and Media Resources
URIs for images and other media
Number and Currency
Date, Time, DateTime
Choices and Yes/No
Tables
Elements of a Table
Table Formulas
Table Functions and Control Properties
Behavioral Formulas
Record Scope
Disambiguation
Record Scope
Single Column Tables
Inline Records
Inline Tables
Variables
Translate Excel into Power Fx
Know When to Use Variables
Use a Global Variable
Types of Variables
Create and Remove Variables
Variable Lifetime and Initial Value
Reading Variables
Use a Collection
Error handling
Getting Started
Error Propagation
Observing Errors
Reporting Errors
Stopping after an error
Working with Multiple Errors
Errors in Tables
Data Source Errors
Creating Your Own Errors
ErrorKind Enum Values
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
- Experienced Professional Instructor Trains Your Team
- Content Focused On Your Team's Needs
- Convenient Scheduling and Class Setup
- Significant Per/Student Cost Savings
- Online, On-Site and Blended Options Available
Virtual Live Instructor
Financing Available
Free Repeat
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private Power Platform group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Power Platform Private Group Training from Business Computer Skills can help your team.
