Using SQL Server & Power Apps

Опубликовано: 23 Ноябрь 2024
на канале: PowerApps Tutorial
16,242
169

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!