Microsoft Power Platform

Last updated
Microsoft Power Platform
Developer(s) Microsoft
Initial release2018;6 years ago (2018)
Operating system Microsoft Windows
Type Business intelligence, app development, app connectivity, robotic process automation
License Proprietary software
Website microsoft.com/power-platform/

Microsoft Power Platform is a collection of low-code development tools that allows users to build custom business applications, automate workflows, and analyze data. [1] [2] It also offers integration with GitHub, Microsoft Azure, Microsoft Dynamics 365, and Microsoft Teams, amongst other Microsoft and third-party applications. [3]

Contents

Microsoft Power Platform enables users to streamline processes, gain insights from their data, and build custom solutions to meet their business needs. It is designed to be accessible to users with varying levels of technical expertise, making it easier for organizations to create custom applications and automate workflows.

Microsoft developed the Power Fx low-code programming language for expressing logic across the Power Platform. [4] [5]

Products

The Power Platform family of products includes: [2] [6]

Microsoft Dataverse

Microsoft Dataverse, formerly known as Microsoft Common Data Service until November 2020, is a relational database engine [8] offered by Microsoft as a cloud-based data management software as a service for storing business data. Dataverse is a data storage and management engine serving as a foundation for Microsoft’s Power Platform, Office 365 and Dynamics 365 apps. It decouples the data from the application, allowing an administrator to analyze from every possible angle and report on data previously existing in different locations. It is based on Common Data Model principles, enhanced with rich security features, business logic, and productivity tools. Data of any size and format could be easily imported, managed and exported out of Dataverse with streamlined processes. Dataverse is built on Microsoft Azure. It is mainly a tool for managing and storing data, and allows for creation and management of datasets through a single user interface.

Dataverse is marketed for use with other Microsoft products such as Power Apps and Microsoft Dynamics 365 applications, and has data connectors to other Microsoft products like Azure Event Hub, Azure Service Bus, Microsoft SQL and Azure Data Lake. One example of use could be to use Dataverse as a form of data lake together with Microsoft Power Apps. Microsoft Dataverse is also offered as a standalone service for businesses looking to build custom data solutions with integration to external systems via webhooks. Dataverse has APIs so that the data can be consumed by other services, like for example Power Platform services like Power BI or Power Apps, or by custom services designed in for example Visual Studio.

In addition to relational data, Dataverse also has support for file and blob storage, data lakes and semi-structured data. Dataverse is based on Microsoft's Common Data Model as its common data model and is built on Microsoft Azure SQL, where its physical data also is stored.[ citation needed ]

Dataverse has the possibility to apply business logic like duplicate detection, calculated fields, rollup fields and business rules. It can be used to discover, validate and report data, and has the possibility to use Microsoft's proprietary common data model. Access in MS Dataverse is handled with Microsoft Entra ID which has conditional access and multifactor authentication (MFA), and offers individual column and row-level security.

See also

Related Research Articles

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 built into most desktop Microsoft Office applications. Although based on pre-.NET Visual Basic, which is no longer supported or updated by Microsoft, the VBA implementation in Office continues to be updated to support new Office features. VBA is used for professional and end-user development due to its perceived ease-of-use, Office's vast installed userbase, and extensive legacy in business.

Microsoft Servers is a discontinued brand that encompasses Microsoft software products for server computers. This includes the Windows Server editions of the Microsoft Windows operating system, as well as products targeted at the wider business market. Microsoft has since replaced this brand with Microsoft Azure, Microsoft 365 and Windows 365.

Microsoft BizTalk Server is an inter-organizational middleware system (IOMS) that automates business processes through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.

Azure DevOps Server, formerly known as Team Foundation Server (TFS) and Visual Studio Team System (VSTS), is a Microsoft product that provides version control, reporting, requirements management, project management, automated builds, testing and release management capabilities. It covers the entire application lifecycle and enables DevOps capabilities. Azure DevOps can be used as a back-end to numerous integrated development environments (IDEs) but is tailored for Microsoft Visual Studio and Eclipse on all platforms.

Wrike, Inc. is an American project management application service provider based in San Jose, California. Wrike also has offices India, Dallas, Tallinn, Nicosia, Dublin, Tokyo, Melbourne, and Prague.

<span class="mw-page-title-main">WaveMaker</span> Low-code programming platform

WaveMaker is a Java-based low-code development platform designed for building software applications and platforms. The company, WaveMaker Inc., is based in Mountain View, California. The platform is intended to assist enterprises in speeding up their application development and IT modernization initiatives through low-code capabilities. Additionally, for independent software vendors (ISVs), WaveMaker serves as a customizable low-code component that integrates into their products.

<span class="mw-page-title-main">Microsoft Azure</span> Cloud computing platform by Microsoft

Microsoft Azure, or just Azure, is the cloud computing platform developed by Microsoft. It has management, access and development of applications and services to individuals, companies, and governments through its global infrastructure. It also provides capabilities that are usually not included within other cloud platforms, including software as a service (SaaS), platform as a service (PaaS), and infrastructure as a service (IaaS). Microsoft Azure supports many programming languages, tools, and frameworks, including Microsoft-specific and third-party software and systems.

NetDocuments is a cloud-based document, email, and records management service.

<span class="mw-page-title-main">Dynatrace</span> American technology company

Dynatrace, Inc. is a global technology company that provides a software observability platform based on artificial intelligence (AI) and automation. Dynatrace technologies are used to monitor, analyze, and optimize application performance, software development and security practices, IT infrastructure, and user experience for businesses and government agencies throughout the world.

Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn various sources of data into static and interactive data visualizations. Data may be input by reading directly from a database, webpage, PDF, or structured files such as spreadsheets, CSV, XML, JSON, XLSX, and SharePoint.

<span class="mw-page-title-main">Microsoft Dynamics 365</span> Microsoft software

Microsoft Dynamics 365 is an integrated suite of enterprise resource planning (ERP) and customer relationship management (CRM) applications offered by Microsoft. Combines various functions such as sales, customer service, field service, operations, finance, marketing, and project service automation into a single platform.

Zapier is an American multinational software company that provides integrations for web applications for use in automated workflows.

SAP Business Technology Platform is a platform as a service developed by SAP SE that offers a suite of services including database and data management, AI, analytics, application development, automation and integration all running on one unified platform.

<span class="mw-page-title-main">Low-code development platform</span> Software development system

A low-code development platform (LCDP) provides a development environment used to create application software, generally through a graphical user interface. A low-coded platform may produce entirely operational applications, or require additional coding for specific situations. Low-code development platforms are typically on a high abstraction level, and can reduce the amount of traditional time spent, enabling accelerated delivery of business applications. A common benefit is that a wider range of people can contribute to the application's development, not only those with coding skills, but good governance is needed to be able to adhere to common rules and regulations. LCDPs can also lower the initial cost of setup, training, deployment, and maintenance.

<span class="mw-page-title-main">Appian Corporation</span> American cloud computing company

Appian Corporation is an American cloud computing and enterprise software company headquartered in McLean, Virginia, part of the Dulles Technology Corridor. The company sells a platform as a service (PaaS) for building enterprise software applications. It is focused on low-code development, process mining, business process management, and case management markets in North America, Europe, the Middle East and Southeast Asia.

AppSheet is a no-code development platform for application software, which allows users to create mobile, tablet, and web applications. It allows using data sources like Google Drive, DropBox, Office 365, and other cloud-based spreadsheet and database platforms. AppSheet can be utilized for a broad set of business use cases including project management, customer relationship management, field inspections, and personalized reporting. AppSheet was acquired by Google in January 2020.

Microsoft Power Automate, previously known as Microsoft Flow until November 2019, is a SaaS platform by Microsoft for optimizing and automating workflows and business processes. It is part of the Microsoft Power Platform line of products, which include Power Apps and Power BI.

<span class="mw-page-title-main">Tables (Google)</span> Cloud-based collaborative database software

Tables is a collaborative database program developed out of Google's Area 120 incubator. Tables is available as a web application. The app allows users to collaborate in real-time to track work more efficiently using automation.

Microsoft Power Fx is a free and open source low-code, general-purpose programming language for expressing logic across the Microsoft Power Platform.

A digital adoption platform (DAP), also known as digital adoption solution, is an automated software tool layered on top of an enterprise application. A DAP is used for onboarding users, guiding them on how to use the organization's application, and gaining insights into users' interaction with the application interface.

References

  1. 1 2 Novet, Jordan (2019-05-08). "Microsoft touted something called the Power Platform at its big event this week — here's what it is". CNBC. Retrieved 2021-03-20.
  2. 1 2 Foley, Mary Jo (2019-01-18). "Why Microsoft's 'Power Platform' is one of its biggest bets for 2019 and beyond". ZDNet. Retrieved 2021-03-20.
  3. Bishop, Todd (2020-09-22). "As 'low-code' competition grows, Microsoft integrates Power Apps with GitHub and Teams". GeekWire. Retrieved 2021-03-20.
  4. Anderson, Tim (2021-03-02). "Excel-lent: Microsoft debuts low-code Power Fx language... but it is not really new". The Register . Retrieved 2021-03-14.
  5. Melanson, Mike (2021-03-06). "This Week in Programming: Microsoft's Power Fx 'Low Code' Language". The New Stack. Retrieved 2021-03-14.
  6. Krill, Paul (2020-05-25). "Microsoft: Power Platform is for real developers, too". InfoWorld. Retrieved 2021-03-20.
  7. "Announcing Microsoft Power Pages: Build secure, low-code websites". powerpages.microsoft.com. Retrieved 2023-02-02.
  8. What is Microsoft Dataverse? - Power Apps | Microsoft Docs

Further reading