Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Create apps without writing code or designing screens. By using Copilot in Power Apps, you use natural language to describe what you want your app to do, and AI does the rest.
Copilot is a feature in Power Apps that helps you build apps with AI assistance. From the Power Apps home screen, select Start with data, and then select Create new data to open the table editor with Copilot. Enter the type of information you want to collect, track, or show in your app, and Copilot generates one or more Microsoft Dataverse tables that you use to build your canvas app.
Prerequisites
- Check the prerequisites and region availability in Copilot in Power Apps overview (preview).
- Depending on where your environment is hosted, you might need to enable data movement across regions. For more information, see Copilots and generative AI features that are available when you enable data movement across regions. You need access to a Microsoft Dataverse database in your environment to use this feature. For more information, see Add a Microsoft Dataverse database.
- Check if this feature is available in your region. For more information, see Explore Copilot features by geography and languages.
- Assign the system customizer security role in the environment.
Create an app by using Copilot
Let's create an app to track housekeeping tasks for a hotel so you can see how Copilot works.
Sign in to Power Apps.
On the home screen, select Start with data.
Select Create new data.
The Create new tables workspace opens with a blank table and the Copilot panel on the right side.
In the Copilot panel text box, enter your prompt, like the example prompt in the following section.
Create tables to track hotel housekeeping tasks including room numbers, task types, staff assignments, and task statusSelect Submit or press Enter.
Copilot creates one or more Dataverse tables with data that includes typical hotel housekeeping tasks.
Important
If you don't have the right permissions or access to Dataverse in the environment you're working in, an alert asks you to create the app in your own environment. Make sure you can create the table and app in your environment to continue. If you don't have a personal developer environment, a new one is created for you automatically. For more information, see Get your developer environment (preview).
Review the table
Copilot generates tables and relationships based on your description. Review them and make any changes you need before you create your app.
Review the tables for your app
Copilot shows you the tables and relationships it generates based on your description in the Create new tables workspace.
The workspace includes the following options:
| Option | Description |
|---|---|
| 1. Back | Return to the previous screen. |
| 2. New table | Add a new table to your workspace. |
| 3. Existing table | Add an existing Dataverse table. |
| 4. View data | View the data in your tables. |
| 5. Create relationships | Create relationships between tables. |
| 6. Remove | Remove a table from the workspace. |
| 7. Save and exit | Save your tables and create your app. |
| 8. Copilot panel | Ask Copilot to create tables, import data, or make changes using natural language. |
| 9. View prompts | See examples of what you can ask Copilot to do. |
Use Copilot to make changes
To change something, enter a brief description of the change in the Copilot panel. Copilot makes the change for you.
The Copilot panel provides three options to help you get started:
- Create: Describe tables, columns, rows, and relationships and they'll be generated for you.
- Import data: Create tables from Excel or .CSV files, or SharePoint lists.
- Change: Describe the changes you'd like to make.
For example, ask Copilot to add columns to track cleaning start and end time.
In the Copilot text box, enter Add columns to track start and end time.
Copilot adds two new columns called Start Time and End Time.
Continue editing the table as needed. For example, add room status, change room types, or set a priority level for each room.
When you're ready to create your app, select Save and exit.