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 List in use and make it into a Dataverse Table.
Good news is that this also syncs back to the SharePoint List! Let’s see how.
Let’s say you have a SharePoint List which you want to convert into a Dataverse Table in your Power Platform –
Let’s do this by creating using a Virtual Table which now connects to SharePoint and SQL. Please note that at the time of writing this post, connecting to external data is still in Preview.
Here’s how you can create a virtual Table in Power Apps Maker (https://make.powerapps.com) –
- Once you are in Power Apps Maker, go to Tables and you can drop down from Create Table menu.
- You’ll see and option to Create by connecting to external source.
- Now, you have 2 options at this point of writing this blog. One is SQL and other is SharePoint. We’ll select SharePoint for this example. Both also use the connection you are logged in.
- Once you select SharePoint, you’ll either be asked to select one of the recently used Sites or if you know the URL of the Site in which your list resides, you can choose the same.
Refer below that I’m choosing up to the name of the Sub-site in question.
- So, you can either select a recently used Site or just paste the URL of the Site which has your List in it.
- Once you are in the desired Site, you’ll see the List under that Site.
- Once I select the List, I’ll be asked if I need to change any schema name from the ones identified by the wizard.
- Or if everything looks OK, you can simply click on Next. You’ll be given a summary of what Table will be created from your SharePoint list.
- It takes a few moments to create this Virtual Table for you with the data from the SharePoint List.
Once ready, it’ll appear as below with the data and you can start adding your data as well.
- Also, the data you add from the Virtual Table is also sent back to the SharePoint List.
- This entity / table will be listed as any other Table in the Power Apps Maker with the Virtual type.
Hope this helps!