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 Teams is the home for the modern workplace of the future

-
W hile using legacy systems, users previously had to jump between several different systems through a series of bookmarks or company portals. This constant switching can be incredibly disruptive. According to a June 2015 UC Irvine study, “The Cost of Interrupted Work: More Speed and Stress,” it can take upwards of 23 minutes for a person to regain productivity after such an interruption. Microsoft Teams is the hub for teamwork Microsoft believes Microsoft Teams is the home for the modern workplace of the future. Out of the box, Microsoft Teams brings together the most common tasks that employees need under a single roof, such as chats, meetings, calls, and the productivity suite of Office 365. By combining these together into a sole product, employees can avoid having to constantly switch between various contexts. Instead, they can spend their time within a single team or channel that effortlessly brings together all the relevant information in-context. The Microsoft Power Platfo
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

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