We have created the Power FX Cheat Sheet, as a downloadable “cheat sheet”, so that you have at hand, in one place, some of the most used formulas of Power FX.
It is a free resource that we provide you from Creativity Spark to make it easier for you to work quickly with Power Apps, Power Automate… in short, with the resources of the Power Platform.
Sign up for our newsletter now to stay up to date on the latest in Power Platform
But… What is Power FX?
It is a Microsoft programming language whose main characteristic is that it is low-code.
This will allow you to create and program your own apps in Power Apps in particular and in the rest of the Power Platform components in general.
In addition, it is an “open source” resource, which means that it is open to developers to introduce new features and improvements.
This programming language is strongly related to the Excel spreadsheet and some of the Power FX formulas coincide with Excel formulas, although there are many others; to start learning, similarity will be of great help if you are used to working with Microsoft spreadsheets.
Contents of the Power FX Cheat Sheet
In the downloadable you have the Power FX formulas arranged to form a booklet and be able to have it at hand. Below I show you some of the pages it contains.
And within each of the sections they are shown according to the different categories for example Mathematics, Logic, Text, … Some of the most commonly used formulas, for example:
Action: Patch, AddColumns, Filter, Set, ClearCollect
Math & Statistics: Average, Trunc, Count, Round,Power
Logical and Boolean: If, And, IfError, Switch, IsMatch
and so on with many others.
Request your Power FX Cheat Sheet now by writing to our email and we will send it to you ready to print and use; Write now to ycaltieri@creativityspark.es or send us this form:
And to learn, stay up to date and learn about the potential of Microsoft’s Power Platform tools, we recommend our tutorials on You Tube: Spark Labs and we also recommend you visit our blog.
And the official website: Microsoft Power Fx overview.