Solving Real World Scenarios with Microsoft Flow – Challenge No. 4

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/

 

 

Designing R chart in #Powerbi just got a lot easier for a R novice

Erik Svensen - Blog about Power BI, Power Apps, Power Query

I have for a long time had the wish to use the power of R to create some fancy visuals in PowerBI, but I simply haven’t had the time to read the manual 🙂

Then today I saw a retweet about how to make ggplot2 easily –


And thought that might be able to help me get started – AND IT SURE DID

The tools are still under development so expect a few bumps

First – RStudio

You need to install RStudio on your computer to support the Addin. So if you haven’t done so already – go to https://www.rstudio.com/

To install the addin you can follow the instructions on the github site for the addin – https://github.com/dreamRs/esquisse

Simply insert this in code window and run it

R-Studio will then install the addin and all its help files etc.

Now we can run the addin by running this line

esquisse

Ursprünglichen Post anzeigen 401 weitere Wörter

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).