This article is contributed. See the original author and article here.

Today the Power Platform introduces its open-source language for low-code, Microsoft Power Fx. This formula-based language originates from Microsoft Excel and is already the foundation of the Microsoft Power Apps canvas. You may wonder, why does the world need a low-code programming language? Point-and-click tools are great for quickly assembling experiences and workflows, but many apps need a layer of logic that goes beyond what is practical to drag and dropfor example:  


Show a list of customers who signed up in the last 7 days within 15 miles of this location.  


Highlight the newest entries in green.  


When a user clicks for more details, if the record has outstanding action items associated with it, pop those to the top of the screen. 


riduncan_0-1614383870670.png


Custom logic traditionally needed to solve such problems is where low-code platforms have “hit a cliff” requiring traditional code, where the Low-code application development on Azure solution has stepped in. Power Fx enables many millions of people globally who build with Microsoft Excel syntax to build custom logic, reducing much of the “cliff”. However, this does not reduce the integration capabilities of Azure and Power Apps but enhances them. 


 


Additionally, developers can use Power Fx with tools they are familiar with such as VS (Visual Studio) Code, GitHub, Azure DevOps, and it works with “pro-code” components created in JavaScript, C#, or other professional languages. Developers can cut development time and costs using Power Fx. The complexities of asynchronous coding are taken care of, Dataverse entities and data types are first class objects, and guardrails prevent run away code and other common pitfalls. Read the entire Power Fx announcement here. 

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.