Well, lets me explain a bit further.
PowerApps is an online service of Microsoft to create small applications for mobile and web. The service is far from perfect but it works for small internal applications because it's easy to work with it.
However... we are talking about Microsoft.
First, Power FX is open source and it is not a lie.
The second point is "Power FX is based on Microsoft Excel" and it is a lie. The only similarity with Excel is that Power FX and Excel allows functions. Nothing more. Power FX is more close to JavaScript.
And the third point, "Power Fx is built for low code". 🤦♂️ No!. Power FX is high code in the concept it works for scripting and nothing else much. You can't compile it, you can't create an advanced program with it.
But, there is another point, Power FX is anything but new. I have used it for a couple of years.
If you are used Power Platform then you are found yourself working with the different styles of programming
Since it is similar to JavaScript, then it is easy to work with it. It is based in functions, so most operations are done using functions.
For example:
If a1 is equals to a2, then the variable is equals to v1, otherwise v2.
set(variable,if(a1==a2,"v1","v2"))
It is regional dependent.
For example, it is the code in a computer configured with EN-US.
set(variable,if(a1==a2,"v1","v2"));
set(variable,20)
And it is the same code for ES-ES
set(variable;if(a1==a2;"v1";"v2"));;
set(variable;20)
If you are using Power Apps then you already have worked with it. If not, then why? Power FX is (as of today) used in one application and not in every one of their variants.
Also, if you know JavaScript, then you know practically the whole language.
Types | PowerApps | JavaScript | Excel |
---|---|---|---|
integer | 20 | 20 | 20 |
string | "hello" | "hello" | "hello" |
arrays | [20,30] | [20,30] | nope |
objects | [name:"john",age:23] | [name:"john",age:23] | nope |
using fields | user.name | user.name | nope |