cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Best practice for working with data in SQL Server

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 ?

 

 

1 REPLY 1
Highlighted
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,113)