cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Smarty_
Helper II
Helper II

SharePoint to Dataverse

Dear colleagues,

 

My case:

 

I have a Power Apps Canvas app based on SharePoint lists. 

 

I need to move this solution to the Dataverse.

 

Could you help me please?

2 ACCEPTED SOLUTIONS

Accepted Solutions
dpoggemann
Super User
Super User

Hi @Smarty_ ,


There is no direct conversion to do this.  You will need to add the Dataverse as a connection to your Canvas App and then start configuring the Dataverse table to model the SharePoint list structure.  After you configure the data model you can then export the data from the SharePoint lists and work to import this into the Dataverse.  I would usually use the Data Import Templates for the tables but there are a number of ways you can do this.  

 

You will need to change your Canvas app at this point to utilize the Dataverse vs SharePoint and some of the patch functions (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch) may have some different rules around delegation (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch).

 

I know this is pretty broad but hope it helps.  This is taking completely to full Dataverse.  If you want to start with Dataverse for Teams you can do that as well and this would not have any licensing impact on your application (https://crmtipoftheday.com/1402/why-you-should-not-use-microsoft-lists-sharepoint-lists-for-business...

 

Hope this helps in some way.  If answers your question please Accept or if helps in some way please Like.  

 

Thanks,

 

Drew

View solution in original post

dpoggemann
Super User
Super User

Hi @Smarty_ 

 

See couple of the screen shots below on where to get the templates.  This will download an Excel template that you can use to run a Data Import from the My Imports screen (Go into Data Management to get to Imports). 😀

 

Data ImportData ImportImport Templates by TableImport Templates by TableTemplates and Data ManagementTemplates and Data Management

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,


Drew

View solution in original post

4 REPLIES 4
dpoggemann
Super User
Super User

Hi @Smarty_ ,


There is no direct conversion to do this.  You will need to add the Dataverse as a connection to your Canvas App and then start configuring the Dataverse table to model the SharePoint list structure.  After you configure the data model you can then export the data from the SharePoint lists and work to import this into the Dataverse.  I would usually use the Data Import Templates for the tables but there are a number of ways you can do this.  

 

You will need to change your Canvas app at this point to utilize the Dataverse vs SharePoint and some of the patch functions (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch) may have some different rules around delegation (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch).

 

I know this is pretty broad but hope it helps.  This is taking completely to full Dataverse.  If you want to start with Dataverse for Teams you can do that as well and this would not have any licensing impact on your application (https://crmtipoftheday.com/1402/why-you-should-not-use-microsoft-lists-sharepoint-lists-for-business...

 

Hope this helps in some way.  If answers your question please Accept or if helps in some way please Like.  

 

Thanks,

 

Drew

View solution in original post

Smarty_
Helper II
Helper II

@dpoggemann , thank you very much!

 

Gonna share the results as soon as I'm ready.

@dpoggemann 

 

Could you please share the information (may be real cases) about Data Import Templates? 

 

dpoggemann
Super User
Super User

Hi @Smarty_ 

 

See couple of the screen shots below on where to get the templates.  This will download an Excel template that you can use to run a Data Import from the My Imports screen (Go into Data Management to get to Imports). 😀

 

Data ImportData ImportImport Templates by TableImport Templates by TableTemplates and Data ManagementTemplates and Data Management

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,


Drew

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,582)