For the uninitiated, Power Fx is Microsoft’s open-source language for low code based on Microsoft Excel. It’s not entirely new as Microsoftannounced Power Fxearlier this year. What’s new is theGPT-3 integration for natural language transformation to Power Fx code.
Power Fx, part of Microsoft Power Apps, will make it possible for budding developers to use conversational language for programming. GPT-3 will help transform the natural language into a formula that Power Fx understands.
For example, users can just use a command like ‘Show 10 orders that have “stroller” in the product name and sort by purchase date with newest on the top’ and GPT-3 will automatically convert it to a PowerFx formula such as ‘FirstN(Sort(Search(‘BC Orders’, “stroller”, “aib_productname”), ‘Purchase Date’, Descending)’.
You can check out the feature in action below:Image: Microsoft
“Using an advanced AI model like this can help our low-code tools become even more widely available to an even bigger audience by truly becoming what we call no code,”saidCharles Lamanna, corporate VP for Microsoft’s low code application platform.
Microsoft says GPT-3 integration on Power Fx will be first available in preview. It is coming to English users in North America by the end of June. There’s no word on wider availability in other regions just yet.
Subin writes about consumer tech, software, and security. He secretly misses the headphone jack while pretending he’s better off with the wireless freedom.