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