In the previous two articles of this blog post series, we have seen how to utilize Azure API Apps to connect to external data sources<\/a>, and how to utilize the same app to extend limited PowerApps expression language with additional value controllers<\/a>.<\/p>\n

But sometimes, if we really want to do something simple, an Azure API App can be an overkill, from development, deployment and management perspective. If we remember that use case from the last post, where our only goal was to check if the beer name contains the word \u201cHeineken\u201d, we obviously don\u2019t need an Azure Api APP for that. It\u2019s just one IF clause, after all. For that, Azure Functions might be a way to go.<\/p>\n

Azure Functions<\/a> are a great vehicle for hosting small, single-tasked pieces of code. Since they run on hamsters, we will call it the \u201cserverless computing\u201d. Basically, you can log in to your Azure portal, or go to functions.azure.com<\/a> and start writing your code in a web editor. There is a number of programing languages, plus JavaScript, available to use. If you are not into web editors for writing code, you can use anything you wish, and store your function code on GitHub or VSTS, with continuous integration. Since recently, there are also Visual Studio Tools for Azure Functions available. Those Visual Studio tools are at the moment still in preview and they they require VS2015 U3 with Azure SDK installed. There are quite some bugs still there, but \u2013 this is only a preview, and it will, probably, get better with the time.<\/p>\n

In this blog post, we\u2019ll make a walk-trough using Visual Studio 2015 Update3 and VS Tools for Azure Functions, to create and deploy a function, and to reuse it in the PowerApp that we have built in the previous two articles.<\/p>\n

So let\u2019s start with creating a Visual Studio project! After installing all the prerequisites, you should have the \u201cAzure Functions (Preview)\u201d project available among the Cloud projects.<\/p>\n

 <\/p>\n

<\/a><\/p>\n

After creating an empty Azure Function project, you\u2019ll need to add a new Azure Function from the \u201cAdd\u201d context menu in the solution explorer:<\/p>\n

 <\/p>\n

<\/a><\/p>\n

The next you will need to choose the programming language, and the function type. I\u2019ll choose C# (there are many other choices), and \u201cHttpTrigger\u201d function trigger. Note that functions can be triggered on many different ways \u2013 we have webhooks, queues,  integration with Azure Service Bus, timers, and many, many other possibilities. In our case, HttpTrigger is what we need.<\/p>\n

Choose the Authorization level. I\u2019ll take \u201cAnonymous\u201d here, for the sake of simplicity. You can of course choose \u201cFunction\u201d, \u201cAdmin\u201d, and provide function or master admin keys which you can create in Azure Portal (later about it). Furthermore, since Azure Functions are based on Azure App Service platform, you can also choose some of the supported Authentication mechanisms there, like AAD, Microsoft Account, Facebook etc, which might be a valid scenario when you want to fetch some SharePoint data, but I will cover that in another article, since PowerApps are anyway not (yet) able to pass authentication tokens, and cannot be used for that scenario.<\/p>\n

 <\/p>\n

<\/a><\/p>\n

Once we\u2019re done with that, let\u2019s code our function. We\u2019ll make the same use case as in the last article \u2013 check if the name parameter (from the request) contains string \u201cHEINEKEN\u201d, and we\u2019ll return our result in the response variable.<\/p>\n

 <\/p>\n

<\/a><\/p>\n

You can build, and publish your function.<\/p>\n

If you go to your Azure portal, and open that same function there, you will se that you can even edit your code manually inside the portal. Be aware that there is no version control, or rolling back of your code there, so whatever you do in the portal will change the previously published function.<\/p>\n

<\/a><\/p>\n

 <\/p>\n

In the \u201cIntegrate\u201d tab, we can change the authorization level here, from Anonymous to Function or Admin.<\/p>\n

 <\/p>\n

<\/a><\/p>\n

If we do, we can get our default keys, or create new ones, in the \u201cManage\u201d tab.<\/p>\n

<\/a><\/p>\n

 <\/p>\n

OK, once we\u2019re done with that, let\u2019s try the function. If we pass the the value \u201cHeineken\u201d to the name parameter in the query string, we see that our function works as expected:<\/p>\n

 <\/p>\n

<\/a><\/p>\n

If we go to the \u201cMonitor\u201d tab of our function, we can see all the details about it\u2019s invocation and results:<\/p>\n

<\/a><\/p>\n

 <\/p>\n

The next we need to do is to create the swagger definition for our function. You remember: PowerApps want swagger. My preferred swagger creation tool (no, I do not like creating it manually) is:<\/p>\n

http:\/\/editor.swagger.io\/<\/a><\/p>\n

You can even try you function there, and everything. My operation is called \u201cRunThis\u201d, this is what I will be calling in PowerApps.<\/p>\n

 <\/p>\n

<\/a><\/p>\n

Pay attention, that if you have used any other authorization than anonymous (Function, Admin), you\u2019ll have to pass another parameter in your GETter  operation:<\/p>\n

{
\n“name”: “code”,
\n“in”: “query”,
\n“description”: “code”,
\n“default”: “[enter function\/admin code]”,
\n“type”: “string”
\n}<\/p>\n

NOTE: I am not a fan of storing keys in the configuration files which are uploaded some management portal. I don\u2019t think that is a good security solution, from all many reasons. One of the major reasons is that a connection created on such a way can be reused by everyone who has rights to create apps in this environment, so that authorization looses its purpose immediately. But, for the moment, its either that, or no authorization at all.<\/strong><\/p>\n

Once we\u2019ve created the swagger definition, let\u2019s upload it to the PowerApps (with or without key), the same way we have uploaded swagger for Web APIs published as Azure API Apps:<\/p>\n

<\/a><\/p>\n

Here we have no other choice but to select \u201cNo Authentication\u201d:<\/p>\n

 <\/p>\n

<\/a><\/p>\n

There is our custom API:<\/p>\n

 <\/p>\n

<\/a><\/p>\n

We can add it as a data source in the PowerApps designer:<\/p>\n

<\/a><\/p>\n

And use it in the PowerApp itself, the same way we have used it for the API Apps:<\/p>\n

UpdateContext({BeerQualityAzureFunction:BeerQualityAzureApp.RunThis<\/span>(txtBeerName.Text)})<\/strong><\/p>\n

With the expected result for the given beer:  <\/p>\n

<\/a><\/p>\n