Why Microsoft’s New Open‑Source Low‑Code Language Power Fx Matters

Microsoft open‑sourced Power Fx, a low‑code language introduced at the Ignite developer conference, aiming to let developers create powerful services with minimal code and becoming the fifth component of the Microsoft Power Platform.

The Power Platform comprises Power BI for data analysis, Power Apps for building internal applications, Power Automate for workflow automation, and Power Virtual Agents for chatbots, all emphasizing a no‑code/low‑code approach.

Power Fx uses an Excel‑like formula syntax, offering strong typing, declarative and imperative capabilities, state management, and more than 128 built‑in functions—over 60 % of which mirror familiar Excel functions—facilitating both citizen‑developer and professional development.

According to Microsoft manager Greg Lindhorst, Power Fx is the core language of Power Apps and enables developers to express logic as simply as adding a spreadsheet, promoting collaboration across teams.

The language is designed to describe business logic concisely, often fitting complex commands into a single line, with the goal of requiring no more concepts than those known to Excel users.

Microsoft plans to roll Power Fx out across the entire Power Platform—including Power Automate, Power Virtual Agents, and Dataverse—within two years, making it the platform’s single language.

Ryan Cunningham explains that while click‑based tools handle simple tasks, scenarios such as “customers who logged in within the last seven days and are within 15 km” need custom logic that Power Fx provides.

When business logic outweighs coding expertise, Power Fx expands the pool of people who can build complex solutions and offers expert tools like text‑editor editing and source‑control integration.

Microsoft views open‑sourcing Power Fx as the next step in low‑code innovation, encouraging developers to use and contribute to the project.

Source: IT之家