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 / When creating a virtua...
Power Apps
Answered

When creating a virtual entity (table) in Dataverse that references an external table e.g. SQL, can we write data to it?

(0) ShareShare
ReportReport
Posted on by 932 Super User 2024 Season 1

I started learning about creating virtual entities in Dataverse that reference external data. Here is the video I was following:

 

https://www.youtube.com/watch?v=3KJdBe3BkM4

 

Lets take the following scenario. If I create a virtual entity that references a table in SQL. I create a simple Canvas App that performs CRUD tasks. The Canvas App is connected to the virtual table. Can I perform CRUD operations on this table?.

 

Thanks in advance. 

Categories:
I have the same question (0)
  • Verified answer
    timl Profile Picture
    36,411 Super User 2025 Season 2 on at

    Hi @HamidBee 

    Yes, this is possible and it is something that I have done.

    With a virtual table, it's possible to update, create, and delete records from an underlying SQL Server table.

  • HamidBee Profile Picture
    932 Super User 2024 Season 1 on at

    Thanks for the reply.

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 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard