How to use Power Apps with Azure SQL Server

Transcript

1. How to use Power Apps with Azure SQL Sever Aroh Shukla
2. 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
3. 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
4. Introduction to Power Platform
5. 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
6. 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
7. 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 )
8. DEMO – 1 Setting up Azure SQL Sever
9. Design: Using Start with Data Wizard
10. DEMO – 2 Power Apps with Azure SQL Data
11. Problem: Populating Drop Down Boxes Azure SQL Database • Need to deal with database referential integrity • Need to deal with foreign keys
12. 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
13. Gracias Merci