Creating a Power App from existing SQL Server Table data
The majority of the time we create the Power Apps from scratch but if we have a data structure that already exists and need a robust and flexible application to handle it. For these situations, there are some ready-to-use procedures in the Microsoft ecosystem that allow the creation of applications from a particular set of data. so in this article, we’ll create a Canvas App from an already provisioned Azure SQL database table.
To provision Azure SQL Database single database please follow this link
Step 1 - Login to the Azure portal, https://portal.azure.com, and from the main search, create a SQL Server database server & SQL database.
Step 2- If you don’t have SQL client installed at your machine, then connect this with Visual Studio.
Step 3- Open a Data explorer and create a table.
Step 4 - Populate sample data in to table
Step 5 - Open the make portal https://make.powerapps.com/ and select the environment and create an app from SQL template “Start from a SQL data source to create a three-screen - app.
Step 6- Add SQL Connectors and select the table "Employee"
Step 6 - Connect the table, this will automatically generate the three-screen power apps from the SQL table data and list the details. Hit the play button.
List Screen -