Gotcha: SharePoint List and Virtual Table Provider


You can connect a SharePoint list to a Dataverse environment using Virtual Tables without any code. However, there are two key things missing from the documentation when it comes to transporting this table via a solution. If the ID on the target environment's SharePoint List is different, you will get an error. You need to create different lists for different SharePoint sites. After importing the solution, you need to update it to point to the correct SharePoint site. You also need to update the SharePoint List ID, which can only be done using the classic solution experience. The workaround creates an unmanaged layer on the target environment, but it seems to be the only way to transport a solution with Virtual Tables pointing to a SharePoint List.


Article 16m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time