web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Changing Virtual Table...
Power Apps
Unanswered

Changing Virtual Table Source pointed Sharepoint

(1) ShareShare
ReportReport
Posted on by 2

Hi All, 

I was trying to figure out how to change a virtual table source from a dev copy of a list to a prod copy and I couldn't find any documentation on this.
Took some time of figuring out but finally did....thought I'd share this.

Please advise if this is not the right place. 


Essentially once you've imported your VT to your target ENV and need to repoint or even refresh the connection (connection could break):

1. Go to Advance Settings -> Administration -> Virtual Entity Data Source
 Here verify that the data source that your VT is using is pointed to the correct one (SP Site in this case). You can either update the value or create a new record (I had to create a new one because my import failed somewhere and corrupted the record).

2. Advance Settings -> Customizations -> Customize the System -> Entities -> Look for your VT. 
Here, if you created a new DS (step 1), you will need to change the data source drop-down to the new record you created in step 1. (if refreshing, this should do the trick)
Next, change the External Name value to the correct ID of  SP List, 
Do the same thing for External Collection Name but keep the "s" at the end. 
Save and publish. 
Revisit your VT and should not be showing you data to wherever you repointed it. 
 
@JanGenese09 

 

I have the same question (0)
  • CU06101838-1 Profile Picture
    3 on at
    This was incredibly helpful after deploying from DEV to PROD. The error message was less than helpful (unexpected error 2147746326). That “unexpected error (2147746326 / 0x80040216)” on virtual tables almost always means the SQL data provider can’t read from your data source in the target (prod) environment.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard