Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

Did you know that you can create a table in Dataverse from CSV or Excel files?

Use an Excel or CSV file to populate a table with your data, which you can then import to generate a table in Dataverse.

Here’s a refined version of your sentence:

“In this article, let’s learn how to create a simple Offers table using a CSV file.”

Prepare a CSV file:

• Create a new CSV file with the following columns and data, and save it as Offers.csv.

Now that we have created the CSV file, let’s use it to create a Dataverse table.

Create Dataverse table using the CSV:

• Connect to Power Apps maker portal and select your environment.
• From the Tables area, on the command bar select New table > Create with external data, and then select either File (Excel, .CSV).

• Click on Upload from device and upload the CSV file we prepared in the previous section.
• The CSV file loads in the pane with the data displayed. You have the option to change the Table properties as shown below.

• You can also change the column data types or make a field required, as shown below.

• Note that we can’t change the datatype of a column to a Lookup type here. We need to first complete the table creation and then add a new Lookup column.
• Go ahead and click on Create.
• In a few seconds, your Dataverse Offer table will be created and populated with data.

Refer this Microsoft documentation for more details.

🙂