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

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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 I
Helper I

@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
Resident Rockstar
Resident Rockstar

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,186)