Skip to main content

How to embed PowerFX in NET app

How to embed PowerFX in a .NET Application

PowerFX is a language from Microsoft aimed at power users. Writing PowerFX feels like Excel formulas, and one of the building blocks of PowerFX is actually “formulas” that are reactive to other formulas. Microsoft uses PowerFX mainly as the low code language for the PowerApps offering.

A few years ago, Microsoft open sourced PowerFX with the goal of letting others take advantage of the power and simplicity of the language. The main repo is located at https://github.com/microsoft/Power-Fx . The repo contains a link nice introductory video about the what, why and how of PowerFX (https://www.youtube-nocookie.com/embed/ik6k89WNjuk ).

If you are a .NET developer, you too can take advantage of the power and simplicity of PowerFX by embedding a .NET PowerFX Interpreter created by Microsoft. One use case for embedding PowerFX in a .NET app is to allow Business Users to define Business Rules in PowerFX and then integrate them into your app. This allows the Business users to maintain the rules while you maintain the hosting app.

To use the interpreter:

  1. Add the Microsoft.PowerFx.Interpreter NuGet to your project ( https://www.nuget.org/packages/Microsoft.PowerFx.Interpreter )
  2. Instantiate an object of type RecalcEngine.
  3. Add formulas by passing the formula as a string to the SetFormula method of RecalcEngine.
  4. Notice that adding Formulas does not execute them. To make the engine execute the formulas, call RecalcEngine’s Eval (or EvalAsync) method, passing a string representing the expression to execute. The expression can reference formulas added with SetFormula.

Here is the minimal C# example:

using Microsoft.PowerFx;
using Microsoft.PowerFx.Types;

var engine = new RecalcEngine();
// notice the escaped quotes as we are passing a PowerFX string literal. Our second parameter needs to be
// a valid PowerFX expression.
engine.SetFormula("MyName", "\"Juanito\"", OnFormulaUpdate);
engine.SetFormula("Greeting", "\"Hello, \" & MyName & \"!\"", OnFormulaUpdate);
var greetingResult = engine.Eval("Greeting");
Console.WriteLine(greetingResult.ToObject());
return;

void OnFormulaUpdate(string arg1, FormulaValue arg2)
{
// this method is called whenever the formula is evaluated by the engine
}

I have been working on a new app ( https://github.com/TheJuanitoLearnsShow/PuppyWorkbooks ) that allows users to maintain an executable workbook containing PowerFX formulas. The app and its tests provide examples of how to use the interpreter. The repo has examples of how to create your own PowerFX function to be used by PowerFX expressions, a future post will cover the steps on how to accomplish that.

Comments

Post a Comment

Popular posts from this blog

Mail labels and letter templates for jasperreports

The following are free (MIT license) mailing labels and letter templates for jasperreports that you can download and use in jasperserver and/or ireport: Update 3/15/2011 : I moved the Mail templates zip file here . Please consider making a small donation if the templates are of help to you, Thank you! If you need more information on how to use those templates please leave a comment in the blog.
14 comments
Read more

How to create online multiplayer HTML5 games in Contruct2

  Construct2 can use websockets to send and receive messages between games. By using socket-io , we can use a Node.js script as the server and my modification to the socket-io plugin for Construct2 to allow the games to synchronize data between them in real-time. There are two parts to this design: the Node.js server and the Construct2 clients (the games playing). The main part of building an online multiplayer HTML5 game is to plan: how the clients will communicate how often and what to communicate how much of the logic will go into the server and how much to the client. In my sample game, I chose to have each client own a player and have the server just relay messages: Use string messages in the form TypeOfMessage, Parameter1, Paremeter2, Parater3, etc to communicate. Have the clients send their player position about 16 times a second. Whenever their player shoots, the client needs to send a message immediately. Almost all of the game logic will...
9 comments
Read more

How to get the raw data posted to a Java Servlet

While working in porting GeneCMS to Google App Engine and Silverlight , I stumble at one annoying problem: how to get the raw data that was sent by the browser via a POST. In this GeneCMS port, the silverlight client actually generates all the HTML that the server used to generate. The raw generated HTML is then sent to the GAE application, with some metadata about the generated pages. The GAE servlet then reads the posted data as a string and extract the individual generated pages. Each generated page is then saved into the GAE database to allow the CMS to server the pages. After tweking around in the wrong places, I finally found out that HttpServletRequest’s getInputStream method is an input stream to the raw data posted. So I modified my servlet to get the POST data into a string like this: String posted_data = ""; BufferedReader in = new BufferedReader(new InputStreamReader( request.getInputStream())); String line = in.readLine(); while (line != null) { posted...
2 comments
Read more