Blog
SQL - Have you seen these Power Platform options in SQL Azure portal?
January 12. 2021
From the SQL Azure Portal, there is now the option to create a Power App ontop of a SQL Table. Here's a closer look at this feature.
I guess it's well known that from a SharePoint list, a menu item exists that creates an 'auto-generated' Power App that contains browse, display, and edit screens.
Just like the SharePoint counterpart, the 'create' button builds an auto generated app with browse, display, and edit screen. It creates the app in the default environment.
For regular app builders, this feature probably doesn't add much benefit because those users will be familiar with the data connectivity features in Power Apps studio.
But did you know that for SQL Azure, an equivalent set of menu items also appear in the left-hand pane?
These menu items are currently in preview, but we can use these to create a Power App that's based on a SQL Server table that we specify.
Just like the SharePoint counterpart, the 'create' button builds an auto generated app with browse, display, and edit screen. It creates the app in the default environment.
For regular app builders, this feature probably doesn't add much benefit because those users will be familiar with the data connectivity features in Power Apps studio.
However, I do think this is a very positive addition to the SQL Azure portal, because it helps promote Power Apps to a wider demographic, including more traditional database developers who may not have heard of the Power Platform. Hopefully, this will encourage more users to explore and to experience the benefits and productivity of Power Apps and the Power Platform.
- Categories:
- sql server
Related posts
- SQL - Caution! This is how users can hack shared SQL connections
- SQL - How can we count rows accurately?
- SQL Server for Beginners Part 3 - Installing On-Premises Gateway
- SQL Server for Beginners Part 2 - Installing Management Studio
- SQL Server for Beginners Part 1 - Installing SQL Server
- Excel vs SharePoint vs SQL Server vs CDS