Create rows in Dataverse table using the excel data
We can create rows in a dataverse table by using the excel as the data source. We already created a table in dataverse with some columns.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-01.webp)
We have an excel file with some data in table Ashish_Table. Here name can be given anything and please note that it is used in the power automate.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-02.webp)
Upload the excel file in the sharepoint Documents library.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-03.webp)
Step 1: Go the Power Automate and sign in with the Microsoft account or work/school account.
Step 2: Select an action “List rows present in a table”.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-04.webp)
In this action, we need to specify the Location which can be the sharepoint site or the OneDrive or where our file is stored. Select the Document Library and then select the file and select the table because an excel table can contain multiple tables.
Step 3: Add the action “Add a new row” from the dataverse section.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-05.webp)
In this action, we need to specify the name of the dataverse table. And then map the excel table columns with the columns of the dataverse table.
Step 4: Click on Run to run the flow.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-06.webp)
We can see that the data is successfully populated.
![Create rows in Dataverse table using the excel data Create rows in Dataverse table using the excel data](media/create-rows-in-dataverse-table-using-the-excel-data-07.webp)