Introduction

With the Excel to App feature from Copilot in Microsoft Power Apps, you can select a Microsoft Excel file, create an app, and then run the app that you create. Every app that you create includes screens for you to browse records, show record details, and create or update records. By generating an app, you can quickly get a working app using Excel data. Then, you can customize the app to suit your needs.

When you upload an Excel file, Copilot in Microsoft Power Apps generates a Microsoft Dataverse table from the data. The standard and custom tables in Dataverse help you store your data more securely in the cloud. You can then use these tables to define your organization's data in a way that's aligned to your business needs. This structure helps make it easier to use data within your apps.

Copilot in Power Apps can help you create tables by suggesting table names, descriptions, column data types, and headers, even if this information is missing from the uploaded file. When you use Copilot in Power Apps for table creation, the Copilot chat appears, indicating that the table was generated using AI.