Imagine being able to create complex Dataverse tables for your applications in minutes instead of hours. With Copilot in Power Apps, this is now a reality.
Administrators and consultants can save time and effort by generating tables with just a simple prompt, paving the way for efficient application development.
In the past, administrators and consultants had to manually create tables, define each column, and specify its data type – a tedious and time-consuming process, especially for applications requiring numerous tables and hundreds of columns.
A recent Power Apps update enables you to create a prompt quickly. You can then configure some parameters and use your input to populate a table filled with columns, data and even relationships between multiple tables. Lets explore how this works and scenarios where a business may benefit.
Describe your new table with Copilot
When you begin creating your table, you can choose from four different options: Copilot, import from Sharepoint, Excel or blank. Choosing Copilot surfaces a box to describe your table.
You can configure the query settings to ask it to create one or multiple tables and table sizes and decide if you want to include table relationships.
In our example, we are going to create multiple tables in the Dataverse for an insurance business. We want to create tables for policies, claims and risk assessments. You can also include relationships between the tables where appropriate. For example, you can create a relationship between a claim and the policy the customer purchased.
Now that we are happy with our query, Copilot will use our information to generate our tables. You can then view the results and amend them on the next screen.
Copilot understood our query correctly and produced three tables relevant to our insurance business.
We can see the relationships between each of the tables using an intuitive visualisation interface and have the opportunity to view the columns and data it has created. In our example, Copilot has created typical columns a claims table might consist of, such as the claim date, status and the claim amount.
In addition, the policy table includes columns for the type of insurance, such as automotive or health, the policyholder’s name, and the premium value. It has also populated data with information you would expect to see.
We’re also able to extend our table using Copilot. In this case, we want Copilot to help us add customers to our claims table, as shown in the image below:
Copilot intelligently interprets the data type specified in your query. For example, if you ask Copilot to add a column to approve or deny claims, it will automatically apply a binary choice data type.
From Prompts to Tables: The Copilot Advantage
By simplifying the process with an intuitive prompt and automated data generation, Copilot saves valuable time and reduces errors. It can help kickstart the process with a first draft, and then you can continue refining your tables to a publishable state.
The key to your success with this is understanding how to prompt to let Copilot help you realise your goals. If you’d like support with this, don’t hesitate to get in touch with us, and our consultants can provide help.
Related posts:
