{"id":22724,"date":"2023-01-10T08:56:58","date_gmt":"2023-01-10T16:56:58","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/virtual-tables-creation-wizard-now-in-public-preview\/"},"modified":"2025-06-11T07:47:00","modified_gmt":"2025-06-11T14:47:00","slug":"virtual-tables-creation-wizard-now-in-public-preview","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/virtual-tables-creation-wizard-now-in-public-preview\/","title":{"rendered":"Virtual tables creation wizard now in Public Preview"},"content":{"rendered":"\n

<\/p>\n\n\n

Have you tried creating a virtual table and found it too difficult? Do you wish you had an easy way to integrate external data from SharePoint and SQL into Dataverse?<\/p>\n\n\n

We are excited to announce that makers can now create virtual tables directly in the maker portal in just a few minutes using a guided creation wizard.<\/p>\n\n\n

With this new experience, you can create virtual tables from SharePoint and SQL without any code, and without leaving the maker portal. In minutes, you can set up your connection, pick your SharePoint Site or SQL Database, select your SharePoint List or SQL Table, and your virtual table will appear in table hub ready to use. You can optionally choose to configure your connection references and table details, such as column and table names, which was not possible for virtual tables until now.<\/p>\n\n\n

Upon creating the virtual table, it will act like a standard Dataverse table, from which you can create relationships with other data in Dataverse, build apps, or use it in a flow.\u00a0<\/p>\n\n\n

<\/p>\n\n\n

What are the benefits of virtual tables?<\/strong><\/p>\n\n\n

Ever wondered how you can quickly build a model-driven application from your existing SharePoint list? Now you can use virtual tables. Let\u2019s say you have a list in SharePoint that your team members use to enter information every day, you can use a virtual table to represent that data in Dataverse without migrating the data from the source. Furthermore, you can integrate the SharePoint data with other tables in Dataverse. The data is accessed using metadata, so no meaningful storage space is used in Dataverse even if you have thousands of records in your data source. Because virtual tables allow Create, Read, Update, and Delete (\u201cCRUD\u201d) operations (if the data source permits those actions), you can update information to the SharePoint list through Dataverse.<\/p>\n\n\n

Like SharePoint, you can build virtual tables from SQL tables. In addition, you can also create read-only virtual tables from SQL views. Or if you are using serverless SQL in Azure Synapse to access Azure Data Lake Storage Gen2, then you can use SQL connections to create virtual tables from external SQL tables and work with that data in Dataverse. For Azure, data access permissions can be managed via AAD Authentication and RBAC.<\/p>\n\n\n

How can I start using the new virtual tables wizard?<\/strong><\/p>\n\n\n

In maker portal, go to either Tables<\/strong> or Solutions, <\/strong>and choose + New table<\/strong> > + New table from external data <\/strong>in the split-button menu.<\/p>\n\n

\"graphical
“New table from external data” entry point<\/em><\/figcaption><\/figure>\n\n\n

You will be prompted to select a connection, or you can create a new connection. After that, you\u2019ll select your data set and finish the setup.<\/p>\n\n\n

\"graphical<\/figure>\n\n\n

We also provide optional configurations for connection references and table or column naming.<\/p>\n\n\n

\n
\"graphical
Figure A – use or create a connection reference<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n
\"table\"
Figure B – configure table and column details<\/em><\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n\n\n

How can I learn more?<\/strong><\/p>\n\n\n

Read more about virtual tables and virtual connector providers here:<\/p>\n\n\n