Using SQL Server & Power Apps

Use a Azure SQL Server database for your Power Apps application! We'll step through how to do this here!

➡️ Get access to our free Power Apps crash course (and our community) here: https://go.superpowerlabs.co/superlan...

Here are the topics discussed in this video:
- "Big Boy" database?
- Why SQL Server?
- What's wrong with Dataverse?
- Join tables with view
- Stored procedures (must use Power Automate flows)
- Multiple environments or tenants!
- Data needs to be accessed outside the Power Platform
- You can use Dataverse outside Power Platform
- Why not to use SQL Server?
- Cost
- Dataverse could be faster!
- less API layers!
- you can link other data sources with Dataverse, like SQL Server, SharePoint, Excel, Azure AD, etc.
- Complexity (learning curve)
- Overkill the requirements
- No desire to learn any more coding
- SQL - Structured Query Language
- T-SQL - Transact SQL
- How to set up Azure SQL?
- Creating the database
- Creating our Power Apps application

- Using a sample app use case with Chat GPT:
- Onboarding, Engagement, & Satisfaction!