Solving Real World Scenarios with Microsoft PowerApps

This is an alternative approach to solve the problem described in my blog post here:

This time I’m using PowerApps to „win“ the challenge. All of this is done in three easy steps:

Step 1:

For testing purposes, it is enough to sign up for a free plan here:

Step 2:

Then you need to set up a custom connector in PowerApps. I found the wizard very easy to use and after some trial and error I ended up with a working solution:

Step 3:

Last thing to do is setting up a new Canvas app. For my test I only needed a TextInput control to insert the VAT Number, a Button to call the api and a Gallery to show the results. Basically, all of this is up and running with only one single line of code:


If have to say I’m once again very impressed how easy it is to work with PowerApps. I was able to integrate an api service, create a custom connector and build a running demo solution in about 1 h. I must admit I found this article very helpful:

From here of course I will go on and enhance my little program. For example, I will store the results of the check in the SQL database. And if the check is returning false there should be another button to send an e-mail to my client asking for the correct VAT no. Or send a notification to someone responsible within my company.

Links, Links, Links

Man möchte eigentlich meinen, in der Sommerzeit hat man mehr Zeit zum Lesen interessanter Beiträge. Bei mir ist es genau umgekehrt, da ich mich in dieser Jahreszeit gerne und viel an der frischen Luft bewege. Trotzdem habe ich mal wieder einige interessante Beiträge zusammen getragen. Ein bunter Reigen, der zeigt, was mich so alles interessiert…

Read and Write Excel files in real-time with R in SQL Server 2017

Power BI Regression Report



PowerApps progress bar

Using Azure Functions in PowerApps

SQL table to HTML


xRMVirtual User Group

Need Icons?

Microsoft Flow blog

Developing Business Applications with Power Apps and Microsoft Flow

Short recap of the edX course Developing Business Applications with Power Apps and Microsoft Flow

The good:

The course was a great starting point for me. The video tutorials are short but nevertheless full of information. I also found the labs interesting and fun.

The bad:

The course is outdated regarding user interface and especially the parts dealing with CDS (old version 1.0 in tutorial).