Power Fx: Introduction

Description

Duration: 1 day

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
Individuals who want to take their Power Apps and Power Automate applications and flows to the next level.

Prerequisites
Power Apps: Introduction for End Users or equivalent.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands-on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
9/23/20249/23/2024
10/14/202410/14/2024
11/4/202411/4/2024
11/25/202411/25/2024
12/16/202412/16/2024
1/6/20251/6/2025
1/27/20251/27/2025
2/17/20252/17/2025
3/10/20253/10/2025
3/31/20253/31/2025
4/21/20254/21/2025
5/12/20255/12/2025
6/2/20256/2/2025
6/23/20256/23/2025
7/14/20257/14/2025
8/4/20258/4/2025
8/25/20258/25/2025
9/15/20259/15/2025
10/6/202510/6/2025
10/27/202510/27/2025
11/17/202511/17/2025
12/8/202512/8/2025
12/29/202512/29/2025
1/19/20261/19/2026

Curriculum

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