{"id":108081,"date":"2023-11-15T08:00:00","date_gmt":"2023-11-15T16:00:00","guid":{"rendered":""},"modified":"2025-07-03T04:48:21","modified_gmt":"2025-07-03T11:48:21","slug":"accelerate-copilot-extensibility-and-power-app-creation-with-microsoft-dataverse","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/11\/15\/accelerate-copilot-extensibility-and-power-app-creation-with-microsoft-dataverse\/","title":{"rendered":"Accelerate Copilot extensibility and Power Apps creation with Microsoft Dataverse"},"content":{"rendered":"\n

In the ever-evolving landscape of AI, Microsoft Power Platform has the unique opportunity to unlock the vast potential of business application data and logic. Every fragment of enterprise data carries latent insights and untapped productivity. At Microsoft Ignite 2023<\/a>, witness firsthand how Microsoft Power Platform and Microsoft Dataverse<\/a> are activating the strength of your enterprise data using AI\u2014the announcement of \u201cplugins for Microsoft Copilot for Microsoft 365,\u201d a low-code \u201cprompt builder\u201d experience, the ability to install OpenAI plugins, and even creating plugins from Power Automate\u2014all inside of Microsoft Copilot Studio. We are also announcing the general availability of \u201cDataverse Link to Microsoft Fabric\u201d and two new Microsoft Power Apps creator experiences using Excel and natural language.  <\/p>\n\n\n\n

Extending your Copilot and conversational experience with enterprise data using plugins<\/h2>\n\n\n\n
\n\t
\n\t\t

\n\t\t\tExtend Microsoft 365 Copilot with your line of business apps and data\t\t<\/h2>\n\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\tJoin Ignite Session\t\t\t\t\t\t\t\u2197<\/a>\n\t\t\t\t\t<\/p>\n\t<\/div>\n<\/div>\n\n\n\n

Customers have been asking how they can use Copilot to tap into enterprise data, remove data silos, and improve productivity and collaboration. With plugins, customers can ensure their copilots can securely integrate with this most critical line of business data. At Ignite, we are announcing the ability to extend your Microsoft Copilot for Microsoft 365 with Microsoft Power Platform plugins<\/a> and Microsoft Copilot Studio<\/a>. We\u2019re introducing three ways in which customers can leverage the power of data inside Copilot for Microsoft 365 or their own Microsoft Power Platform copilots.  <\/p>\n\n\n\n

    \n
  1. Using the existing Microsoft Power Platform connector ecosystem of more than 1,100 live connectors, customers and partners can enable their users to access and update data from external systems. Customers can leverage existing certified Microsoft Power Platform connectors as Microsoft Copilot Studio Topics<\/a>, which in turn can enrich Copilot for Microsoft 365. <\/li>\n<\/ol>\n\n\n\n
    \n

    We are extending the capabilities of our more than 50 intelligent supply chain solutions with Microsoft Power Platform, [Microsoft]<\/em> Fabric, and Copilot. For instance, Accenture\u2019s supplier risk control tower solution builds the digital twin using Dataverse and Fabric to predict delays and offers recommendations to supply chain operators through the copilot for real-time collaboration with suppliers and automated execution to mitigate disruptions. Through the Power of 3 with Microsoft, Accenture, and Avanade, we are able to infuse rich data and intelligence through Copilot into the broader Microsoft 365 and business application ecosystem, thus enhancing decision making and overall productivity for our clients.<\/em> <\/p>\n– Kumar Majety, Cloud Supply Chain Solution Lead, Accenture<\/em> <\/cite><\/blockquote>\n\n\n\n

      \n
    1. With prompt builder, customers can build, test, and deploy AI prompts that will instruct copilots to perform specific actions when asked. In addition, prompts can be grounded in business data to customize your prompts with real-time business data. For example, makers can teach Copilot to produce a specific case summary, case classification, or draft an email reply according to their company policy and based on their company\u2019s case history stored in Dataverse.<\/li>\n<\/ol>\n\n\n\n
      \"Build,<\/figure>\n\n\n\n
        \n
      1. With Power Automate flow plugins, users can expose the tasks they have in Microsoft Planner by asking \u201cWhat are my planner tasks?\u201d<\/em> Similarly, users <\/em>can find the list of approvals assigned to them by asking \u201cList my approvals.\u201d<\/em>  <\/li>\n<\/ol>\n\n\n\n
        \n
        Start extending Copilot for Microsoft 365 with plugins.<\/a><\/div>\n<\/div>\n\n\n\n

        Companies, developers, and ISVs can extend their products into Copilot using plugins <\/h2>\n\n\n
        \"graphical<\/figure>
        \n

        Our partners have expressed their excitement about taking part in the age of AI. Enabling their products and services as plugins across low-code applications allows them to become part of the extensibility opportunity. ISVs can leverage existing Microsoft Power Platform connectors for creating AI plugins or import existing OpenAI plugins to use in public preview.<\/p>\n<\/div><\/div>\n\n\n\n

        \n

        \u201cWe are thrilled to participate with Microsoft in this age of AI and provide value to our joint customers. The introduction of Power Platform connector as a plugin for Microsoft Copilot opens up an entirely new set of ways for our clients to deliver exceptional customer service.\u201d<\/em> <\/p>\n– Kumar Krishnasami, Founder and CEO, Desk365 <\/cite><\/blockquote>\n\n\n\n

        \n
        Bring your OpenAI plugins into Microsoft Power Platform or create plugins from your existing Microsoft Power Platform connectors. <\/a><\/div>\n<\/div>\n\n\n\n

        Accelerate content generation scenarios with AI Builder GPT prompts <\/h2>\n\n\n\n

        Generative AI and Microsoft Power Platform create a powerful combination to bring to life next-generation workflows.  <\/p>\n\n\n\n

        To enable more organizations to leverage the power of generative AI, we are excited to announce the general availability of GPT prompts within AI Builder<\/a>. Prompts are how users can interact with large language models<\/a> like GPT, instructing the next generation of AI models to perform specific tasks. However, starting from zero can be tough, but by using AI Builder<\/a>, users can now integrate generative AI prompts within their Power Automate workflows, Power Apps, Dataverse tables, and copilots. To help users get started, a prebuilt library of ready-to-use prompts is available and includes common scenarios like summarization, classification, content extraction, translation, and sentiment analysis. The prompts also comply with Microsoft\u2019s approach to responsible AI<\/a>. Users can also craft their own prompts, grounded with company data to produce specific outputs that are unique to their business.\u00a0\u00a0<\/p>\n\n\n\n

        Build apps better and faster with Dataverse and Copilot AI assistance<\/h2>\n\n\n\n
        \n\t
        \n\t\t

        \n\t\t\tAccelerate impact with AI-powered low code tools\t\t<\/h2>\n\t\t

        \n\t\t\t\t\t\t\t\n\t\t\t\t\t\tJoin Ignite Session\t\t\t\t\t\t\t\u2197<\/a>\n\t\t\t\t\t<\/p>\n\t<\/div>\n<\/div>\n\n\n\n

        Copilot in Power Apps is an AI companion that lets low-code makers easily create apps from ideas through natural language or from existing data in Excel and is one of the fastest-growing ways to build enterprise-ready business solutions backed by Dataverse. <\/p>\n\n\n\n

        The following capabilities are now generally available: <\/p>\n\n\n\n

        1. From \u2018idea to app\u2019 within a few minutes using natural language<\/h3>\n\n\n\n

        Makers can describe the app that they want to build and have a Dataverse table and app generated through an interactive Copilot AI-assisted experience<\/a>. Previously, many makers would spend multiple days gathering requirements, building a prototype, getting feedback, testing, and iterating with business users. Now, with Copilot-assisted app creation, makers can prototype an app faster than ever before, and iterate with business users to build the desired business apps.  <\/p>\n\n\n\n

        2. Import from Excel to build your apps<\/h3>\n\n\n\n

        Makers can use Copilot AI assistance and the power of Dataverse to import data from Excel to create configurable tables in minutes<\/a>. Makers were previously facing issues when wanting to scale their app from Excel to a wider audience and use cases\u2014from size limitations, concurrent usage challenges, and governance. The process to upgrade from your Excel file to Dataverse was historically lengthy and prone to errors. With two clicks under two minutes, makers can now import their Excel files into Dataverse, and get suggested table schema to build their next Copilot-enabled apps.  <\/p>\n\n\n\n

        \"Connecting<\/figure>\n\n\n\n

        3. Build formula columns in Dataverse<\/h3>\n\n\n\n

        Now generally available, Formula columns<\/a> are the next generation of columns in Dataverse. Based on Power Fx, they use the similar Excel-like language you use for Power Apps. Makers can also use natural language to generate formulas, now in public preview. Formula columns empower citizen developers to express business logic on top of existing columns and reference columns from other tables, directly in Dataverse.  <\/p>\n\n\n\n

        \n\t\n
        \n\t
        \n\t\t
        \n\t\t\t
        \n\t\t\t\t

        Microsoft Dataverse<\/h2>

        Do more with your data. Expand the possibilities.<\/p>

        Get started today<\/a><\/div><\/div>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\"a\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n<\/div>\n\n\n\n

        Activate low-code app development atop your Fabric OneLake with Dataverse virtual tables  <\/h2>\n\n\n\n

        We are also excited to announce the preview of Dataverse virtual tables over Microsoft Fabric, which enables your low-code app builders to connect to data in Microsoft OneLake and build Power Apps, and drive business actions without data copy, no-ETL, or third-party integration tools. Additionally combined with Power Pages, low-code makers can build external-facing websites and drive action from insights with partners, suppliers, and customers.  <\/p>\n\n\n\n

        \"graphical<\/figure>\n\n\n\n

        Pattern Energy<\/strong>, a developer and operator of utility-scale wind and solar power facilities across the United States, Canada, Japan, and Mexico, is on a mission to accelerate the world\u2019s transition from fossil energy to a sustainable future. Timely and detailed insights on projects in Dynamics 365 are combined with data from the field to keep track of issues and avoid delays in bringing green energy to the grid. Pattern Energy has empowered a team of low-code makers who can get actionable insights across their data sources and act faster within all their business units across the globe. <\/p>\n\n\n\n

        \n

        \u201cWe worked with Microsoft from early stages of the Fabric preview and realized the features were going to be a game changer for us. Exporting data from Dynamics 365 has never been easier. With Power Platform and OneLake, our teams have access to near real-time data, actions, and workflows. Once all these features are made generally available we\u2019re excited to deploy across our organization; giving everyone at Pattern the tools they need to accelerate their ability to make data-driven decisions.\u201d <\/em> <\/p>\n\u2013 Duncan Gifford, Director, Enterprise and Data Architecture, Pattern Energy<\/em> <\/cite><\/blockquote>\n\n\n\n

        Learn more<\/h2>\n\n\n\n