Menu
Microsoft’s Power Fx low-code language channels Excel

Microsoft’s Power Fx low-code language channels Excel

The no-code, low-code language already leveraged in Power Apps will be extended across the entire Power Platform.

Credit: Dreamstime

With its Power Fx language introduced this week, Microsoft is making a play in the low-code development realm.

Announced on March 2, the general purpose language is based on the Microsoft Excel spreadsheet and spreadsheet-like formulas, sharing Excel syntax and functions.

With Power Px, Microsoft is attempting to provide citizen developers with an approachable way to express logic. Power Fx already is in use across Microsoft’s Power Platform. Documentation on the language can be found on GitHub.

The language spans from “no code” imperative programming to “pro code” situations involving strongly typed, declarative, and functional code. Similar to Excel, Power Fx formulas instantly recalculate, like a spreadsheet.

Freed from keeping variables and data tables up to date manually, developers can tell the app what they want it to do without having to describe how or when. Apps can be edited in text editors including Visual Studio Code.

Power Fx will be extended as a singular, consistent language across the Power Platform during the next two years. The language already has been extended to work with hundreds of external data sources, across mobile devices, and through advanced application scenarios, Microsoft said.

Plans also call for extending Power Fx to Microsoft’s Dataverse, Power Automate, Virtual Agents, and elsewhere. Microsoft stressed there is still a lot of work to do to extract Power Fx from Power Apps. Users can share their thoughts about Power Fx on the project’s GitHub repo.

While low-code development platforms have been considered solutions for quick-to-assemble business apps, with professional developers taking on more sophisticated tasks with full-fledged languages, low-code platforms also can be leveraged for integrations and mobile experiences. Some of these platforms have included Mendix and Appian.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags ExcelMicrosoft

Events

Why experience is the new battleground for partners

Join us for an exclusive webinar, in association with Hewlett Packard Enterprise and Technology Services Industry Association (TSIA) and learn about the latest industry insights and how technology services continue to evolve to deliver differentiated value, and how partners can be successful in 2021 and beyond.

Featured

Slideshows

Channel kicks 2021 into gear as After Hours returns to Auckland

Channel kicks 2021 into gear as After Hours returns to Auckland

After Hours made a welcome return to the channel social calendar with a bumper crowd of partners, distributors and vendors descending on The Pantry at Park Hyatt in Auckland to kick-start 2021.

Channel kicks 2021 into gear as After Hours returns to Auckland
The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

Hundreds of leaders from the New Zealand IT industry gathered at the Hilton in Auckland on 17 November to celebrate the finest female talent in the Kiwi channel and recognise the winners of the Reseller News Women in ICT Awards (WIICTA) 2020.

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards
Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

The leading female front runners of the New Zealand ICT industry joined together for the annual Reseller News Women in ICT Awards event at the Hilton in Auckland, during which hundreds of guests celebrated 13 outstanding individuals who won awards, chosen from more than 50 finalists representing over 30 organisations.

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards
Show Comments