How to use Power Apps with Azure SQL Sever Aroh Shukla 

About Aroh Microsoft Certificated Trainer | Technical Consultant Experience: Office 365, SharePoint Online, Power BI Office 365 & Power BI Trainer Twitter: @aaroh_bits Blog: aarohblah.blogspot.com 

Agenda • Introduction to Power Platform • Setting up Azure SQL Server for demo • Power Apps with data from AZ SQL Server • Basic Power Apps • Foreign Key Constraint in Power Apps • Demos 

Introduction to Power Platform 

Building PowerApps Connect to data & systems you’re already using easily Create apps, forms, and workflows without writing code Use apps on any device – both web and mobile Canvas Apps help business-power-users to create and use custom business apps across platforms using Excel and PowerPoint skills 

Cloud and on-premises connectivity ▪ Built-in connectivity to 200+ cloud services, files, databases, web APIs, etc. ▪ Seamless hybrid connectivity to on- premises systems via the On- Premises Data Gateway ▪ Build custom connectors for everyone to leverage 

Business Requirements ▪ Contoso Purchased Microsoft 365 subscription and has corporate Data on Azure SQL Server ▪ Problem Statement ▪ Staff needs to access the data using their mobile devices ▪ They should be able to perform in a quick UI for ▪ Creation ▪ Reading ▪ Updating ▪ Deleting (CRUD ) 

DEMO – 1 Setting up Azure SQL Sever 

Design: Using Start with Data Wizard 

DEMO – 2 Power Apps with Azure SQL Data 

Problem: Populating Drop Down Boxes Azure SQL Database • Need to deal with database referential integrity • Need to deal with foreign keys 

Design: Power Apps functions ShowColumn function ShowColumns(Table, ColumnName1 [, ColumnName2, ... ] ) ShowColumns(Customer, CustomerName, CustomerID) Lookup function Lookup(Table, ColumnName=“Value”) Lookup(Customer, CustomerID=ThisItem.CustomerID, CustomerName Note: Lookup function joins data to show a value based on a key 

Gracias Merci