Was für die Feiertage…
Schlagwort-Archive: Microsoft Flow
Solving Real World Scenarios with the Microsoft Power Platform
Time to play with dataflows. I have the following situation. For transactions in foreign currencies I need accurate fx rates. Can a dataflow solve this requirement?
First thing I did was to subscribe for a free plan here:
Then in Power BI service I created my very first dataflow. Basically the flow consists of one simple api call (well described on the fixer page):
And with some basic steps in the Power Query editor I ended up with this:
Now I can link every transaction in foreign currency to my central fx rates table. This is great but there was one important thing missing. I couldn’t figure out a way to store the results like it is possible with the streaming dataset feature.
So I was searching for an alternative solution. Why not use CDS for application to store the data? And then point the Power BI dataflow to the CDS entity:
I created a new entity as I could not find an existing one in the standard cds entities:
Afterwards I created a custom connector to the fixer api:
Next thing I needed was a flow to pull the data in my newly created entity:
And last of all I created another dataflow in Power BI pointing to the CDS entity:
Now I have the result I was looking for. A central fx rates table with historical data.
I have to admit figuring out all of this was fun. And best of all I could solve a real business need.
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
API:
https://www.programmableweb.com/api-university/api-developer-training
Using Azure Functions in PowerApps
Dynamics 365 – Real world examples and tutorials
Apart from the marketing hype it is still surprisingly hard to find real word examples and tips concerning Dynamics 365, PowerApps and Flow. These two sites offer tons of information, great work:
Dynamics 365 – Microsoft Flow – Scheduled Reports
In diesem Beitrag wird beschrieben, wie sich das umsetzen lässt:
Microsoft Flow: Creating Dynamics 365 Scheduled Report – Low Code Approach
Unbedingt auch die im Beitrag erweähnte Seite von https://bguidinger.com/ besuchen
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
PowerApps and Flow – Learn from the experts
Great video and walk-through showing the capabilities of PowerApps together with Flow:
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:
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.
Und auch hier findet man tolle Beispiele mit Logic Apps:
Microsoft Flow im Echtbetrieb
Leider finde ich immer noch recht wenige Beispiele über den Einsatz von Microsoft Flow im Echteinsatz, hier mal ein guter Artikel: