Build a SQL Server App in Power Apps

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

🤝 Need to get some help with your project? Join our community here:
🔗 https://tinyurl.com/PowerPlatformCommunity or, if you want to work with Darren directly, book Call Here📲 https://superpowerlabs.store/powerapps-mastery

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!