Microsoft Build 2021 recently made an exciting announcement by introducing Power Apps Ideas to create apps in Natural Language. It is one of the most advanced natural language AI models, known as OpenAI GPT-3. It is a dream come true for all citizen developers. Power Apps Ideas created to help customers ease the formula authoring experience by using AI models. It can now transform natural language into a Power Fx formula, and the OpenAI GPT-3 model can automatically generate Power Fx formulas based on natural language input. Power Fx — the open-source programming language for low code introduced by Microsoft earlier this year—makes it possible for hundreds of millions of people with Excel skills to add advanced logic to their apps.
Satya Nadella stated, “we’re adding GPT-3 and other Microsoft AI technology directly into Power Apps Studio in a way that will help every maker quickly build the apps they need and more easily learn advanced concepts in the process.”
For example, instead of figuring out how to write the following formula:
Sort(Search(‘Contacts’, TextSearchBox1.Text, “fullname”), ‘Created On’, Descending)
You can type in search Contacts with ‘Full Name’ in TextSearchBox1 and sort results by ‘Created On’ latest on top.
This feature is currently in the experimental phase, and it’s turned “Off” by default. To try it out, open an existing canvas app or create a new one, select Settings > Upcoming features, search for “Ideas,” and toggle Enable Ideas panel to “On.”
Once turned on, you’ll be able to see a new “Ideas” tab on the right side of the screen inside the Power Apps Studio, next to Properties and Advanced tabs. You can now start using Power Apps Ideas.
To see the demo refer to the following.
For example, you are working at an e-commerce vendor and want to sort your gallery to show ten orders for keyboards sorted by purchase date, with the newest on the top. For this, you can type a natural language statement.
[table id=4 /]
Power Apps will generate one or a few of the most relevant Power Fx formulas to select from based on this input and context from your apps, such as your table and controls.
PowerApps provide IntelliSense in the ideas box when you are typing your query in natural language.
Here are some tips to follow when writing the plain English query in the Power Apps Ideas pane to get the best results.
During this experimental release, Power Apps Ideas has the following limitations:
With AI-powered Ideas built directly into Power Apps Studio, now everyone from new makers to seasoned pros can create apps faster than ever before instead of spending significant time searching for, learning about, and debugging complex formulas. I hope you found this blog a good read.
Written by Priyanka Patel
Priyanka is Senior Software Developer at Evolvous Limited – specialists in Microsoft Technologies.