Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Dataverse Virtual Table Relationship - On Prem SQL

Hello all, I'm setting up the Virtual Connector Provider to use a long standing SQL database through Dataverse. Creating the virtual entities is not a problem, and I've finally established a relationship (the external name MUST have the prefix in front of it, so use the logical name of the column.)

The problem is that the original values are not populating into the new Lookup field. After establishing the relationship the new Lookup field is blank.

I'm sure I've missed something. Any assistance would be greatly appreciated.

Frequent Visitor

Thought the Lookup Field definition might be useful.



Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,745)