I struggled not being able to edit my fields, only to find out that I didnt set a PK on one of my tables and you mentioned it at the end of this video. You saved me hours of frustration. Thank you boss!
Thanks Shane for the great video! You made it fun and easy to learn. One thing to point out though, in your video at 23:30 when you execute the query again, your query wasn't actually showing the MyID column as you said. In order to see that new identity column, you'll either need to regenerate the select query from the table or add the MyID column to that existing query.
Hello Shane, Thank you for all these video lessons. Sharing all this knowledge with us it is a philanthropic act. I want to let you know that I'd like to see more videos about "PowerApps and Azure SQL Databases".
Great Vid! One correction - in your query to add a primary key you should replace "PK_TransactionHistoryArchive_TransactionID" with "PK_VideoData_MyID".
Hi Shane, Thanks for the vids, but could you vary your 'here's our intro' section? I want to watch the next Shane Young video thinking: what's Shane Young going to do this time? A suggestion: put on a native american headdress? All the best, Ricardo
Thank you. All you need to do is add another connection to the same SQL database and then choose the other table. This video has an example with Excel and SharePoint. Your steps will be the same but instead choose a SQL connection. ua-cam.com/video/fqH1U0_TanI/v-deo.html
Hi man, great video! it helped me a lot. I just want to point out that the code for creating the primary key (22:20) where it says 'PK_TransactionHistoryArchive_TransactionID' it needs to be different every time, I'm not sure why but it may be the name of that primary key so it can't be the same if you have multiple tables. thanks again for this video.
In that example you are the administrator of that database. How can other people use the app, adding, eliminating and editing records? Do you manage those permissions from power apps or do you require a special configuration at SQL Managment Service to grant those permissions? Great video as always!
Power Apps uses that one account for the connection to the database. So they are all interacting with the same account. Up to you to manage the app to control what they do.
Thanks Shane for yet another amazing video! just a quick question, do I need to provide access to the SQL db for all my users? I tried doing an app with SQL connection, I can see the data but they cant. Thanks again for your amazing help on the PowerApp community
Hi Shane, if a company has already bought the packet office 365, Do they have to buy pay for build an sql data base or not? Thank you for your videos, you are amazing
Shane, is there an easy way to connect to SQL Server DB AND specify the tablet layout? It seems like the default is always phone, but I like how it pre-builds the screens for you and it would be good to not have to recreate it manually in the tablet layout having to choose "Start from blank". Thanks!
Hey Shane, nice vid man microsoft should get you a medal for all the efort. ¿Is it posible to teach us to join this table with a Sequence? This is one of the main reasons im migrating from excel to sql. Thanks again
Great Azure SQL Database tutorial Shane! Much appreciated!! Once an application is created, how are others allowed to access the SQL Database? Are apps built using an application ID that has RW but not admin? Or does each user need to have an Azure/SQL License?
Hi Shane, Great video about Azure.. I regularly watch your video about Power Apps.. I am learning to build Power Apps & even more interesting to more about Azure SQL end2end.. If you can suggest good UA-cam channel would be a great help. Thanks😊
Thank you for the Kudos and for watching. Sadly, I don't have any other suggestions for you unless you haven't found my Azure videos yet. :) They aren't a lot of them but they can help.
Shane, another great video. Can you point to one of your videos where you do image capture and storing to sql server and pulling them back? Thank you much in advance.
Shane - great Video (as always)! Quick question. Why is CDS better than SQL? Currently using SharePoint lists with my first app but I’m currently evaluating data solutions for the next version of our internal business app. As a data analyst I’m naturally drawn to SQL but I don’t want to overlook the better solution.
Hi Shane. Great video thanks. I want to give users access to a power app that will be used to enter data into an azure sql database. However, I don’t want to give them write access to the database. Is there anyway of using a service account? I don’t want users to be able to reuse the connection in their own power apps. Thanks again
This video will help. Just ignore where I talk about P1 and P2. Those are old concepts but Environemnts will help studio.ua-cam.com/users/videoNqQGysNCac0/edit
Thank you Shane. One question: Does using an SQLdB on the back end help allow for many to many relationships or join tables? My understanding is that PowerApps simply can't work with those kinds of relationships and that may be an issue for my project. Thanks in advance for your response!
One to many or many to many relationships is all about you connecting the dots with a key. PowerApps doesn’t care. 😀 in my repeating tables like InfoPath I show 1 to many with SharePoint.
Hi Shane nice work, I have a doubt about Azure. I exported to Azure Mysql my local DB, after export I try to connect whit azure,but I need use my local gateway because only I can connect whit a SQL server directly, can connect mysql whitout gateway?
In following your video, when you got to the part about open a hole in the firewall, I hit subset instead of sign in. As a result, I am not able to connect to powerapps. Do you have any idea how I can correct that>
Great video Shane, it cleared up a lot of areas that I was wondering about Azure SQL & PowerApps. Also, I appreciated your comments trying to place Azure SQL in context as a data source to PowerApps roughly between Excel / SharePoint and the Common Data Service (CDS). One question related to the above idea - Would it be true to say that you would probably only need to connect a PowerApps App to an Azure SQL database if the data was already held in Azure SQL tables already? i.e. wouldn't it be better to create an Entity in CDS to hold the data if you were starting from either scratch or sitting with the Data in Excel?
Thank you for this Video, I've been watching your other video titled Power Apps Cascading dropdown. I'm wondering if it's possible to create 2 tables in SQL similar to Department and Job title and apply cascading dropdown in powerApps.
Hi Shane, thank you for this video, it was excellent! Q: After successfully completed all the steps to create the app with the SQL Server connector, and as it's basically for training purposes, I should delete the app and delete the #Resource Group in Azure to stop billing, correct?
Thanks for the great demo! Quick question, are we able to connect more than 1 databases or a combination of database and custom on-premise APIs within the Power App?
Great video :), powerapps technology is also promising, unfortunately I have a problem with which I have been fighting for several days, maybe you've met with a similar one ??? I have a sql database on MS azure, I added my ip and I can connect from MS SQL Server Management Studio to Auzre, I also have a connection in PowerApps and everything works in design mode, I add eg Data Table, I can see records if I run an application from this level everything is OK. However, if I try to run the application without going into editing (without running the App studio) then the Data Table is empty, no data is available. I have all the environment within my organization, I am the administrator and the owner of the sql database. Do you have any idea ? Regards, Roberto
Fantastic explanation Shane :-) . I have a simple question. Can I use 2 or 3 table within PowerApps?. At the moment I have an app with 3 excel tables and I would like to transfer them into a Database. Can I manage these tables with PowerApps? Thank you in advance and have a great day
Hi there - as always Shane you are brilliant and thank you for the video.No comes the question!I am working with an Azure SQL database for an HR app. When creating a new screen you have the option of using a People template, which is great. I am now just having a hassle trying to link back to my SQL table on the Display Name field. Any ideas?Kind regardsCaroline
Hi shane , Thank you for the nice video ...i have one issue ..i have application where my data source is sql server where i need to auto populate the created by , created date , modified by and modified date into the SQL server table ...please can you help how to do that ..!
Hey Shane, Nice Video, I wonder if there is a posibility to create a PowerApps that be able to update multiple tables? Thanks in advance. Best Regards.
Great video shane, i was going mad about de PLUS BUTTON, just one thing missing for me. How to manage date fields. Going with my data to .csv get all my dates to numbers (44523) and importing to sql failed if i change field types to date, so i followed with string as yoir video suggested. But now my powerapp is built, i need to show them as dates, and more important, edit and create new entries with date format. Do you know how to fix this?
As always Shane, your knowledge astounds me. Silly question, I've created a rather large digital process, with lots of tables and apps and cool fun things. I've realised today that I did something so incredibly silly when setting up one of my tables, and included a space between two words (ie, dbo.Participants Combined). Rooky error, I know, but now that I need to do the process you have mentioned in the code above, with the addition of the PK, it keeps identifying a syntax error which I can only presume is because of the space. Any ideas on how to get around it? I thought I would be cheeky and try renaming the table and deleting the space, until I realised I crashed about half a dozen apps and had some rather concerning messages from users. I really really really don't want to have to reconnect everything to a new table just to change the name to be without a space, I have a feeling that workload will be horrendous! Any tips would be so very appreciated, as always!
It keeps coming back with Msg 102, Incorrect syntax. I just cannot see what the issue is. If I get a chance later today I will copy the query into here... clearly I'm missing something! @@ShanesCows
Fixed it, can't remember how, but it's working now. Thanks as always. I'm now working on the next big bundle of processes, and have created a new table as the source for the information. I tried added this super important query code, but keep getting rejected and told that the section reference PK_Transaction… (that part) already exists in the database and cannot be used. Ideas on what I have stuffed up? I have a lot of tables talking to PowerApps, so need to be able to do this across multiple processes.
Hi Shane, When I am trying to add a new SQL server connection, It shows 'Adding connection' and then 'Something went wrong, Please try again later' message. Can you suggest something to resolve this issue?
Hi Shane, can a dynamic connection to a SQL Server database be created? for scenarios where we have a Development database and when we are ready to deploy to Production, we can just update the connection server or database name without having to update the data source in the application, thanks.
Shane - love your vids and you make it so much easier to pick these new things up, and coming from a dotNet world that's a refreshing change! Can I ask you for your opinion of using Powerapps/Flow/Azure Sql for a fully loaded data-driven web solution and how does the licence work if you want outside users to log in using security within our Sql Db i.e. not MS sign-ins - is that the portal licence (at $100 i think)?
I used SQL server 2019 and got stuck @ 25:05, the setup process doesn't seem to be the same please help. Thanks for the great videos Shane, you help lots of us.
Hey Shane, When I try to add import a second table into SSMS I get the following error when I try to make a primary key using the script on the second table. Msg 2714, Level 16, State 5, Line 2 There is already an object named 'PK_TransactionHistoryArchive_TransactionID' in the database. Msg 1750, Level 16, State 1, Line 2 Could not create constraint or index. See previous errors.
@@ShanesCows thankyou for replying back, shane, could not possible with custom connectors also? If we have 1000+ users, how to manage licenses as it would be huge amount, and we are going to build 10+ apps , Can't pull in SharePoint from SQL as we have lots of records there. Any idea you can suggest please.
Hello Shane, thank you for the video it's extremely helpful ! I'm hoping you could help me with something, I was wondering how we can reuse the formula below which you nicely pasted for us. I want to import many tables and have a primary key for all of them - I tried to duplicate what I learnt in this video however I get a error :(. alter table dbo.data Add MyID int IDENTITY (1,1) NOT NULL, CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (MyID)
Shane Young Shane, I receive the authentication error when I try to log into the SQL connection. It is at 24:50 or so on the video. I have Azure account and database set up per the video, but when I try to log in it does not recognize me. I appreciate your time and if you think it will help, I am happy to buy some time through Powerapps 911. Best, Frank
Hi Shane. Also this can be a good option if you don't need all feature of SQL Server Management Studio, but just query etc.: docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-2017
I couldn't get that syntax to work...had to do with the clustered primary key this is what worked for me CREATE TABLE [dbo].[POA_SS]( [Stopword] [nvarchar](150) NULL, [Timestamp] [nvarchar](17) NULL, [Created by] [nvarchar](150) NULL) alter table dbo.POA_SS Add MyID int IDENTITY (1,1) NOT NULL, CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY NONCLUSTERED (MyID) NOT ENFORCED
Hi Shane, is it possible to build an approval process with Azure SQL and PowerApps setup with Microsoft Flow? If yes, what will be the trigger action for MS Flow?
too much talk, no project , no hands on , simple demo is useless, there are hundred of video to demo the basics and concept . you have to have real world work experience to do a real project demo
Sorry it wasn't what you were looking for, but a lot of people have found it helpful for the intro they wanted and needed to get started. There is plenty of more advanced content in my library or others.
I struggled not being able to edit my fields, only to find out that I didnt set a PK on one of my tables and you mentioned it at the end of this video. You saved me hours of frustration. Thank you boss!
Thanks Shane for the great video! You made it fun and easy to learn. One thing to point out though, in your video at 23:30 when you execute the query again, your query wasn't actually showing the MyID column as you said. In order to see that new identity column, you'll either need to regenerate the select query from the table or add the MyID column to that existing query.
Thanks
It's 2021 - And this is the best video I have seen for Primary key. You could rebrand/rename this video for "SQL set primary key - tutorial"
Thank you Don. 😎
Hi mate.
Fantastic tutorial!
I like how you go straight to the point, no tech talk...
Thanks for taking the time to do this.
Glad to help. 😀
Hello Shane,
Thank you for all these video lessons. Sharing all this knowledge with us it is a philanthropic act. I want to let you know that I'd like to see more videos about "PowerApps and Azure SQL Databases".
Thanks and noted. 😎
OMG Shane! your PRO TIP saved me!! The edit form appeared after adding the primary key. Thank you!!!!!
Glad it helped!
You REALLY saved my bacon re: that Primary Key - THANKS!!!!
Awesome 😎
Thanks for the video. Watched and created first Azure SQL instance. Got it connected to Powerapps as replacement for Sharepoint List.
Awesome!
Shane Thanks, this video goes right to the point of what I was looking for.
Awesome. 😀
Nouuu, the primary key .... Many thanks for the TIP !!!
You bet!
Great vid!!
As a non sql users that was very clear explanation.
Thanks a lot!!
Awesome. Thanks
Crazy weird you don't have a zillion subscribers. Your videos are outstanding.
Appreciate that Rick :)
Nice tip about plus button not visible in powerapps.
Thanks for all your videos.
Glad to help. 😀
Another great vid. Helped me sus out connecting canvas app to Azure SQL. Thanks
Glad it helped!
Just awesome Shane! Really easy to follow. Thanks.
Glad to help. 😀
Beautifully explained
Thanks 😊
Another great video Shane. Really liked how you stepped through every step along the way,
Thank you. I spent a lot of time to try and make it so a non nerd could follow along. 😀 Let me know if you get to put in into practice.
Hi Shane. Thank you for the great video!
My pleasure!
Thank you Shane! It was easy to follow and very informative. You have definitely helped me!
Happy to help
This is it! Just what i needed! Thanks
Awesome. One of my favorite topics for sure.
Excellent work Shane. Thank you very much. Helped me a lot.
Thank you. Glad it helped.
Thanks Shane, great tutorials!
My pleasure!
Great video, Shane. Thanks!
Thanks! I love SQL with PowerApps.
Nice video.
I hope to more movie using the Import Flat file feature of SQL Server Management Studio for simple more 😃😃😃
I need more SQL content for sure.
Awesome, exactly the information I am looking for.
You are welcome. Glad it helped. :)
Great Vid!
One correction - in your query to add a primary key you should replace "PK_TransactionHistoryArchive_TransactionID" with "PK_VideoData_MyID".
Thanks for sharing
It's work perfectly... 👍
Awesome 😎
@@ShanesCows Thanks for your tutorial Shane Young☺👍
Good one
Thanks 😍
Thank you! Excellent video!
You are welcome. Glad it helped. :)
You are always helpful 👍✅
Thanks 🙏
Thank you!!! Thank you so much!!
Glad to help. 😀
Hi Shane,
Thanks for the vids, but could you vary your 'here's our intro' section? I want to watch the next Shane Young video thinking: what's Shane Young going to do this time?
A suggestion: put on a native american headdress?
All the best,
Ricardo
I change the background but maybe I will try something for you. 😎
This was very helpful, Thanks buddy!
😻
Great video. Thank you. Waiting more on this topic!!!! Like how to bring data from two tables!!!!
Thank you. All you need to do is add another connection to the same SQL database and then choose the other table.
This video has an example with Excel and SharePoint. Your steps will be the same but instead choose a SQL connection. ua-cam.com/video/fqH1U0_TanI/v-deo.html
Thanks!!!
Hi man, great video! it helped me a lot. I just want to point out that the code for creating the primary key (22:20) where it says 'PK_TransactionHistoryArchive_TransactionID' it needs to be different every time, I'm not sure why but it may be the name of that primary key so it can't be the same if you have multiple tables. thanks again for this video.
Good point. 😻
What can I say, great video!
Thank you. 😀
In that example you are the administrator of that database. How can other people use the app, adding, eliminating and editing records? Do you manage those permissions from power apps or do you require a special configuration at SQL Managment Service to grant those permissions? Great video as always!
Power Apps uses that one account for the connection to the database. So they are all interacting with the same account. Up to you to manage the app to control what they do.
Thanks Shane for yet another amazing video! just a quick question, do I need to provide access to the SQL db for all my users? I tried doing an app with SQL connection, I can see the data but they cant. Thanks again for your amazing help on the PowerApp community
What did you use for authentication. If you did like in the video then you shouldn't have to share anything else with them.
Hi Shane, if a company has already bought the packet office 365, Do they have to buy pay for build an sql data base or not? Thank you for your videos, you are amazing
YEs, Azure SQL license is not part of Office 365.
Is there currently now way that you can build a connection via Option Azure AD Integrated to connect to an Azure SQL DB in a VNet??
I am not sure... fill out hte contact form at www.PowerApps911.com for free help and ask there. Maybe someone else on the team has done it.
Shane, is there an easy way to connect to SQL Server DB AND specify the tablet layout? It seems like the default is always phone, but I like how it pre-builds the screens for you and it would be good to not have to recreate it manually in the tablet layout having to choose "Start from blank". Thanks!
Nope. App from Data is always mobile. 😑
Hey Shane, great video. Is there a way I can hook up the SQL database to a front end web app in Azure?
Probably Levi but I have never done it, Azure web apps are a little bit outside of what I do.
Shane what is your idea attachment has to save in SQL Table..
Like SharePoint we wud like to use SQL with attached controle ..
Any help please
Don’t. 😀 Use Azure blob storage instead. ua-cam.com/video/wF0MmiaGO_o/v-deo.html
Hey Shane, nice vid man microsoft should get you a medal for all the efort. ¿Is it posible to teach us to join this table with a Sequence? This is one of the main reasons im migrating from excel to sql.
Thanks again
Joins are tough. Look at the in operator.
@@ShanesCows looking good !! Thanks man I owe you a beer
Great Azure SQL Database tutorial Shane! Much appreciated!! Once an application is created, how are others allowed to access the SQL Database? Are apps built using an application ID that has RW but not admin? Or does each user need to have an Azure/SQL License?
You can create Users in the database. No licenses needed.
Hi Shane, Great video about Azure.. I regularly watch your video about Power Apps.. I am learning to build Power Apps & even more interesting to more about Azure SQL end2end.. If you can suggest good UA-cam channel would be a great help. Thanks😊
Thank you for the Kudos and for watching. Sadly, I don't have any other suggestions for you unless you haven't found my Azure videos yet. :) They aren't a lot of them but they can help.
Shane Young.. Thanks for the prompt response.. I did go through few channels however I didn't like it. I will keep looking for something better.. 😊
Shane thanks!!
Happy to help
I figured out a work around for that problem.
Glad you got it.
Shane, another great video. Can you point to one of your videos where you do image capture and storing to sql server and pulling them back? Thank you much in advance.
I don't have one. :( SQL is terrible at image storage in my experience.
Better use Azure blob storage for storing images and store their name on SQL or any database
Shane - great Video (as always)!
Quick question. Why is CDS better than SQL? Currently using SharePoint lists with my first app but I’m currently evaluating data solutions for the next version of our internal business app. As a data analyst I’m naturally drawn to SQL but I don’t want to overlook the better solution.
Hi Shane. Great video thanks. I want to give users access to a power app that will be used to enter data into an azure sql database. However, I don’t want to give them write access to the database. Is there anyway of using a service account? I don’t want users to be able to reuse the connection in their own power apps. Thanks again
This video will help. Just ignore where I talk about P1 and P2. Those are old concepts but Environemnts will help studio.ua-cam.com/users/videoNqQGysNCac0/edit
Thank you Shane. One question: Does using an SQLdB on the back end help allow for many to many relationships or join tables? My understanding is that PowerApps simply can't work with those kinds of relationships and that may be an issue for my project. Thanks in advance for your response!
One to many or many to many relationships is all about you connecting the dots with a key. PowerApps doesn’t care. 😀 in my repeating tables like InfoPath I show 1 to many with SharePoint.
Hi Shane nice work, I have a doubt about Azure. I exported to Azure Mysql my local DB, after export I try to connect whit azure,but I need use my local gateway because only I can connect whit a SQL server directly, can connect mysql whitout gateway?
I don’t think you can with MySQL
In following your video, when you got to the part about open a hole in the firewall, I hit subset instead of sign in. As a result, I am not able to connect to powerapps. Do you have any idea how I can correct that>
much appreciated!
Happy to help.
Great video Shane, it cleared up a lot of areas that I was wondering about Azure SQL & PowerApps.
Also, I appreciated your comments trying to place Azure SQL in context as a data source to PowerApps roughly between Excel / SharePoint and the Common Data Service (CDS).
One question related to the above idea - Would it be true to say that you would probably only need to connect a PowerApps App to an Azure SQL database if the data was already held in Azure SQL tables already? i.e. wouldn't it be better to create an Entity in CDS to hold the data if you were starting from either scratch or sitting with the Data in Excel?
If you have the license for CDS then yes it is best. If not SQL is next on my list.
Thank you for this Video, I've been watching your other video titled Power Apps Cascading dropdown. I'm wondering if it's possible to create 2 tables in SQL similar to Department and Job title and apply cascading dropdown in powerApps.
Yes. Works exactly the same. 😀 I use SQL for most customer apps.
Thanks by the comment of primary key. I can’t edit the table
Have to have a primary key.
excellent. thank you
Glad to help. 😀
@@ShanesCows I worked for 6 months at a project in Chicago, thanks to your tutorials.. thank you bro
And, I am grateful to you and all the tutors dedicated to educate the rest of us... Thank you very much :)
Hi Shane, thank you for this video, it was excellent! Q: After successfully completed all the steps to create the app with the SQL Server connector, and as it's basically for training purposes, I should delete the app and delete the #Resource Group in Azure to stop billing, correct?
Yup 😀
Thanks for the great demo! Quick question, are we able to connect more than 1 databases or a combination of database and custom on-premise APIs within the Power App?
Yes you can! YOu can have as many data sources as you want.
@@ShanesCows Great, thanks for the reply!
Great video :), powerapps technology is also promising, unfortunately I have a problem with which I have been fighting for several days, maybe you've met with a similar one ???
I have a sql database on MS azure, I added my ip and I can connect from MS SQL Server Management Studio to Auzre, I also have a connection in PowerApps and everything works in design mode, I add eg Data Table, I can see records if I run an application from this level everything is OK. However, if I try to run the application without going into editing (without running the App studio) then the Data Table is empty, no data is available. I have all the environment within my organization, I am the administrator and the owner of the sql database.
Do you have any idea ?
Regards, Roberto
That is odd. Have you tried different browsers? I don’t read anything you are doing wrong.
Fantastic explanation Shane :-) . I have a simple question. Can I use 2 or 3 table within PowerApps?. At the moment I have an app with 3 excel tables and I would like to transfer them into a Database. Can I manage these tables with PowerApps? Thank you in advance and have a great day
Yes you can! I have apps with 20 or 30 tables :)
Thanks for this video! I really can't afford CDS, and I think SQL is a little better than SharePoint as a data source so will be trying this out.
Cool. Enjoy
Hi there - as always Shane you are brilliant and thank you for the video.No comes the question!I am working with an Azure SQL database for an HR app. When creating a new screen you have the option of using a People template, which is great. I am now just having a hassle trying to link back to my SQL table on the Display Name field. Any ideas?Kind regardsCaroline
I haven't used the screen much. When search for the person they are added to a collection called MyPeople. How are you trying to add them to SQL?
Hi shane , Thank you for the nice video ...i have one issue ..i have application where my data source is sql server where i need to auto populate the created by , created date , modified by and modified date into the SQL server table ...please can you help how to do that ..!
Look for my video on audit. Tells you how to do just this. User and now functions are the keys.
Hey Shane, Nice Video, I wonder if there is a posibility to create a PowerApps that be able to update multiple tables? Thanks in advance. Best Regards.
Yes. Look for my video on Patch or SQL Relationships
Great video shane, i was going mad about de PLUS BUTTON, just one thing missing for me. How to manage date fields.
Going with my data to .csv get all my dates to numbers (44523) and importing to sql failed if i change field types to date, so i followed with string as yoir video suggested. But now my powerapp is built, i need to show them as dates, and more important, edit and create new entries with date format.
Do you know how to fix this?
Check out the PowerApps DateValue function for converting the text to a Date while you are in PowerApps.
Shane is there a way to take an existing PowerApp and connect it to a Azure SQL DB?
Yes you can add or remove data sources to any app
Can you perform this action with a dedicated sql pool or does it have to be an azure sql db?
To add to this, I added the primary key and I get a bad gateway error, but I didn’t think the cloud had a gateway. Thoughts?
I haven't tried so I am not sure Shelly. I wish I had a better answer than I don't know but I don't. Boo me.
As always Shane, your knowledge astounds me. Silly question, I've created a rather large digital process, with lots of tables and apps and cool fun things. I've realised today that I did something so incredibly silly when setting up one of my tables, and included a space between two words (ie, dbo.Participants Combined). Rooky error, I know, but now that I need to do the process you have mentioned in the code above, with the addition of the PK, it keeps identifying a syntax error which I can only presume is because of the space. Any ideas on how to get around it? I thought I would be cheeky and try renaming the table and deleting the space, until I realised I crashed about half a dozen apps and had some rather concerning messages from users. I really really really don't want to have to reconnect everything to a new table just to change the name to be without a space, I have a feeling that workload will be horrendous! Any tips would be so very appreciated, as always!
What is the error you are getting? You should be able to have spaces in table names without issue. You just use single quotes around it.
It keeps coming back with Msg 102, Incorrect syntax. I just cannot see what the issue is. If I get a chance later today I will copy the query into here... clearly I'm missing something!
@@ShanesCows
Fixed it, can't remember how, but it's working now. Thanks as always. I'm now working on the next big bundle of processes, and have created a new table as the source for the information. I tried added this super important query code, but keep getting rejected and told that the section reference PK_Transaction… (that part) already exists in the database and cannot be used. Ideas on what I have stuffed up? I have a lot of tables talking to PowerApps, so need to be able to do this across multiple processes.
Hi Shane, When I am trying to add a new SQL server connection, It shows 'Adding connection' and then 'Something went wrong, Please try again later' message. Can you suggest something to resolve this issue?
Is it Azure SQL? Maybe your it has it blocked?
Hi Shane, can a dynamic connection to a SQL Server database be created? for scenarios where we have a Development database and when we are ready to deploy to Production, we can just update the connection server or database name without having to update the data source in the application, thanks.
Not that I have done. I would guess you have to write a bunch of If formulas
@@ShanesCows Okay, Thanks for replying back.
Shane - love your vids and you make it so much easier to pick these new things up, and coming from a dotNet world that's a refreshing change! Can I ask you for your opinion of using Powerapps/Flow/Azure Sql for a fully loaded data-driven web solution and how does the licence work if you want outside users to log in using security within our Sql Db i.e. not MS sign-ins - is that the portal licence (at $100 i think)?
There is a Portal license but Portal only works with CDS. I honestlly don't think POwer Apps is ideal for a public facing solution today. 😐
I used SQL server 2019 and got stuck @ 25:05, the setup
process doesn't seem to be the same please help.
Thanks for the great videos Shane, you help lots of us.
What error are you getting when connecting?
nice video. How to put a where condition?
Use the Filter function. Filter(table, column = “value) as an example
Hey Shane, When I try to add import a second table into SSMS I get the following error when I try to make a primary key using the script on the second table.
Msg 2714, Level 16, State 5, Line 2
There is already an object named 'PK_TransactionHistoryArchive_TransactionID' in the database.
Msg 1750, Level 16, State 1, Line 2
Could not create constraint or index. See previous errors.
Just edited the SQL Query as such and it worked ua-cam.com/video/1pOlNR-Zqdk/v-deo.html
Glad you got it.
Hi Shane, Is there any way we can create canvas app using azure SQL database without having premium connector?
Nope. If you use SQL as a data source you need a premium license.
@@ShanesCows thankyou for replying back, shane, could not possible with custom connectors also? If we have 1000+ users, how to manage licenses as it would be huge amount, and we are going to build 10+ apps ,
Can't pull in SharePoint from SQL as we have lots of records there.
Any idea you can suggest please.
Also just to know custom connectors can be used with premium license only?
@@ShanesCows btw thankyou shane, I started learning powerapps using your videos, Keep positing :)
is there to add/create multiple tables inside the SQL management app ?
Yes. You can write a query that creates everything at once.
Is there a way to automate the CSV file import using Powerapps?
I would look ok to Flow for automating data.
Hello Shane, thank you for the video it's extremely helpful !
I'm hoping you could help me with something, I was wondering how we can reuse the formula below which you nicely pasted for us. I want to import many tables and have a primary key for all of them - I tried to duplicate what I learnt in this video however I get a error :(.
alter table dbo.data Add MyID int IDENTITY (1,1) NOT NULL,
CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (MyID)
Are you getting an error?
Shane, I was wrong. I got the procedure correct, but it continues to give me an error message saying that I don’t have the correct authentication.
What part is giving you the error?
Shane Young
Shane,
I receive the authentication error when I try to log into the SQL connection. It is at 24:50 or so on the video. I have Azure account and database set up per the video, but when I try to log in it does not recognize me.
I appreciate your time and if you think it will help, I am happy to buy some time through Powerapps 911.
Best,
Frank
Hi Shane, does my VM need to be a Windows Server before installing, SQL server managament studii 2017?
No. I installed SSMS (management studio) on my Windows 10 desktop.
Hi Shane. Also this can be a good option if you don't need all feature of SQL Server Management Studio, but just query etc.: docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-2017
Cool. Thanks for sharing.
I love your videos, but Bing??? 😂
I have been a Bing user for as long as I can remember. Maybe too much Microsoft Kool-Aid? 🤪
I couldn't get that syntax to work...had to do with the clustered primary key
this is what worked for me
CREATE TABLE [dbo].[POA_SS](
[Stopword] [nvarchar](150) NULL,
[Timestamp] [nvarchar](17) NULL,
[Created by] [nvarchar](150) NULL)
alter table dbo.POA_SS Add MyID int IDENTITY (1,1) NOT NULL,
CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY NONCLUSTERED (MyID) NOT ENFORCED
Thanks for sharing and glad you got it figured out.
Hi Shane, is it possible to build an approval process with Azure SQL and PowerApps setup with Microsoft Flow? If yes, what will be the trigger action for MS Flow?
Yes. I have done about 5 of these for customers. You can have PowerApps trigger the flow when the user submits the data. Patch(...);Flow.run(...)
@@ShanesCows thank you!
Azure is incredibly expensive.
$15 a month for a database is the best deal ever. Sorry you aren’t happy with it.
@@ShanesCows Our first bill for one database with ten records and two users was $285.00. I wish I could find the $15.00 version!
Are you kidding me!! $40 pr user/month.. We ar 600 users. thats $24K / month :-D ridiculous..
Sorry I don’t control the licensing or pricing. 😞
too much talk, no project , no hands on , simple demo is useless, there are hundred of video to demo the basics and concept . you have to have real world work experience to do a real project demo
Sorry it wasn't what you were looking for, but a lot of people have found it helpful for the intro they wanted and needed to get started. There is plenty of more advanced content in my library or others.