Advanced | Flow of The Week: Convert Office documents to PDF on the fly using Microsoft Flow

Imagine a company where service technicians perform on-site repair of equipment. Inevitably, in doing this sort of work, the technician will need to refer to equipment drawings, service history, past photos, specifications and/or operating manuals. These days PowerApps is fast-becoming a great option for such a scenario because many field workers prefer to use their phone or a tablet. But PowerApps also has some limitations, and right now that is around the display of documents from SharePoint. For a start, it is impossible to display office documents natively in PowerApps at this time, and there are authentication-related issues in certain circumstances when pulling content from SharePoint. But fear not… with a 6-step flow, it is possible to solve this problem. This flow allows a remote user to securely request a document from SharePoint, but importantly, converts that document to a PDF on the fly. There are two big benefits from this: 1. A reduction in time and effort for document controllers. If a document frequently changes, it is most likely in word, excel or PowerPoint format. They do not have to worry about converting it to PDF. 2. It allows the document to be viewed in PowerApps natively (As a result of #2, on top of some Flow kung-fu, we will learn some PowerApp tricks in this article too :-).

» Read more

Advanced | Flow of the Week: Creating an AtBot ChatBot connected to Dynamics 365

Creating Bots that integrate with Dynamics 365 has not been the easiest thing to do in the past for non-developers because it has required a lot of coding to be done, and also in order to change the conversation flows you needed to update and redeploy the code for the Bot to make it available to the users. Recently I was introduced to a partner solution called AtBot that allows us to create Bot services through the AtBot portal that links to LUIS and Azure Bot Services, allowing us to build conversation flows and dialogs using Flow as the authoring engine. This allows us to build Bots with zero coding experience that also leverages the power of Flow to connect to other services seamlessly, allowing us to integrate Dynamics 365 using the standard entities. In this walkthough we will show you how to configure and build an AtBot Bot that connects to Dynamics 365, using LUIS as the engine for discoving the users intent and deploy it out to chat platforms like Microsoft Teams. This is gold I tell you, gold!

» Read more

Advanced | Flow of The Week: Retrieving Office 365 Message Center and Service Health Notices using Microsoft Flow

To automate critical business processes in Office 365 using Microsoft Flow, we typically need to call cloud-based services in order to retrieve data. Calling these services often requires us to use the HTTP connector and action, and as a result, provide our TenantID, along with an App’s ClientID and SecretID in the Flow. This blog post will provide a detailed walkthrough of configuring these required parameters when calling cloud services using the HTTP connector. We’ll use a recently released Flow template as an example, which retrieves data from the Office 365 Message Center and Service Health dashboards.

» Read more

Advanced | Flow of The Week: Advanced Approval Write back

A robust, Client-specific approval workflow and write-back engine is not a standard feature of many ERP systems, which requires BI architects and data engineers to think outside the box to deliver scalable solutions. Microsoft Flow can meet these enterprise level requirements, and can do it at a fraction of the time and cost of any other solution on the market. This article will tackle the current business requirements pertaining to enterprise level solutions around on-premise SQL data warehouse write-backss, robust tiered approval cycles, and sales order approval requests. Come and Learn how to build a system like this using Flow from Community Member Phillip Guglielmi

» Read more

Beginner | Flow of The Week: An Introduction to Microsoft Flow

Microsoft Flow Introduction - This is a 100 level introduction to The Microsoft Flow website, learning materials, and ways to find help. Share this video with coworkers and friends that you think could benefit from Flow as a great 1st step for them to understand the ecosystem and tools! Also, this post will be a great spot to ask those entry level questions relating to the Microsoft Flow Intro.

» Read more