Tuesday, December 7, 2021

Power Fx – a low code programming language for Power Platform

Must read

Vesa Nopanenhttps://myteamsday.com/
MVP for Office Apps & Services (Teams & Collaboration focus), Principal Consultant in Office 365 and Modern Work. Extremely passionate about Microsoft Teams's power to change how people work together. Helping and coaching customers to find benefits, solutions and value when adopting new tools, methods, ways or working and practices into daily work-life equation. I am always eager to challenge current situation and dig out new possibilities and ways to think and work. You could describe me as a jack of all trades but my main focus area and deep personal driver is Microsoft Teams since it has changed the way I work and did a giant step forward to make it possible to work from anywhere - the location does not matter even us much as it mattered before. Microsoft Teams opened the path for many organizations to rethink their practices, worklife, culture and start the change. That's why I am very passionate about Teams.

Striking news at Microsoft Ignite 2021 Spring – announcement about Power Fx, which is going to be the low code programming language for Power Platform. When a lots of enterprise application development is already in the low-code category it is clear to see why Microsoft is investing in this area. It is very much needed and is changing the world every day.

Power Fx – A unified formula language for logic customizations for the Power Platform

Power Fx is not Excel in Power Platform shoes even when some design principles share the similarities with Excel formulas – they are not connected. Excel formula language is followed closely (structure, data types, operators and functions) so it is familiar and easy to learn to those power users using Excel more and thus making the transition to Power Platform easy for them – say instead of updating a single Excel file they create an app for that.. The other key principle taken from Excel-world to Power Fx is that formulas automatically re-calculate when the dependency changes. Just like Excel formulas.

Key things

  • Open-source language that will be available for everyone to use and implement
  • Leverage the knowledge of Excel users -> easy to start creating business applications to Power Platform
  • Mix and match simplicity via formulas with code
  • Recalculates automatically when dependency changes –> don’t have to worry about polling for changes. Just like in Excel spreadsheet.
  • Begins with Power Apps but will be integrated across the Power Platform (Power Virtual Agents, Power Automate, Power BI)

Power Fx Formula: Fill = RGBA( RedSlider.Value, GreenSlider.Value, BlueSLider.Value, 100% )


  • Microsoft Blog Posts
  • Watch Microsoft Ignite sessions to learn more

More articles

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest articles