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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Best practice for work...
Power Apps
Unanswered

Best practice for working with data in SQL Server

(0) ShareShare
ReportReport
Posted on by 4

Hi

 

I'm looking for someone to confirm that the following is possible.

 

I have a table (Product) sitting in a Azure VM with a SQL Server 2016 installed. The SQL Server is acessible through an endpoint and i can connect to the table in Power Apps. Now in that table i have some rows that i would like to be able to edit - from an end user point of view.

So question 1 is - is that possible using PowerApps?

What i found so far is that it's possible to change data IF it's in a sharepoint list, but 'm looking for a solution where i want to be able to edit/add a row in the product table in the SQL Server. So far noone seems to have tried that out (any video around would be appreciated)

 

In PowerApps i can see that i can add a Forms -> Entity Form (experimental) where it is then possible to edit/add a row in a table BUT it then needs to reside in the Common Data Service, which is then not accecible from a SQL Server.....or how would you then get the information from CDS into the SQL Server Product table (which is where the rest of the ERP system resides) ?

And does Experimental mean that it's probably going to be decomissioned anytime soon ?

 

 

Categories:
  • v-micsh-msft Profile Picture
    Microsoft Employee on at

    Hi @cpl123,

     

    Yes, it is possible to use PowerApps to edit corresponding rows in PowerApps.

    Follow the article below to connect to the table in SQL Server:

    Connect from Microsoft PowerApps to SQL Server

    There would be three screen generated, after selecting the corresponding row, then we could edit it with the editform control:

    Understand data forms in Microsoft PowerApps

     

    Regards,

    Michael

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 396 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 323

#3
WarrenBelz Profile Picture

WarrenBelz 193 Most Valuable Professional

Last 30 days Overall leaderboard