Microsoft Flow for Twitter Sentiment Analytics

Here, I am going to share my recent learning about Microsoft Flow which showcase how to do sentiment analysis using Twitter and Microsoft Cognitive service.

You can watchYouTube video here.

Pre-Requisite

Microsoft Cognitive – Text Analytics Endpoints and Subscription Keys.

This is also available for 7 days trail from Microsoft

https://azure.microsoft.com/en-in/services/cognitive-services/

Some formula's used in Flows are

1) Compose action – to get last row of the table

last(body('List_rows_present_in_a_table')?['value'])

2) Fetch TweetId or SinceId as Columns value from Compose output

Outputs(‘Compose’)?[‘Original Tweet Id’]

3) Excel Header Columns

• Original Tweet ID
• UserName
• Original Tweet
• Transalated Tweet
• Followers Count
• Sentiment Score
• Location
• ReTweet Count
• Favourite Count