Power Platform & Azure – Better Together: Build Power Apps from Azure SQL

Power Platform and Azure connected together is such a powerful story of “Powerful alone, but better together”. When connected to Azure, Microsoft Power Platform enables you to quickly deliver value and build Enterprise solutions.

We always had the capability in App maker experience to connect to Azure SQL and build applications that interact or use data from Azure SQL using SQL connectors.

With the new Feature announced now, You can initiate/Build a Power Platform application using Azure SQL from within Azure Portal.

In this blog, we will look into how Azure SQL and PowerPlatform can be connected together.

What you need:

  • Azure SQL Database
  • Server firewall on database to enable Azure server and Power Platform services  to access the database

How to set it up:

    • Navigate to Azure SQL instance in Azure Portal
    • Select the database you want to build on using Power Platform
    • Click on the Power Platform application you want to build from the left sidebar

Power Apps:

  • Upon clicking on Power Apps, you would be presented with page to get Started, it will also provide learn resources.
  • Upon click of get started you will be presented with page to provide details for App you want to create and table you wish to use.

 

Upon Click of create you would be redirected to Power Apps studio with continue building Power Apps.

Power Automate:

Upon clicking on Power Automate, you would be presented with page with some of most popular SQL server templates

Clicking on them will present you with details on scenario and option to try it. If you choose to try, it will redirect to Power Automate studio to continue building.

Power BI:

Upon clicking on Power BI, you are presented with page to get started.

Clicking on get started will download the pbids file, which you can open in Power BI desktop and continue building on the sql database.

There are a lot of new features which enables Power Platform and Azure to work together, to find more check the blogs by following the tag #PowerfulAloneBetterTogether

Power Platform & Azure – Better Together: Azure APIM Connector

Power Platform and Azure connected together is such a powerful story of “Powerful alone, but better together”. In this blog, we will look into how Azure APIM and PowerPlatform can be connected together.

Power Platform and Azure connected together is such a powerful story of “Powerful alone, but better together”. When connected to Azure, Microsoft Power Platform enables you to quickly deliver value and build Enterprise solutions.

In this blog, we will look into how Azure APIM and PowerPlatform can be connected together.

Azure APIM:  Digital transformation runs of APIs ( application programming interface).  Api’s are abstractions, they allow you to decouple consumption and implementation based on standards which allow them to be available to work with any platform and any applications.`

Anyone can build api and publish them, but building api and running it as a strategic business is another thing. This is where APIM provides value, Azure API management provides a gateway for api using which organizations publish APIs to external, partner, and internal developers to leverage them and access different data and services. 

Continue reading “Power Platform & Azure – Better Together: Azure APIM Connector”

Logic App Definition Parameter Vs ARM Parameters – ALM Part 3

In the previous blog – we looked into getting Logic Apps CI/CD using ARM Template Parameter, we briefly touched on logic app definition parameter. In this post, we will look further into using Logic app definition parameter as an intermediary and the benefits of doing so.

Comparison:

ARM Parameters Logic App definition Parameters
Used with ARM Template Used within a Logic App
Value evaluated during Deployment Value evaluated during Runtime
Syntax: “uri” : “[parameters(‘vsts_bug_url’)” Syntax:  “uri”: “@parameters(‘url’)”
Not referenced post-deployment Available in Code view and Designer view
Suited for Environment Specific values Suited for Reference objects

so the obvious question is how we can leverage Logic App parameters as an intermediary and why to do so?

Continue reading “Logic App Definition Parameter Vs ARM Parameters – ALM Part 3”