Showing results for 
Search instead for 
Did you mean: 
New Member

Data Migration from Sharepoint Lists into Dataverse

Hi everybody!


I am trying to import the data from a table together with the table structure (all the table fields) from Sharepoint into Dataverse.

I use the "Sharepoint Online List" option and I can access all my SP Lists and accordingly transform the data with PowerQuery. Then I choose the option "Load the data in a new table".


However, after performing all the necessary steps, the imported table into dataverse is missing all the fields that I chose to import from SP List.

Is there a way to actually import the table structure (fields, field names, etc.) without having to

manaually generate them again in Dataverse?




Dual Super User II
Dual Super User II


Please check the below method by 



If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly Thanks for your answer!


Although, this has the same result as the "Sharepoint" connector. I can create the table in the sink (Dataverse), but the fields of the source table are not being regenerated in my Dataverse table.

In the end, I have neither the data from the source, nor the the table structure

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,446)