From spreadsheet to Power Fx

Imagine crafting an app with the same ease as creating an Excel worksheet. What if you could harness your existing spreadsheet expertise for app development? Power Apps and Power Fx were born from these questions, aiming to empower millions of Excel users to build apps, automation, virtual agents, and more using familiar concepts.

Power Fx is an expression-based language, similar to other programming languages that use expressions to represent calculations. We will describe an example with the basics of the language but consider that it is a general-purpose functional programming language. You can create variables (velocity or time would be your variables), use operators (in this example, * operator multiplication), and any functions (such as the Round example to round up if the next digit is 5 or higher). For instance, the following expression represents the multiplication of velocity and time:

Velocity * Time

However, Power Fx takes this concept...