Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How to use Power Apps with Azure SQL Server

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →

How to use Power Apps with Azure SQL Server

Aroh Shukla

January 29, 2020

Transcript

13 slides
  1. 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
  2. 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
  3. 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
  4. 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
  5. 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 )
  6. Problem: Populating Drop Down Boxes Azure SQL Database • Need

    to deal with database referential integrity • Need to deal with foreign keys
  7. 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

More Decks by Aroh Shukla

Other Decks in Technology