Microsoft Flow has become a tool for daily business for me. Although I’m doing a lot of database related stuff still with SSIS I like to use flow whenever possible. This time I did the following:

+ Watch an ftp folder for new files arriving

+ Parse XML file content into variables

+ Send an e-mail with the result of the XML file to the customer

What really surprised me was the fact that in this special case it was much easier to do this in Flow rather than in SSIS.  For example SSIS is not natively supporting ftps. In flow it is as easy as this:

What I also liked is the fact I could do my work without having to touch the customers server. The final solution looks pretty an lightweight:

The ideas for achieving this I got from this two resources:

http://buildsharepointconcepts.blogspot.com/2018/05/parse-xml-using-microsoft-flow.html

https://baizini-it.com/blog/index.php/2017/12/07/microsoft-flow-uploading-daily-foreign-exchange-rates-from-the-european-central-bank/