In one of his most integral videos to date, Chino takes you step by step through developing PowerApps with Azure SQL database repositories. Download link to SQL Management Studio - docs.microsoft.com/en-us/sql/...
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++
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.
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.
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.
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!
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?
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.
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.
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
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.
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.
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 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.
@@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?
@@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!
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.
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 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.
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!