Solving Real World Scenarios with Microsoft Flow

This is my first post in English. The reason is I’m using an API named EU VAT API provided by chema.

Up to now for me Microsoft Flow was just one new hot thing offered by Microsoft. But this article has inspired me to challenge Flow with a real-world requirement.

One common task in Europe is to check the VAT Registration Number of a given company. You will find many solutions if you search the Internet. I myself have implemented solutions in VBA, SSIS and so on.

But can this be done in Microsoft Flow? The short answer is Yes. To be honest if you use the api provided by chema it is surprisingly easy after all. Here is my demo solution:

+ In Flow my starting trigger is “When a new email arrives”:

+ I’m checking if the body of the mail contains the phrase “*VAT*”:

vat1

+ If so I’m calling the API where subject is the address of the API + the subject of the mail received which in fact is the VAT Reg. No. to check:

vat3

In the last step the result of the API call is returned to the sender

vat4

+ The first mail looks like this:

vat5

+ And the return mail I receive almost immediately goes like this:

vat6

The flow in the result window looks like this:

vat7

 

No this was really very simple and absolutely no coding required. Challenge No. 1 won by Microsoft Flow…

Schreibe einen Kommentar

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s