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/

 

 

PowerApps and Flow – Learn from the experts

Great video and walk-through showing the capabilities of PowerApps together with Flow:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/help-desk-install?utm_source=twitter&utm_source=t.co&utm_medium=doc&utm_medium=referral&utm_campaign=2018_04_19

Another great article here shows how to generate pdf documents:

http://johnliu.net/blog/2017/10/generate-any-pdf-documents-from-html-with-flow

 

Lesestoff für kalte Winterabende

Mal wieder etwas Lesefutter, hat sich in letzter Zeit bei mir so angesammelt:

Microsoft Flow – Laufende Summe über einen Wert bilden:

https://flow.microsoft.com/en-us/blog/calculate-running-totals-and-tracking-maximum-values-in-flow/

Power BI Blog mit technisch anspruchsvollen Artikeln:

https://www.poweredsolutions.co/2018/01/12/power-bi-custom-connector-languages/

Power BI / Excel BI exam scheinen  nun offiziell verfügbar zu sein (vorher beta):

https://www.microsoft.com/en-us/learning/exam-70-778.aspx

https://www.microsoft.com/en-us/learning/exam-70-779.aspx

Power BI decision tree:

https://www.mssqltips.com/sqlservertip/5249/data-exploration-drill-down-and-analysis-using-decomposition-tree-in-power-bi-desktop/

Microsoft Dynamics NAV 2018 New features:

http://www.dynamics-consultants.co.uk/blog/microsoft-dynamics-nav-2018-new-features

Und noch was zum Anschauen

Microsoft Integration Tools

Das ist ein Blog vollgepackt mit Ideen und Praxisbeispielen zu Microsoft Integrationsprojekten, viele Infos über Logic Apps, Azure functions etc.

http://microsoftintegration.guru/blog/

Auch hier gibt es „tons of“ Infos zu Logic Apps usw.

https://www.codit.eu/blog/

Und auch hier findet man tolle Beispiele mit Logic Apps:

http://www.tech-findings.com/2017/06/Inserting-data-in-On-Premises-SQL-Database-using-Logic-Apps.html

 

 

Links und Lesestoff für laue Sommerabende

Es gäbe so viele interessante Berichte, die ich gerne studieren würde. Nur leider fehlt mir im Moment komplett die Zeit. Hier eine kleine Auswahl der Artikel, die ich mir vorgemerkt habe. Hoffe, dass ich das in den paar Tagen Urlaub, die mir bevorstehen, nachholen kann :

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-create-server

http://www.talavant.com/blog/2016/12/12/ssis-data-streaming-destination-to-powerbi

https://powerusers.microsoft.com/t5/Connecting-To-Data/Execute-Stored-procedure-with-On-Premises-Gateway-server/m-p/9429#M630

https://parserr.com/

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-and-Microsoft-Flow-Monitoring-your-data/m-p/203049

https://dhexcel1.wordpress.com/2017/07/20/excel-super-links-103-shared-by-david-hager/

https://azure.microsoft.com/en-us/blog/super-charge-power-bi-with-azure-analysis-services/?utm_content=bufferfa2d5&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

Exporting Power Query tables to SQL Server

http://johnliu.net/blog/2017/7/building-non-json-webservices-with-flow