Importing data into the Power Platform Dataverse

Importing data into the Power Platform Dataverse.
So, how do we import our data into Dataverse? As some of you might know, Dataverse is the data table storage structure behind the Power Platform. Its where you can store your large data sets instead of using the Lists Service.
Dataverse has two general access points: via Power Apps and Power Automate. We are going to use Power Apps in this video. There are other ways to import data into Dataverse using programming methods, REST API's and so on which is out of the scope of this introductory video.
In Power Apps expand Dataverse, in the left pane, and then click on Tables. In this example we are going to use the Accounts table.
Now, in order to import into a standard table such as this, actually, requires, us to first export the table! Amazing isn’t it? This sort of manoeuvre is totally counter-intuitive and it is what makes, for some people, learning IT really hard! Fear not I am here to help you via this Vlog!
The reason we have to export the table is to create a template file. We use that template file to import our data.
The Account table already has over 100 columns in it. So, when adding data to this table we are using the existing columns. Of course we don’t have to populate them all. In Dataverse there are tables of type “Standard”. These are tables, that we can use, that have predefined columns in them. The reason that Microsoft is providing these tables and their associated columns is so that, when we create another App that uses some or all of the columns in that Account table, we can reuse that table and its data or we can reuse the code we wrote that operates on that table. That is, it saves us development time and provides consistency and standardisation to our work. The columns have been defined based on real industry usage. Microsoft refers to the tables, also, as Entities.

[@GuruPrasad-xp1yq]

How to import the data if we have lookup field

[@spontaneousorder5670]

I'm currently struggling through this. I tried using the GUID from the lookup table, and that doesn't work.

[@rodrsturge663]

This is great if you want to use an existing dataverse table, manually append to it via csv file, and plan never to update the data within that table from an external source.

[@johnnyhip3532]

So what should I do if I have 433 columns?

[@CigarDoug]

Normalize your data.