Posts

Approval and auto escalation with time out in Microsoft Flow

Image
Let's see how to create an Approval workflow with timeout and escalation. I have used Office 365 Custom List "item created or modified" as my trigger. Create "Supervisor Approval" Create "Escalation Approval" Specify duration in ISO 8601 format. refer here for more time-out formatting. "Escalation Approval" would trigger only after the "Supervisor Approval timeout" Final Flow -Ratsub

Cognitive reports in Power BI with R-script

Image
As a continuation of my previous  Sentiment & Phrase analysis using Cognitive Services via MSFlow  will see the report creation part in PowerBI with r-script analytical capability. About PowerBI Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports. - PowerBI About R-Script R is a free software environment for statistical computing and graphics. R is an integrated suite of software facilities for data manipulation, calculation and graphical display. - R-project Let get started, Open PowerBI  Now, design the form based on your requirement.  Then, add master lookup filter "Product Name" Configure it further Adding Measure a.k.a DAX To know more about measures and Data Analysis Expressions Now, let's break down custome

Sentiment & Phrase analysis using Cognitive Services via MSFlow

Image
In this  digital transformation  era i mplementing AI and Cognitive services into any of our service and application where ever possible plays one of crucial role improving end-user/customer/business decision and overall experience. Let's us see a scenario for Ratsub Tech (A Fictional company) is B2B & B2C e-commerce retailer who is interested to understand "UserVoice" e-Mail by tracking its mailbox to understand user experience/sentiment towards their purchases. Create a form to capture User recent purchase and provide a placeholder to fill their thoughts or you can also use adaptive forms will see about this later. At this point assume there is an interface for end-user to fill and send back there 'UserVoice'.  Setup an e-Mail rule and move these emails(i.e. To:uservoice@ratsubtech.com) to "Support" folder. //Sample e-mail template for this usecase From: rathanavel@live.in To: uservoice@ratsubtech.com Subject: CustomerID^639~Product

Upload file to SharePoint using MS Flow endpoint

Image
In my previous article we saw  how to Upload attachment to SharePoint list item using Microsoft Flow , as  a continuation will upload attachment using JavaScript(ajax) with MSFlow endpoint. First, Open your flow and copy the endpoint url from 'HTTP request trigger'. Append listname & itemid  in the URL Finally, Test it Detailed steps Trigger MSFlow to upload document using ajax Check out previous  series  for reference.  I recommend reading the  PowerApps scratch development series ,  Azure Function integration with PowerApps  and  What is Microsoft Flow . -Ratsub

Create Text Analysis Microsoft Cognitive service API in Azure

Image
"Text Analysis" is one of the Microsoft Cognitive Services offering on Azure. Here will see how to create "Text Analysis" services. First, Login in to https://portal.azure.com  and search for Cognitive Services Click "Create cognitive services" and search for "Text Analytics API" Fill the details as below Your endpoint and keys are ready  In upcoming articles will see how to use this on different use cases. -Ratsub

Upload attachment to SharePoint list item using Microsoft Flow

Image
Microsoft Flow is one of the Microsoft offerings for automation. In this series will see how to upload a file to SharePoint ListItem using MSFlow Workflow for our scenario Login to Microsoft Flow site  and log in to create a new flow. Add action and Type 'Data Operations' connector. Then choose 'Data operations - Compose' action Select 'Expression' tab and enter the following to create 'ListName' variable Repeat this process for all other variables  ListName - SharePoint list name. ItemID     - SPList item ID. AttachmentContent - Actual attachment content. FileName - Attchment name. Expressions: we can read values from Query String will discuss how to pass them next article. ListName: trigger() [ 'outputs' ][ 'queries' ][ 'listname' ] ItemID: trigger() [ 'outputs' ][ 'queries' ][ 'itemid' ] At