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.

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

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.
Mark Hachman

Mark Hachman

PC World (US online)
Show Comments

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Tom Pope

Dynabook Portégé X30L-G

Ultimately this laptop has achieved everything I would hope for in a laptop for work, while fitting that into a form factor and weight that is remarkable.

Tom Sellers

MSI P65

This smart laptop was enjoyable to use and great to work on – creating content was super simple.

Lolita Wang

MSI GT76

It really doesn’t get more “gaming laptop” than this.

Jack Jeffries

MSI GS75

As the Maserati or BMW of laptops, it would fit perfectly in the hands of a professional needing firepower under the hood, sophistication and class on the surface, and gaming prowess (sports mode if you will) in between.

Taylor Carr

MSI PS63

The MSI PS63 is an amazing laptop and I would definitely consider buying one in the future.

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?