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!

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++

So helpful! Thanks Chino for another great tutorial 😄👍

@ChinoDoesStuff

4 жыл бұрын

Glad it was helpful!

Amazing video, looking forward to part 2

@ChinoDoesStuff

3 жыл бұрын

Thankyou!

Congratulations on 1k 👍🏻

@ChinoDoesStuff

4 жыл бұрын

Thank you so much 😁

Great demo!

@ChinoDoesStuff

3 жыл бұрын

Thanks!

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.

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?

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

2 жыл бұрын

You're very welcome :)

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

@ChinoDoesStuff

10 ай бұрын

If you can derive a value out of it then yes

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.

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 ;-)

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

2 жыл бұрын

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

2 жыл бұрын

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!

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

3 жыл бұрын

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

@BrechtGijbels

3 жыл бұрын

@@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.

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

@ChinoDoesStuff

3 жыл бұрын

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

3 жыл бұрын

@@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

3 жыл бұрын

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

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

2 жыл бұрын

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

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

@ChinoDoesStuff

3 жыл бұрын

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.

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

10 ай бұрын

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

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.

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

2 жыл бұрын

Did you work out what you were doing wrong?

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

3 жыл бұрын

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

@artemburov9456

3 жыл бұрын

@@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?

Hi Chino, i followed your steps for the power automate flow but when I type in SQLOrderdata. I don't have ResultSets like you do? Please help chino

@ChinoDoesStuff

2 жыл бұрын

Did you get this working?

@yourmother746

2 жыл бұрын

@@ChinoDoesStuff yes thanks!!!

@grantarcher7493

2 жыл бұрын

@@yourmother746 So what was causing it?, I'm facing the same issue and I cant see the cause

@josephetorne7226

Жыл бұрын

@@yourmother746 hey man. may i know you got it working? i am having some problems getting mine to work. thanks.

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

@ChinoDoesStuff

4 жыл бұрын

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

4 жыл бұрын

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

@ChinoDoesStuff

4 жыл бұрын

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

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... :)

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

@ChinoDoesStuff

6 ай бұрын

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

Something

@ChinoDoesStuff

2 жыл бұрын

:)