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!