You are currently viewing How Dataverse create table from SharePoint list?
migrate SharePoint Data to Dataverse Table

How Dataverse create table from SharePoint list?

  • Post author:
  • Post category:Power Apps
  • Reading time:10 mins read

In this post, we will learn how dataverse create table from SharePoint list.
If you are new to Microsoft Data verse, you can check this article .

Migrate SharePoint Data to Dataverse Table

You have a requirement in Microsoft Data verse where you need to transfer the data from the SharePoint list to a data verse table with same fields and same data. You can Migrate SharePoint Data to Data verse table using Dataflow.

What is PowerApps Dataflow?

  • A dataflow is a collection of tables that are created and managed in Power Apps environments. You can manage data refresh schedules and add and edit tables in your dataflow directly from the environment where it was created.
  • You can use Power Apps dataflow, which you can then use to connect with business data from various sources, clean the data, transform it, and load it to Microsoft Dataverse or your organization’s Azure Data Lake Gen2 storage account.

Steps to migrate SharePoint Data to Dataverse Table

This is our SharePoint list that we will transfer the structure and the data to the data verse.

dataverse create table from sharepoint list
migrate SharePoint Data to Dataverse Table

Purpose: Single line of text.
Travel Start Date: Date column
Travel End Date: Date column
Travel Cost: Currency
DM Approval Reason: Multi line of text
Approval Status: Choice field
Flag: Number

Now we want to migrate this SharePoint list to a data verse table using PowerApps Dataflow.

  • Sign in to Power Apps site. On the Power Apps Home page, expand the Data verse  section from the left navigation and click on the Dataflows, and then click + New dataflow to create a new Power Apps dataflow.
dataflow | Power Platform Geeks
Dataflows to migrate SharePoint to data verse
  • Specify a meaningful name for the Dataflow and then click create
dataflow2 | Power Platform Geeks
Create Dataflow
  • A new form will opened for you with various data sources and connectors from which your data could be retrieved.
  • Choose SharePoint online list or you can use the search box to search for SharePoint online list.
dataflow3 | Power Platform Geeks
  • After selecting SharePoint online list, it will ask you to enter some connection settings
Provide the connection settings
Provide the connection settings

Site URL : write the base site URL of your SharePoint list.
Connection: Choose your connection or create new one if you don’t have.
Authentication kind: Choose Organizational account and then click sign in to sign to your account using your credential.

  • After signing in correctly Click Next
Connect to your data source
Connect to your data source
  • It will list all the SharePoint list in the site you write in the Site URL.
  • Choose your list and then click transform data
dataflow6 | Power Platform Geeks
All SharePoint list
migrate SharePoint Data to Dataverse Table
Choose your data and click transform data
  • In the following Power query page you can delete rows, columns same as what we do in Power BI, for example here I will delete the Id column as I have two columns with the same name Id and ID, in order not to get warning while mapping the fields and then click next.
dataflow8 | Power Platform Geeks
  • Now you will ask to map the tables, columns, and you will have the option of loading the data into new table or into an existing table, in this example I will choose to load it into a new table. Here the Table name and Table display name will be auto-populated.
dataflow9 | Power Platform Geeks
Map tables in dataflow
  • The next step is selecting the refresh frequency of your dataflow. Dataflows use a data refresh process to keep data up to date. You can choose to refresh manually or automatically and define the schedule to refresh the data. 

If the data migration is a one time, don’t take any action in this section

refreshdatasetting | Power Platform Geeks
  • After that click publish to publish your dataflow

and you will find the Dataflow lists in the Dataflows section

flow | Power Platform Geeks

If you navigate to the Dataverse tables, you will see the table that we just map the data to. And then you can check your data in the table

travel | Power Platform Geeks
data | Power Platform Geeks

You can create Dataflows to connect to and extract your data from a wide range of data sources in Power Apps.

See Also
Join us
Need Help
  • Have a related question? Please ask it at deBUG.to Community.

Heba Kamal

Power Platform Consultant and Founder of Power Platform Geeks