Menu
Microsoft is teaching AI to write apps for users

Microsoft is teaching AI to write apps for users

Look for natural language to become more and more pervasive across Microsoft's tools and services.

Credit: Dreamstime

Microsoft is using the power of GPT-3’s natural language artificial intelligence (AI) to help people who don’t know how to code write their own software using Microsoft’s PowerApps development platform, unveiled at Microsoft’s Build developer conference.

Redmond has hoped that PowerApps would become a powerful corollary to its Office suite, but the platform has languished a bit. Microsoft originally set up PowerApps in 2015 around a set of programming templates, pulling data from user-defined sources and then outputting results.

Think of it like the next level of a traditional macro in Microsoft Office—it’s a way for an average user to write a program to instruct Windows to perform a task, but with minimal or no knowledge of program coding.

The problem is that even what Microsoft calls a “low code” or “no code” approach can be time-consuming and complex. So Microsoft is turning to simply telling the app what to do, using the GPT-3 AI model to translate an example like, “Find products where the name starts with ‘kids’,” into the code PowerApps understands.

Microsoft said at Build that it has taken a licence to GPT-3, and the technology will be presumably integrated elsewhere over time. The first product to include it will be PowerApps, but we’ve already seenAI infuse related apps like Microsoft Flow.

Credit: Microsoft

According to Charles Lamanna, corporate vice president of Microsoft’s low-code application platform, a user who wanted to use PowerApps might not have needed to understand how to code a program, but they needed to understand the way in which a program is put together, and the terminology used.

For the average user, constructions like irstN(Sort(Search(‘BC Orders’, “stroller”, “aib_productname”), ‘Purchase Date’, Descending), 10). would go way over their heads.

Using the GPT-3 natural language model, that would look more like “Show 10 orders that have stroller in the product name and sort by purchase date with newest on the top,” Lamanna wrote in a blog post. What will happen is that when a user tells PowerApps what to do, PowerApps will then construct an expression and then run it against the data. It will be up to the user, however, to interpret the results.

Microsoft has turned toward an AI-driven approach in other products in its Office 365 suite; in Excel, for example, the search box at the top used to say, “What do you want to do?” The phrasing has reverted back to a generic “search” but the AI capabilities remain intact.

Microsoft says that the Power products affiliated with its PowerApps platform will be the first to receive the GPT-3 AI upgrades, but that the technology could be extended to other areas. If it simplifies Microsoft’s Office suite, we’re all for it.


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 MicrosoftAI

Events

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
Show Comments