Transform your SHAREPOINT Lists into DATAVERSE Tables & Copilot ready Power Apps

In this step-by-step tutorial video, I will show how you can easily transform your SharePoint Lists into Dataverse Tables and Copilot ready Canvas Power Apps in a single experience.
We will explore the advantages of leveraging Microsoft Dataverse over SharePoint for enterprise App development scenarios & talk about the differences between Dataverse and SharePoint.

The new "Create with SharePoint List" option in Power Apps combined with Copilot assistance will help to import list data into Dataverse tables and create a Power App for us. I will also demonstrate how to seamlessly import data from multiple SharePoint lists into Dataverse Tables, covering complex columns such as lookup and person fields and frame a Model-driven Power App within seconds to showcase the imported data and relationships.

#dataverse #sharepoint #powerapps #powerplatform

Easier than ever experience to import data from SharePoint List

00:00 Introduction to Importing SharePoint List data to Dataverse Tables
00:33 Enterprise App development needs
01:26 Microsoft Dataverse Features
01:48 Microsoft Dataverse or SharePoint Lists
03:17 How to import SharePoint data into Dataverse and build PowerApps with Copilot
06:52 Import multiple SharePoint Lists into Dataverse Tables
17:36 Build Power Apps with import data in Dataverse

🤝 Let’s connect on social:

[dougydoe]

Always on point with your tutorial videos and this is yet another one. Handling complex columns within dataflows has been a bit of a challenge so seeing how the keys are set was very refreshing. I know I will come back to this video again for future project but having seen that is done is very refreshing. Had to pause me holidays for about 30 min to watch Reza's video but it was worth it. 🤣🤣

[Leabelias]

Very helpful video. Bringing those complex columns to dataverse was a long time challenge for me. Thank you for shading the light.

[andrewgrant]

Unbelievably good timing. I could hardly believe my eyes when I saw this in my feed. I got stuck with those pesky relationship columns but now I can move a business critical app from Sharepoint to Dataverse, as needed for scalability and security roles. Many thanks. 😊

[daxteoh]

Love this Reza, thank you! I've recently switched to dataverse for security requirement by business owner. Hope you can share more tips and tricks for dataverse in the future!

[mehtabidreesi]

it tooks my whole day to learn just how to transform splist into dataverse with lookup field

[islamshaban]

Very nice Reza, appreciate sharing the good knowledge always!

[VANDIK]

Great video Reza, the only thing I see, is that the users need a premium license and this would be a challenge for the business, thanks 🙏

[dinekakornma]

Thank you so much Reza for sharing this wonderful video

[RustyShiva]

Thanks Reza! Is there a video that speaks about end to end process of a canvas app or model driven app like creating the app in dev env and then UAT pushing it to production?

[EMiller]

Thank you so much, Reza! This is a superb video, meticulously laid out to explain this important process effectively, highlighting the critical points that other YouTubers fail to convey clearly. I especially appreciate how you pivoted between the data flow back to the table build to convey the challenging issues of keys.

I do have a question: Because of my work environment, I am forced to use Dataverse in Teams. It seems that Dataverse in Teams does not routinely allow the creation of new keys in tables. Is there way to do this that I’m missing?

[HiteshPatil-lxzy]

Thanks Raza for such a wonderful video it's really helpful for people like us who works on the Powerapp everyday. I m looking for your support to get solution on one instance where I need to check how many answers are submitted in another SP list vs questionnaire list.. I strongly believe that I will get some solution on this from your end

[banihas]

Hi Reza, great work as usual! Can you by chance share a link to that comparison table between Dataverse and SharePoint you presented at the beginning of the video?

[TheAILead]

Very helpful video Reza. Is there an option to generate the app as Model Driven or Canvas only?

[Brothercole]

Rezza, sorry I haven't watched the video yet but do you cover Multi select choice column in this video? This is a major issue when doing these sorts of migrations from SP lists to dataverse as power query has a challenge with choices columns. Thanks

[DubbLD]

Very informative, thanks Reza! Question, if this was a very large SharePoint list (say 900, 000+ items), would doing this be beneficial? How long would the import take?

[spen]

As always a BIG thumbs up 👍👍 You covered most column types, but what about attachments? ie If you have an app which relies on attachments, would you still use Dataverse or stick to SharePoint? If you use Dataverse, but use SharePoint as the location for the attachments, do you then hit the SharePoint limitations? 💥💥

[kyle]

Great video, Reza! One question, would this work also with SharePoint libraries?

[jase]

This is great, thanks again. Do we still need pro licences to use dataverse tables? I noticed if I create tables within a solution I can use them in a canvas app, with no sign of premium/pro requirements. But I haven't fully tested. Anyway, great content as always. I appreciate it!

[anweshasharma]

Hi Reza - fantastic content as always! I tried creating a table with a SharePoint list, in my case only 20 rows got migrated. I tried 2 other tables (the SP lists have like 5000+ rows). Is this how the preview feature works - they have limited the data that is migrated?

[mallelajyothi]

Hello Reja.. I have a multi choice column, each item have individual approvers how to send approval notification to individual users