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 to create an account.

2. Microsoft Power BI: You need Microsoft Power BI account for this you can use to create an account.

3. Microsoft Form:  You need Microsoft Form account for this you can use to create an account.



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.


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


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.


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.


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”


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


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


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 and create a stream dataset in your workspace as shown in below figure.


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


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.


Just click on Create button to proceed further


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.


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.


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


Now, just configure the Power BI as shown


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.


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.


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.



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

2) You should have Microsoft Power BI account if you don’t have then you can create via link

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

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.


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


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.


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.


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


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


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


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.


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.


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.


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


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


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


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


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


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)


Once, you define the dataset click on Create.

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


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


Step 18:  See the below configuration which configured.


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


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


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.


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 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.


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.


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


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.


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 ( or  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 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


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.


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


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.


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.


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.


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


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


So we are good with the flow example.

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

Happy learning