Create Dataverse Virtual Table from SharePoint List | Power Platform
Image Source: Shutterstock.com
Microsoft Dataverse
Jun 13, 2023 12:00 PM

Create Dataverse Virtual Table from SharePoint List | Power Platform

by HubSite 365 about Priyesh Wagh (D365 Demystified) [MVP]

Citizen DeveloperSharePoint OnlineMicrosoft DataverseLearning Selection

Here's how you can connect to an external data source which is SharePoint in this case from Power Apps Maker portal!

Create Dataverse Virtual Table from SharePoint List | Power Platform

Here's how you can connect to an external data source which is SharePoint in this case from Power Apps Maker portal!

  • Step 1: Access the Power Apps Maker portal
  • Step 2: Click on 'Data'
  • Step 3: Select 'Tables'
  • Step 4: Click on 'Virtual Entities'
  • Step 5: Add a new Virtual Entity
  • Step 6: Choose SharePoint as the external data source
  • Step 7: Connect to SharePoint using your credentials
  • Step 8: Choose the desired SharePoint List to create a virtual table for
  • Step 9: Configure the fields and relationships between your virtual table and other tables
  • Step 10: Save and publish your changes

After completing these steps, you have successfully created a Dataverse Virtual Table from a SharePoint List in Power Platform.

Note that with this integration, you can access and edit the SharePoint data through Power Apps and leverage its features for better data management and user experience.

 

Benefiting from Dataverse Virtual Table and SharePoint Integration

By integrating Dataverse Virtual Table with SharePoint, you can effectively combine the capabilities of Power Platform with the robust collaboration features of SharePoint. This provides users with a seamless experience, allowing them to manage data effectively, automate processes, and simplify collaboration. Embracing these platforms together can significantly simplify your organization's digital transformation journey and enhance overall productivity.

Learn about Create Dataverse Virtual Table from SharePoint List | Power Platform

To create a Dataverse virtual table from a SharePoint list, you need to use Power Platform. Power Platform is a collection of services, tools, and connectors that can be used to build and use apps, automate business processes, and create powerful data insights. To connect to an external data source which is SharePoint in this case from the Power Apps Maker portal, you need to use the Dataverse connector. This allows you to easily connect to your SharePoint list from the Power Apps Maker portal. Once connected, the SharePoint list will appear as a virtual table in Dataverse and you can then use it to create a Power Apps app.

To get started, you need to open the Power Platform Admin Center and select the Dataverse option. On the Dataverse page, select the ‘Connectors’ tab and then select the ‘SharePoint’ connector. Enter your SharePoint credentials and select the list you want to connect to and click ‘Connect’. The SharePoint list will now be visible as a virtual table in Dataverse. You can now use this virtual table to create a Power App.

To create the Power App, open the Power Apps Maker portal and select the ‘Create from Data’ option. Select the virtual table from the Dataverse connector and click ‘Create’. This will open a canvas where you can design your app. You can also select the ‘Data’ tab to add data fields and configure the connection. Once you’ve finished creating the Power App, you can publish it and it will be available to your users.

Creating a Dataverse virtual table from a SharePoint list is a quick and easy process. By using the Dataverse connector, you can easily connect your SharePoint list and create a Power App that can be used by your users. This is a great way to quickly create an app without having to write any code.

 

More links on about Create Dataverse Virtual Table from SharePoint List | Power Platform

Create virtual tables using virtual connectors (preview) ...
Feb 23, 2023 — Virtual tables enable integrating data from external data sources by seamlessly representing that data as tables in Microsoft Dataverse, without ...
Create Dataverse Virtual Table from SharePoint List
14 hours ago — Now, you can create a Dataverse virtual table by referencing a SharePoint List. This is an easy way to bring in schema from your SharePoint ...
How to add or create SharePoint lists or libraries in virtual ...
Hi ,. I am looking forward an option to include sharepoint lists and libraries as virtual tables in dataverse. Could you please help with this.
Microsoft Dataverse: How to Use Virtual Tables to show ...
Jan 19, 2023 — Virtual tables are a powerful tool for displaying data from SharePoint and SQL databases in Dataverse. They allow you to create virtual views of ...
power apps tables
15 hours ago — Now, you can create a Dataverse virtual table by referencing a SharePoint List. This is an easy way to bring in schema from your SharePoint ...
Use Dataverse virtual tables in Power Pages sites
May 4, 2023 — Here is a video where I will walk through the process of setting up and configuring an Azure SQL database table as a virtual table in Dataverse ...
Create easier data connections in Power Apps with virtual ...
Feb 7, 2023 — Virtual tables connect the Power Platform to business data stuck in silos, enriching it to use with workflows, AI tools and custom apps.
Create the Virtual Tables in Dataverse With ...
Dec 30, 2022 — A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in ...

Keywords

1. Connect to SharePoint in Power Apps, 2. Create Dataverse Virtual Table from SharePoint List, 3. Power Platform Data Source, 4. Power Apps Maker Portal External Data, 5. SharePoint List Connect to Power Apps.