Learn how Microsoft flow can make your life easy–A free learning event

Dear Friends,

With the aim of learning and sharing, Indiandotnet group & Indore Software Development Community brining a new event for you.

This event will help you and your client to improve the productivity and automate your day to day work.

Please, feel free to register the event using URL http://bit.ly/2GaxIxZ

My Post (1)

We are very thankful to our venue partner Sky Space co-working https://www.skyspaceoffices.com/ for providing the venue.

Logo Color Light - dark bg

Your Benefits

1. Free skill development

2. Meet talented like minded people and increase radius of your circle

3.Grab the opportunities of job and know latest trend

I hope you will join and grab this opportunity.

Indian Prime Minister 2019 Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live

This is currently, the hot topic in India who will win the 2019 election of India and become Prime Minister. Although, 90% of people know who will come again Smile.

This subject gave me an opportunity to use my favorite tools Microsoft Flow, Power BI, and Microsoft Form.

Our aim is here to create a flow which is responsible for capturing the response from Microsoft Form and send it to Power BI stream dataset.

Or we can say the give live stream response of Microsoft form using Microsoft Flow to Power BI and show live trend dashboard by passing stream data to Power BI.

Isn’t it interesting?

I am so excited So, let’s get started.

Prerequisites: Surely, you need the following the account to work further

1. Microsoft flow:  You need Microsoft Flow account for this you can use http://flow.microsoft.com/ to create an account.

2. Microsoft Power BI: You need Microsoft Power BI account for this you can use  http://app.powerbi.com/ to create an account.

3. Microsoft Form:  You need Microsoft Form account for this you can use https://forms.office.com/ to create an account.

 

Indiandotnet_Microsoft_Form_1

All good now you have all the required tools.

The first step here is to create a form so, just log in to Microsoft Survey form and create a sample Survey form as shown in below figure.

Indiandotnet_Microsoft_Fom_2

Great, so we have created our Microsoft Survey form which you can access via the link

Indiandotnet_Microsoft_Form_3

Here, as mentioned in the image make sure you click “Anyone with the Link can respond” to make it publicly available.

Great, so far so good we have created our first step.

Now, Move to Microsoft Flow and after login, create a New button and choose to create blank flow.

Indiandotnet_Microsoft_form_flow_4

In the next step search Microsoft Flow as shown in below figure. We want to collect the response. So, whenever a new response is submitted our flow with the trigger.

Indiandotnet_Microsoft_Form_Flow_5

Now, when you click on “When a new response is Submitted”option (if you are already login into Microsoft form) it will show all the forms which you have created.

As shown in the figure, we are selecting “Indiandotnet- Prime Minister 2019 of India”

Indiandotnet_Microsoft_Form_Flow_6

Here, as we know there can be a bunch of response submitted using the form.

So, we need to capture each individual response and send to power BI stream database. For this, we will add Apply to Each  option and in that select Get Response detail in the action

Indiandotnet_Microsoft_Form_Flow_8

Now, in the next step we will configure it as shown in the below figure. so we are going to pickup each individual response.

indiandotnet_Microsoft_form_flow12

So, our first step is created.

Now, we need to pass the submitted response to Power BI but before that, we have to create a Streaming dataset as we created in our earlier post as well.

Login to app.powerBI.com and create a stream dataset in your workspace as shown in below figure.

Indiandotnet_Microsoft_Fow_Power_BI_8

After clicking the streaming Dataset as shown in above figure select the API option

Indiandotnet_Microsoft_Flow_Power_BI_9

Now, in the next step, we will define the dataset in which we will have the same fields which we are capturing in the form.

In our example, we captured 2 questions which are

1) your Prime minister

2) your location

Just define the fields as mentioned above. You can see I have created the same as shown in the below figure.

Indiandotnet_Microsoft_Flow_Power_BI_10

Just click on Create button to proceed further

Indiandotnet_Microsoft_Flow_Power_BI_10

Once, you created the dataset in the next step we will create a dashboard. Although, we don’t have any data yet, but can at least define.

Just, create a report by clicking the option as shown in the below figure.

Indiandotnet_Microsoft_Flow_Power_BI_12

When you click, create report option you will get report editor here we are choosing 2 simple graphs

1) Bar Graph  – which will show no of votes for each individual candidate (an option which we gave in the Microsoft form)

2) MAP – from where we got the response across the globe.

Indiandotnet_Microsoft_Flow_Power_BI_13

Now, we are done with the Power BI stream database move back to Microsoft Flow and configure the next step which we left.

Here, we are going to add Add rows to a Power BI dataset as shown in below figure

Indiandotnet_Microsoft_Form_Flow_10

Now, just configure the Power BI as shown

Indiandotnet_Microsoft_Form_Flow_11

so far so good, we are done with our configuration. Just save the Flow and hit test run.

and you will see all steps are clear. Now, check the Power BI dashboard which we have created.

Indiandotnet_Nerdtechies_flow_14

After configuring correctly, just publish the Survey and let the people fill it.

I did the same and shared the survey on Facebook.

Now, let’s move to power bi dashboard and check the graph there.

Wow, we are able to see all the live response.

Indiandotnet_Microsoft_Flow_Power_BI_15

People voted from different locations to their Primary Minister and as you can see Shri Narendra Modi is our favorite and all the people voted for him.

Please, let me know how you like this post.

Enjoy learning & Sharing Microsoft Flow, Microsoft Form & Power BI

 

A humble request to all the readers who are Indian and eligible to vote. Please, do cast your vote. Your vote is very important.

Choose, a capable leader in this election whom you can trust that he can speak your voice logically.

India will progress there is no doubt but choose a leader who will be with India not with terrorist and tukde tukde gange.

JAI HIND

BHARAT MATA KI JAI

MebhiChokiDAR – Tweet sentiment analysis and more using Microsoft flow

Microsoft Flow provides various templates to achieve your goal and Twitter Sentiment analysis is one of them.

In this tutorial we will see how to do sentiment analysis using few clicks and see live graphical representation using Power BI live feed.

As in India currently, #Mebhichokidar has tag is very viral. So,we are using this hashtag to cross check how it is going.

Prerequisites :

There are 3 basic prerequisites to complete this task

1) You should have Microsoft flow account if you don’t have that then you can create via link https://flow.microsoft.com

2) You should have Microsoft Power BI account if you don’t have then you can create via link  https://powerbi.microsoft.com/en-us/

3) You should have  Microsoft Azure Portal account for cognitive services if you don’t have then don’t worry you can create via link https://Portal.azure.com

Once, you have all the 3 accounts available then proceed step by step as suggest below

Step 1:-  Just open the Microsoft flow and select the template “Run Sentiment Analysis on tweets and push Result to a Power BI dataset” as shown in below figure.

Indiandotnet_Twitter_1

Step 2: When you select the option you will find below screen as shown in below

Indiandotnet_Twitter_2

Step 3:-  We have to configure 3 connection as expected  text analytics connection (Azure cognitive service) , Power BI (live dashboard) connection and last but not the least Twitter connection.

Here, As I am using an office 365 common account so my power BI already authenticated using that.

Indiandotnet_Twitter_3

Step 4:- Now,let me connect with My twitter account first. Which can be done by clicking Sign In.  In this you need to authorize the flow to access your twitter account.

Indiandotnet_Twitter_6

Step 5: In the next step you have to define text analysis connection for which you have to first login into Azure and search for cognitive service. If not exists then create  by clicking Add  button

Indiandotnet_Cognitive_Service

When you click add button you will find below link as you can see. Search Text Analytics and select the option highlighted as below

Indiandotnet_Cognitive_Service_2

Provide proper Resource Name and select  pricing tier as per your convenient. I am choosing free tier for this example.

Indiandot_Net_Vision_API_1

Step 6: Once you created the account. You need to copy the Key from Get your Keys option . and copy the Web API option from 2b as shown in below.

Indiandotnet_Cognitive_Service_3

Step 7: So, far so  good , we have created cognitive service and now moving back to Microsoft Flow  and Configure the Text analytics. Give any name in connection name and provide Account key which we copied earlier and also copy the Web API.

Indiandotnet_Twitter_4

Step 8:  Now, we are done with the connection next step is configure the steps. So, when a new tweet is posted we will provide that tweet to our Cognitive service using detect sentiment which will provide  sentiment score. The sentiment score will be given to Power BI.

Indiandotnet_Twitter_8

Step 9:   Now, click on twitter option here you can add multiple text option. For example you can see in below search text we have added NarendraModi, Chokidar or MaybheeChokidar

Indiandotnet_Twitter_9

Step 11:- Now, delete Detect Sentiment action  and add again by searching the sentiment 

Indiandotnet_Twitter_10

Step 12:  Here we will configure the sentiment option as you can see. We are giving  Tweet Text and Language (we are selecting  English Language)Indiandotnet_Twitter_13

Indiandotnet_Twitter_11

Step 13:-  Now, in the next step  we will configure the Power BI.  For which we will login http://app.powerBi.com  and click on  Streaming Dataset option  because we are  going to providing .

Indiandotnet_Twitter_12

Step 14:  Now, click on API as shown in below image.

Indiandotnet_Twitter_14

Step 15: Now, define the dataset as shown.  below here we are defining the fields. So, in the fields we are adding SentimentScore (which will given by cognitive service) , TwitterDate (when tweet posted), username (who posted the tweet),  tweetText (What is the tweet)

Indiandotnet_Twitter_15

Once, you define the dataset click on Create.

Step 16: Now, save the Report and configure the report as per your need.

Indiandotnet_Twitter_16

Step 17: Here now configure, Power BI dashboard and remove the payload. as shown in below figure.

Indiandotnet_Twitter_17

Step 18:  See the below configuration which configured.

Indiandotnet_Twitter_18

Here if you see, we defined workplace which we have created and dataset defined just above and mapped the fields.

Indiandotnet_Twitter_21

Step 19: Now, Save  the  flow and configuration and try to run it. If everything works perfectly. You will get all the checkbox.

Indiandotnet_Twitter_20

Step 20: Now, you can see the Power BI dashboard you will get the graph updating per minute with the new tweet text whenever a post with specific tag.

Below you can find sentiment score  graph.

Indiandotnet_Twitter_22

In Next post I will share the detail of this sentiment analysis data.

Hope you might like this easy way of sentiment analysis.

Happy learning.

How to start with Microsoft flow ?

Dear Friends,

Microsoft Flow is one of the hot product nowadays and it is not new. It is in the industry from the last few years. In this article, we will try to explore Microsoft Flow and know how it can be helpful to you with an example.

I have changed my writing style in this blog to resolve all the question which you might have if you are new to Microsoft Flow.

What is Microsoft Flow?

Microsoft Flow as the name suggests it helps in building the workflow to resolve business problems or we can say that It helps to automate workflow to resolve business needs or problems. It is basically part of the Microsoft Office 365 suites and mainly created to Business users or Business Analyst to solve or automate their business needs without having knowledge of different programming language like Java C# etc.

It makes you smarter to solve your problem with doing automating the steps. It is a graphical based tool to design flow to resolve any problem.

What are the different scenarios where I can use Microsoft Flow?

Now, you might be thinking of where you can use this. below are several business scenarios where we can use flow.

Examples :-

Email or Mobile Notification

Suppose, you are a marketing team head and you want a notification on your mobile whenever any new lead is generated, then in this case Microsoft Flow will help you.

Folder Watcher

Suppose, you are working on Printer server and your task is to continue watch files in a folder and if any new file arrived in that DropBox folder then you have to print it and share in the email to the XYZ person, then in this case also you can use flow.

Data collector

The other example is to dump the twitter data in your database. For example, you want to monitor what are the different tweets are coming on your newly launched product or product features so you can analyze the sentiments.

Streamline approval
your employee added a Leave request in your portal then Flow will send an email to the manager and as a manager you can approve or hold or cancel that request either directly from outlook message of from Flow itself as per your decision the result will be updated in your portal and a notification email sent to requester employee.

There might be tonnes of examples, or situations where we can use Microsoft Flow to automate and ease our work.

How it is different from Logic Apps?

Now, as you might have gone through my previous blogs and you might be thinking it is just like Logic Apps. So, my answer is yes, it is same as Logic Apps because it is created on top of  Logic Apps. but there are various different points where it differs from Logic Apps.

Below are some of them.

1. Flow is Office 365 suits part and an Individual application for which you don’t need Azure Subscription but for Logic Apps you required Azure Subscription.

2. Flow is developed for Business users /Business Analyst so, you don’t need to write complex code or modify the existing thing use Visual studio to enhance or create but Logic Apps is mainly for developers or people who have programming knowledge so if may require they can change the visual studio code.

What is the first step to start Microsoft Flow?

To start the flow you need to sign up on website https://flow.Microsoft.com. If you are office 365 users then you can sign in with that account or use any other email like Hotmail, outlook to sign up.

Now, you might be thinking about the pricing. There are 3 different plans available, free, Flow Plan1,  Flow Plan 2. depends upon your need you can choose any plan.

Indiandotnet_Microsoft_Flow_Price

Once you opted the plan and sing In after login you will get following home screen to proceed further or we can say this would be your play area where you can create different flows.

Indiandotnet_Flow_Home

Just, make you aware there are various predefined templates available which are created based upon various frequently business needs

Indiandotnet_Flow_Template

How does it work?

Now,  as mentioned earlier it is most likely Logic Apps. So, similar to Logic Apps it has the various connector.

Just think if the concept “if something happened then we have to do something”. So, basically this is based on Trigger and then Action. concept.

Example, An email came to your inbox (Trigger) then (Action) send a mobile notification.

There are more than 200+ connectors available to help you and ease your work.

Indiandotnet_Flow_Connection

Can we have a step by step example to try it out?

Yes, and believe me this is one of the important examples for all the blogger and they will surely, like it.

For a blogger the challenge is promoting his/her post and for which he/she needs to create a shorten URL either on (goo.gl or bitly.com)  and then share on Facebook, Twitter or other social media channel.

Now, this is again a time-consuming process. Now, what you think if we can automate this process.

So, our challenge is whenever a new post is added in the blog then our flow identify that trigger and then provide that link to bitly.com and create a short bitly link and then post the generated link to social media (but in this example I created the notification to make it short and sweet choosing existing template ).

Now with the assumption, you already created your account in the Flow and logged in successfully. we proceed further.

Let’s follow the step here

Indiandotnet_Flow_WordPress_Step_1

Step 1: A an existing template “When a post is created in ”WordPress create a Bitlink URL and send the notification” as shown in below figure.

Indiandotnet_Flow_Wordpress_2

Step 2: Now, as you can see we have to configure the btily authentication and allow Microsoft Flow to access bitly.com to create URL. as shown in the figure.

Indiandotnet_Wordpress_step_3

Step 3:- Once you allowed it.  in the next step, we have to give authentication and authorization to access our WordPress blog. So, whenever a new post came flow will identify. so, just provide access as shown in the below figure.

Indiandotnet_wordpress_Step_4

Step 4:- so far so good we have given authorization for bitly & our WordPress blog.  we don’t need to configure the next step because it would be automatically configured. Now, we are good to go. we have configured perfectly in a few clicks, just save the Flow and check the flow using flow checker option.Indiandotnet_flow_test_Step

If there is no error you found in Flow Checker just click the Test option as shown in below figure.

Indiandotnet_Flow_Office_Step_8

Step 5: Now, go to your blog and create a post and publish it. You will be surprised that your flow automatically identified the new post and created a short URL and notify you as well.

You can see all the flow steps are checked it means the flow is successful.

indiandotnet_Flow_WordPress_11

Step 6: Now, you can check bitly.com and you can find the URL is created and also you got the notification.

Indiandotnet_Flow_Wordpress_12

Step 7: You can check each step detail as well by clicking the object

Indiandotnet_Flow_WordPress_Step_13

So we are good with the flow example.

Please, share your input on how you like the flow and this post  Smile

Happy learning