Power FX Guides teaches you Power FX functions in the Power Platform with clear, module-based lessons on syntax, use cases, and real-world examples to help you build better apps, automate tasks, and manage data effectively.
Power FX Guides is a comprehensive course designed to help you master Power FX, the low-code formula language used across the Microsoft Power Platform. Each module breaks down a specific Power FX function, explaining its purpose, syntax, and practical applications with real-world examples. Whether you're building apps in Power Apps, automating tasks in Power Automate, or working with data in Dataverse, this course will equip you with the skills needed to write efficient formulas and enhance your solutions. Perfect for beginners and experienced users alike, Power FX Guides offers a structured approach to learning one function at a time, empowering you to create more dynamic and powerful applications.
Course Outline ( Free Preview)
Power FX Guides - What You Need to Get Started
Before you get started, be sure to download the class files linked below. These resources will help you follow along with the lessons and practice the Power FX functions covered in the course.
Module 00 - Introduction
Welcome to the Power Apps Power FX Functions course! This series will guide you through essential functions to help you build more dynamic and efficient apps. Get ready to explore key tools for data management, interaction, and user feedback.
Module 01 - Data Manipulation
Unlock the power of data manipulation in Power Apps using essential Power FX functions. This module covers SubmitForm, Patch, UpdateIf, and Remove, helping you streamline data entry, updates, and deletions in your apps. Gain hands-on experience with dynamic form submissions, conditional data updates, and efficient record management.
What You'll Learn:
- How to submit data using SubmitForm for streamlined form handling.
- Using Patch to modify existing records and create new ones.
- Applying UpdateIf for targeted data updates based on conditions.
- Removing data effectively with the Remove function.
Module 02 - Collections9 min.
Explore how to manage data collections effectively in Power Apps using essential Power FX functions. This module covers ClearCollect, Collect, and Clear, empowering you to create, modify, and reset data collections for dynamic app experiences. Learn how to leverage these functions for better data storage and interaction.
What You'll Learn:
- How to create and store data with Collect.
- Using ClearCollect to create and reset collections simultaneously.
- Clearing data efficiently with the Clear function.
Module 03 - Viewing Data16 min.
Discover how to retrieve and display data effectively in Power Apps using powerful Power FX functions. This module covers Lookup, Filter, Search, Sort, and SortByColumns, giving you the tools to create interactive data views with precision and clarity. Enhance your apps by controlling how data is accessed, filtered, and presented.
What You'll Learn:
- How to retrieve specific records with Lookup.
- Filtering data dynamically using the Filter function.
- Implementing Search for flexible data exploration.
- Sorting data with Sort and SortByColumns for improved clarity.
Module 04 - Variables9 min.
Learn how to manage variables effectively in Power Apps using essential Power FX functions. This module covers UpdateContext and Set, helping you control and store temporary data for enhanced app performance. Master the basics of working with variables to create dynamic, interactive apps.
What You'll Learn:
- How to create and update local variables with UpdateContext.
- Using Set to define and manage global variables.
Module 05 - Miscellaneous3 min.
Enhance user experience with dynamic notifications using the Notify function in Power Apps. This module teaches you how to create custom messages for success, error handling, and user guidance to keep your app users informed. Learn to improve feedback visibility with flexible notification styling and timing.
What You'll Learn:
- How to display success, warning, and error messages with Notify.
- Customizing notification appearance and duration.
Module 06 - Class Wrap Up0 min.
Congratulations on completing the Power Apps Power FX Functions course! You've gained valuable skills to enhance your app development and create more powerful, interactive experiences. Keep practicing and exploring new ways to apply what you've learned!
Brian Knight is the Founder and CEO of Pragmatic Works, where he has spent his career helping organizations accelerate technology adoption and turn innovation into measurable business results. A successful entrepreneur, author, and business leader, Brian has built multiple companies and has become a trusted advisor to organizations seeking to modernize their operations through data, analytics, cloud technologies, and artificial intelligence.
Known for his ability to bridge the gap between emerging technology and practical business value, Brian is passionate about democratizing technology and making complex concepts accessible to a broader audience. His work has helped thousands of professionals and organizations successfully adopt new technologies, develop modern data cultures, and create lasting competitive advantages through innovation.
Brian is the author of 20 technical books and has delivered presentations at hundreds of business and technology conferences around the world. Through his writing, speaking, and leadership, he advocates for expanding access to technology education and helping organizations build the skills needed to thrive in a rapidly changing digital landscape.
Beyond his professional accomplishments, Brian is deeply committed to philanthropy and community impact, investing his time and resources in initiatives that support education, workforce development, and charitable causes. His leadership philosophy centers on empowering people through knowledge, creating opportunities for growth, and ensuring that technology serves as an enabler of positive change for individuals, organizations, and communities.
Brian's contributions to business and technology have earned numerous recognitions, including honors from state leadership, industry organizations, and the press, such as the Business Ambassador Award and recognition as a Top CEO. Today, he continues to guide Pragmatic Works' mission of helping organizations successfully adopt emerging technologies while making those technologies more accessible, understandable, and impactful for everyone.
