How to use SharePoint Lists in Model-Driven Power Apps with Dataverse Virtual Tables

You can now build a model-driven Power App using your existing SharePoint lists, without needing to integrate or move your data. In this tutorial I show you how to create no-code virtual tables in Dataverse, create relationships between your SharePoint list data and other tables in your model-driven app, and test out the real time updating of data in both directions. And yes, I get a bit excited about it!

****************************
Connect with me:

****************************

[chadalthaus]

Great walkthrough of AMAZING functionality! Now I need to go try this out for myself.

[brendanbowen]

This IS super exciting! Thanks for sharing this!

[santhuthgreat]

Hey Lisa, last one minute of video is precious and very useful 👏👏

[sirwonkalot]

Yes - Very exciting indeed! Thanks again for another great video, please keep it up. I have been getting my other associates to subscribe due to your clean/clear/direct method.

I hope you will have some training on advance topics dealing with model-driven app search/indexing in dataverse Thank you again Lisa.

[henryburkhardt]

Hi Lisa, thanks for sharing this quick tutorial with us. This new wizard looks very promising. What I can not figure out is how to propagate structural changes from the SharePoint list to the virtual table. Let's say I add a column or change a data type of a column. I think schema change would be the correct term. It is not automatically reflected in the virtual table. Thanks in advance 😊

[kellyliu]

Great video and awesome feature! Is it any concern about the security for Dataverse Virtual Tables and SharePoint?

[jasonhensley]

Looks Great Amy - Thanks.

Is it possible with a model driven app to bring data in via an API? e.g. Customer list stored in MYOB.

[PankajSingh-poti]

Hey Lisa, Thanks for this Video, Will this also work if I have a field in my SharePoint site with data type person or group?

[patrickleavydatadrivenfina]

Hey Lisa, great videos! Have you ever tried to build a job management system with power apps? my SMB clients need that kind of thing: take a job number through the system all the way to invoicing. invoicing would be in xero.

[peterhale]

Export / Import etc - does everything still work as intended. What happens if you have a SharePoint site for Dev and another for UAT, Production etc?

[loegtcr]

Thank you for the nice video Lisa, but it seems that the Virtual Table can not get the look up column and person column data in sharepoint list

[Romaine.L]

Lisa, you are amazing. I'm thrilled to have found your channel. @2:50 I get the error "Something Went Wrong. We weren't able to open your table. Try reloading or reopening." Any idea wat tat might be about? None of the data seems to load in at all.

[garmatik]

Thank you so much Lisa - great Video! Could you do a Interface to SAP as well like this?

[mkhijazi]

Thanks Lisa, there was a relationship manager field in the SP list, is it supported, and if it's not supported Dataverse will automatically ignore it at the time of table creation?

[haziqaiman]

can the attachment also can be pull into the dataverse or how it will work? im having sharepoint list that only purpose is to store attachment

[PeterHarket]

This is awesome! How does this work with the row limitation in sharepoint? Is this now increased to “infinite” to match dataverse?

[denisskorikov]

How does the security looks like for this approach? Access only for Virtual Table is enough? Or you also need to give an access to the Sharepoint list? Many thanks in advance!

[mhripko]

Lisa, great and exciting video on SharePoint as a virtual table. I've mastered SharePoint as a virtual table but still cannot figure out how to do it with Excel. Any chance you can put your suppliers into an Excel table in a workbook, and then create a virtual table from the Suppliers table def inside of the excel workbook? Everyone says it can be done, but I've yet to find someone who can demonstrate it from start to finish like you do here....

[namhoangtran]

Good job Lisa, is that virtual table caculated into dataverse instance storage? Or just storage of Sharepoint?

[ramirosousa]

Hi Lisa,
First thanks for this video. It is very awesome. I just have a question. The records will be saved on SharePoint List and just will show on dataverse? Or the record will save in both of them? I just want to know if external table record will use dataverse capacity.