Power App and SQL Server Integration

Learn how to connect Power Apps to SQL Server & Insert new records in under 10 minutes! This Insert Data video will work with SharePoint integrations as well.

[MichaelAMalry-ryhg]

One of THEE best PowerApp videos ever!!! Straight-forward, no fluff, clear, and very informative. Saved me a few hours. Thank you so much!!! Looking forward to seeing more of your videos.

[johng]

Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥

[Cordycep]

Hi: What if SQL Server is not cloud based? It would seem I have to migrate local SQL Server to cloud in order PowerApp connect to it.? thanks

[muratusta]

this video is great, thank you so much💯

[montseasencio]

Hi!!
I Create a Power App that connects to my database located on my SQL Server. The database contains 4 tables, 2 of which are related through an intermediate table. I need the IDs from both tables to be added to the Power App as I fill out the other tables, and when I click another button, the IDs are added to the intermediate table. These tables and/or forms are on different screens.

[csabageleta]

Do you know why I get this error when I try to add a new record? Network error when using Patch function: specified record was not found. Thanks!

[YoungRickyDiaz]

Is it possible to insert a record in a SQL table that has an Identity column as it's primary key?

[montshusiamo]

would it be possible to make some slowly changing dimension methodology in power app by using existing record to make update but keep original record and make new record the latest one

[steliosv]

Perfect video and very well explained ! Well in my case at the submit button when i try to insert a record in my db, i have the following error. "network error when using Patch function: The specified record was not found". Does anyone have any ideas ?

[eddycaceres]

When I added the edit form and use sql connection, it cannot allow to edit, just show me in view mode, I already have a pro license in power apps.... but I see that my canvas has standard license

[jonkenny]

At 4:13 it shows a list... say there is more than two objects like an employee list... could there be multiple tabs on the one page that a user can toggle? like pages 1-3? great video

[Sodomantis]

What is this?`Power apps tutorial that does something usefull? Take all my love!

[johnbrennan]

Hi when you type in the username and password is this the person that is in the Powerapp