PowerApps coding made easier with AI based PowerFx

-

Absolute treat for the developers, as Microsoft is integrating AI technologies with its PowerFx low-code programming language. PowerFx, an open-sourced, formula-based tool, is built on Microsoft Excel. This integration will enable customers to use natural-language input and "programming by example" techniques when developing with PowerApps.

Microsoft announced the coming new capabilities during the opening day, May 2021 developers conference. Officials said these new features will be in public preview at the end of June in certain regions.

Microsoft is using GPT-3 (Generative Pre-trained Transformer 3) and the Program Synthesis Using Examples (PROSE) software development kit. GPT-3 is a natural-language AI model from OpenAI, an organization with which Microsoft has been collaborating for a while. The PROSE technology comes from Microsoft Research and is already integrated into Power BI, Excel, and Visual Studio.

Officials said the integration of GPT-3 in Power Apps represents the first time GPT-3 is being integrated into one of its own commercially available products. GPT-3 is running on Azure and is powered by the Azure Machine Learning Service. (Microsoft has a license to the code behind the GPT-3 model which allows it to integrate the GPT-3 technology directly into its own products.) Specifically, this  GPT-3 natural-language capability uses a new Azure Machine Learning feature announced at Build called managed endpoints to help with the deployment of models of all sizes in Azure without having to manage the underlying compute infrastructure.

Microsoft is portraying the kinds of scenarios that natural-language integration into PowerFx and Power Apps will provide as enabling a whole new level of "being able to code in plain English." Before today's development, Microsoft's Power Platform users still needed to understand the basic logic of writing formulas. But now they can type commands like "Show 10 orders with a certain product in the name and arranged from newest to oldest purchase" and get the same result.

OpenAI released last year an Azure-power programming interface that allowed developers to check out GPT-3's capabilities. Microsoft officials said they plan to bring GPT-3 integration into Azure and other mainstream products. Officials already said they plan to integrate Power FX with other parts of the Power Platform, and the new natural language features powered by GPT-3 will be part of this at that time.

Prometix as a Microsoft Gold certified partner and certified O365 consultants (Sydney, Canberra, Melbourne & Perth), we have extensive experience in delivering Office 365 based solutions. We have completed Power Platform rollout for large to medium organisations including state/federal governments & private sectors. For more information, please contact us from enquiries@prometix.com.au

Comments

Post a Comment

Popular posts from this blog

Microsoft 365 Records Management Compliance

-
As a SharePoint consulting practice, we at Prometix had a chance to implement a Microsoft 365 Records Management service This is a fairly new service and Microsoft announced in May the commercial release of the Microsoft 365 Records Management service. This service, which lets organisations apply "labels" to documents, as well as machine learning to automatically apply those labels, is designed to address legal compliance tracking issues for organisations. Microsoft claims it'll help demonstrate compliance with regulations through defensible audit trails and proof of destruction. This will assist in integrating with Business Intelligence such PowerBI, and artificial intelligence such as Azure services. The Records Management service is currently available through the  Microsoft 365 Compliance Center . Organisations need to have Microsoft 365 E5/A5 or Microsoft 365 Insider Risk Management licenses to use the service, which gives them the rights to automatically apply ...
Read more

Collaboration with SharePoint VS MS Teams

-
With all the hustle and bustle of the workplace, it can be hard to find exactly what you’re looking for or know who to ask. Defining who is working on what and how they’re involved in the project isn’t always a simple task. Although SharePoint has made managing and sharing content easier, it still isn’t as seamless as its end users would hope. Being able to access content and applications all in one place is useful but doesn’t solve the problem of how to organize information that is only relevant to certain groups. The main goal of SharePoint is to facilitate collaboration, but when content is broadcasted to the entire organization, it can make end users unsure which information applies to them. Microsoft has acknowledged this issue with the creation of its new collaboration tools, SharePoint team sites and Microsoft Teams . These allow end users to create separate areas specifically designed for certain projects they’re working on and for the teams they’re working with. By organizi...
Read more

Data Governance with Azure Purview

-
Image
The modern workplace his a data-centric world. Organisations are always increasing the amount of data they must collect, store, and analyse to inform critical business decisions and measure their organisation’s performance. As data becomes increasingly important, so do the tools needed to discover, manage, and track information in the absence of a data governance program. In the absence of a data governance program, the decisions made about key data systems are made by association staff who “own” the system. When there are different owners for systems (which is very common), the result is inconsistencies in data availability, collection, usability, integrity, and security. This instantly causes data quality problems. It also can negatively impact user experience if there is no integration or procedures to update the existing data within your environment. If you and your organisation find yourselves in such a predicament, Prometix highly recommends deploying an Azure Purview solution....
Read more