Getting Started with PowerApps and a Microsoft SQL Database

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 -

[artemburov]

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!

[johng]

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

[arturlill]

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

[gowriroy]

Amazing video, looking forward to part 2

[hayleyhurl]

So helpful! Thanks Chino for another great tutorial 😄👍

[artemburov]

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?

[gideonyou]

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.

[richp]

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.

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

[benjaminlahsen]

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

[ojsojs]

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?

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

[emilholte]

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.

[karolinaunderwood]

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 ?

[karolinaunderwood]

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

[prasantchettri]

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

[yourmother]

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

[prasantchettri]

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

[nocodecreative]

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

[davidsimon]

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