Power FX Cheat Sheet for Commands in Model-Driven Apps
Image Source: Shutterstock.com
Jan 1, 2023 4:54 PM

Power FX Cheat Sheet for Commands in Model-Driven Apps

External Blog Post

A Power FX cheat sheet with frequently used scenarios and examples on Model-Driven App Command customizations.

What is Power Fx?

Power Fx is a programming language and toolset used to create custom expressions and formulas in the Microsoft Power Platform. It is used in various Power Platform tools, including Power Apps, Power Automate, and Power BI, to define logic and calculations in custom apps, workflows, and data models.

Power Fx is based on the Excel formula language, which means that it uses many of the same functions and operators as Excel. It also includes additional functions and features specific to the Power Platform.

Power Fx allows users to create complex expressions and formulas using a combination of functions, operators, and variables. It is a powerful tool for defining calculations and logic in custom apps, workflows, and data models, and can be used to create advanced solutions for a wide range of business needs.

Power FX Cheat Sheet for Commands in Model-Driven Apps

The article by Frederik Engseth provides a cheat sheet / examples for common Power FX snippets and can be used as reference for your own scenarios.

Table of Content

  • Prerequisite
  • Setting up a Trial Environment
  • Notifications in a Model-Driven App
    • Create a Success Dialog and Notification Message
    • Create an Abort Dialog and Notification Message
    • Notification Banners
  • Visibility Formulas in Model-Driven App
    • Show or Hide Commands in a List View
    • Hide a Command Commands During Record Creation
    • Show Commands Based on Record Data
  • Patch Function (Update And Create)
    • Create a Related Record on the Current Record
    • Update Current Record
    • Update Multiple Selected Records in a Grid
    • Update Multiple Selected Records with Dialog and With Certain Criteria
  • Navigation
    • Navigate to the Default View of the Table
    • Navigate to Specific System View of the Table
    • Open Multiple Records in a New Tab
    • Open Selected Records in Brønnøysundregisteret
  • Conclusion
  • Resource Links

Links from the article

Further information about Power Fx