Jan 19, 2023 3:47 PM

How to Use Virtual Tables to show SharePoint and SQL Data in Dataverse

External YouTube Channel

Do you wish you had an easy way to integrate external data from SharePoint and SQL into Dataverse? Maybe you have a Power

Do you wish you had an easy way to integrate external data from SharePoint and SQL into Dataverse? Maybe you have a Power App canvas app that's connected to SharePoint data and you want to be able to create a Model Driven app based on that data but you don't want to have to move your entire solution to Dataverse. Virtual Tables to the rescue!

In this video I'll walk you through the brand new virtual tables creation wizard in Dataverse that lets us easily take our existing SharePoint and SQL data using the Power Platform connector model and surface that up inside of Dataverse.

  • Virtual Tables announcement:

https://powerapps.microsoft.com/en-us/blog/virtual-tables-creation-wizard-now-in-public-preview/

  • . Known Limitation and Troubleshooting:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/limits-tshoot-virtual-tables?branch=pr-en-us-7468&tabs=sql

In this Video

  • 00:00 - First Marker
  • 00:45 - Creating a virtual table in Dataverse
  • 04:33 - Create a model driven app based off the virtual table
  • 05:19 - How does the sync work?
  • 06:26 - Known issues and limitations

More about this Topic

Virtual tables are a powerful tool for displaying data from SharePoint and SQL databases in Dataverse. They allow you to create virtual views of your data that can be used to quickly filter, sort, and manipulate the information within. You can also use the virtual table feature to join multiple tables together so that all relevant data is available in one view.

Jan 4, 2023 — Create the data source. Now create the virtual table data source in Dataverse. Select the Gear icon Advanced Settings. Advanced Settings ...

Jan , 2023 — With this feature, you can now create virtual tables directly from the SQL table, SharePoint and excel using a guided creation wizard.

Dec 29, 2022 — Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, ...

Jan , 2023 — One of these external sources was a custom application with Azure SQL as backend and in the session I've explained how we have used the