Getting Started with PowerApps and a Microsoft SQL Database

[@artemburov9456]

The video is a real precious diamond! It is a revelation for me. Indeed, many things are so easy when simply do the stuff on the SQL end. Thank you!

[@johng5295]

Chino, thanks in a million! Very well explained. This is the best thing since slice bread + Power BI at a click of a button. 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++

[@arturlill3670]

Brilliant content: stored procedure >> power automate >> powerapps

[@ChinoDoesStuff]

Totally awesome, right? My SQL video took a while before it started getting views but seems to get a bit of attention now.. glad you enjoyed it

[@arturlill3670]

@@ChinoDoesStuff Most important point said at 25:08, I think.

[@gowriroy3580]

Amazing video, looking forward to part 2

[@ChinoDoesStuff]

Thankyou!

[@DIYD365]

Congratulations on 1k 👍🏻

[@ChinoDoesStuff]

Thank you so much 😁

[@hayleyhurl6225]

So helpful! Thanks Chino for another great tutorial 😄👍

[@ChinoDoesStuff]

Glad it was helpful!

[@benjaminlahsen6721]

Hello! Great video. I wonder where is the second part of this video? Best regards!

[@ChinoDoesStuff]

Hey Ben.. happy that you liked the video...I think it could be time soon for a follow up... :)

[@richp2894]

Hey Chino - Thanks for the video. I know this is a pretty old topic, but... I thought this was EXACLTY what I needed to overcome my problem, but it seems I'm still missing something. I'm probably over my head here anyway, but seeing as you appear to really know your stuff, here goes...Is it possible/advisable to build a PowerApp that could be deployed to some members of the general public (not in my tenant) to be used out in the woods on hiking trails, but connected to an Azure SQL db? I have the app. I have the db (configured as per your instructions). I added a security group to AAD and added a few AAD users, each from different tenants (to see if the IP address is a deal breaker). When I try to connect from another IP address, it doesn't work because the IP address isn't allowed. Questions are: is there a way around this IP Firewall rule? If so, is it advised? If not, is it possible to deploy such an app to external users while using a cloud-based data store? If not with Azure SQL, then what else might work? Thanks agaifor your content. Very enjoyable.

[@ChinoDoesStuff]

Hey Rich...thanks for your nice comments...glad you enjoyed the video... The bad news is you cannot build power apps that are externally facing. There are these things called Power Pages which can be used for external users but they aren't really power apps and in my opinion the use case is very different. you probably need to look at one of the many awesome web frameworks out there to build your app in this case.

[@emilholte9756]

Really helpful video! Would love to see how to update a stored procedure based on the users adjustment. Lets say the user wants to change amount ordered how do I make a flow that updates back to the SQL server table.

[@emilholte9756]

Almost all the videos are with sharepoint lists. But it is more common for companies to have the data stored in Sql Server isn't it?.

[@ChinoDoesStuff]

It can be, but using a data connection to SQL requires a premium licence so many organisations look for cheaper alternatives. I have built far more apps using SP Lists than SQL but that doesn't diminish the importance of being able to do this at an enterprise level. Thanks for watching and commenting, it's really appreciated!

[@GSoftagon]

Thanks for the video. I was expecting you to use View instead of Stored Procedure, which would not have required Flow/Power Automate. But since you used Stored procedure, I now know how to implement it. I have never used Flow before. Once again, thank you.

[@ChinoDoesStuff]

You're very welcome :)

[@ResponsibleXI]

Thank you for this great introduction to SQL for PowerApps. I have 2 questions though. 1. How do I grant access to all my company users for the app connected to Azure SQL as data source? Is that creating a security group and adding the group to the database with read permissions. 2. The job using stored procedure can also be done on Power Apps? Using collections and AddColumns.

[@ChinoDoesStuff]

My recommendation would be to always use Stored Procs, that way you can use a 'service account' for connections to the database.

[@karolinaunderwood1039]

this is really great, thank you. I am just starting using SQL in PowerApps.... have you got any videos on how to update SQL tables with PowerApps ?

[@ChinoDoesStuff]

Not yet...this particular video took quite a while before it started getting real views..I assumed that most power apps developers were not as interested in using SQL as a data source.. I think it being a premium connector as a lot to do with that.. I may follow up this subject if there is more interest

[@jagratimodi7608]

Great demo!

[@ChinoDoesStuff]

Thanks!

[@tussenikenjij]

Clear . I was used to using SQL, but the 2nd part was great to watch. Question: why don't you use views instead of a stored procedure? I allways use views when I want to make 'tables' with data from several tables like in your example.

[@tussenikenjij]

ah. This question is already asked before. NOthing new under the sun ;-)

[@naeemmehyar]

thank you , amazing

[@ChinoDoesStuff]

You can call SQL stored procedures directly from Power Apps now. Probably will do a video soon on the subject.

[@ojsojs6004]

Nice tutorial Chino. I have just a question. Is this possible? Using SQL View as Data Source, How to update a specific table only? I am new to Power Apps. I have an empty vertical gallery with sql view as a data source. Let say I have a view name SampleView created at SQL. This SampleView has table1 and table2 joined.If I use Sampleview as a data source for an empty vertical gallery. How can I update record on table2 only? Let's say I put Text Input named TextInput1 in the gallery. Its value came from table2. If I modified the value of the first row of TextInput1, how can I update it back on table2?

[@artemburov9456]

A question. Why a stored procedure? Wouldn't be a View better? With a View, there is no need in adding Power Automate. What's the reason for sp?

[@ChinoDoesStuff]

That's a good question.. stored procs are perhaps a bit more versatile?

[@artemburov9456]

@@ChinoDoesStuff Yes, perhaps it is true. In my case, I will use a View, just because it seems to be more simple (no need to create a flow). Maybe I will also try a stored proc with the flow to compare performance. What about the next part on PowerApps and SQL Server? There are not too many videos about it. While the topic is one of the most interesting and the less explored.

[@ojsojs6004]

@@ChinoDoesStuff Hi Good tutorial. Where is the part 2? Using view it is not possible to update a specific table let say the order table with Power apps. So that is why you use Stored procedure?

[@nocodecreative]

very interesting, I'd like to see part 2! Is it possible to update data via the stored procedure?

[@ChinoDoesStuff]

It might be a while before I get to part two, but the answer to your question is Yes it is possible. Try and use the same principles I have shown you in this video and you should be able to get it working :) Let me know how you get on.

[@karolinaunderwood1039]

one more question: can you build filtering of the gallery based on the either View or Procedure?

[@ChinoDoesStuff]

If you can derive a value out of it then yes

[@prasantchettri133]

Everything thing work so far. One thing that failed is after using set variable for the icon. the variable does not populate with all options on the gallery

[@ChinoDoesStuff]

Did you work out what you were doing wrong?

[@prasantchettri133]

Was there a failure in updating data from power app to SQL DB store proc? As I do not see the video tutorials which is the key part for updating data from mobile or scan data from mobile app

[@ChinoDoesStuff]

No, I just never got around to doing that video. Is that something you'd like to see?

[@BrechtGijbels]

@@ChinoDoesStuff Yeah it would be great to see how to handle errors when the sproc fails. Thanks already for the more than helpful video. Awesome work there for indeed a very important part of the app.

[@terryliu3635]

Thanks. But I thought you would connect to the Paas instead of Iaas sql dB...

[@ChinoDoesStuff]

Hey Terry... I did my absolute best to not make the Azure SQL part the focus for this video... The intention was to give the viewer only a very brief introduction into using Azure SQL in relation to developing Power Apps.. It's really just meant to demystify things a bit hence why I didn't want to go into Azure / DB configuration details. Cheers and thanks for the feedback!

[@terryliu3635]

Chino Does Stuff thanks for the reply. That makes sense!

[@ChinoDoesStuff]

No worries Terry..thank you so much for watching and commenting..it really helps the channel!

[@davidsimon9353]

Trying to find a part 2 for this, did it ever get an update / delete video for sql? Thanks in advance!

[@ChinoDoesStuff]

No update for this video as yet as the first part really didn't get the views I was initially expecting from such an important subject..

[@davidsimon9353]

@@ChinoDoesStuff Thanks! I've been developing an app with about 25 SQL relational tables and would love to know a better way to do this better than my current method of several patch commands to ensure the linking tables dont break. I have a feeling stored procedures are the way to go. Thanks for the Reply!

[@ChinoDoesStuff]

Even though I haven't seen your app I can say that Stored Procs will be the solution!!!

[@ivannaivanova3623]

I didn't understand 16:35 where does the username come from and how can I set up one?

[@ChinoDoesStuff]

All I did there is set up a new user within the database itself so that it was specific to that db and application. Don't worry too much if you are unsure what was happening there as it's more of a database management thing and not super relevant to building PowerApps using azure db.

[@konstantinpodgaets2313]

it is so complicated that I had learned how to create web applications on C# before this screwed power apps

[@ChinoDoesStuff]

Sorry but I don't really understand what you are saying...

[@vigneshravi6025]

Something

[@ChinoDoesStuff]

:)