Integrate Twitter Feeds With SharePoint List Using Microsoft Flow

The general availability of Microsoft Flow was announced on October 31 by Stephen Siciliano in this blog. Flow makes it easier to automate the business processes and Microsoft is investing a great amount of time in developing Power Apps and Flow, as it is going to play a huge role in the future, which is stated by the official product update. Microsoft Flow is a cloud-based Service that makes it simple to automate common tasks and business processes across your applications and services, such as Office 365, Slack, Drop Box, Sales Force .com, Dynamics 365 and many more. You can visit the Microsoft Flow site to get first-hand experience of Flow

In case you have not signed up for Microsoft Flow, it can be done pretty easily from the Flow Site. 

In this article, we will see how to integrate Twitter feeds to SharePoint Lists using Microsoft Flow.

SharePoint Prerequisites

As the first step, let's create a SharePoint List that will hold the Twitter Feeds.

Create the SharePoint Columns Tweeted By, Retweet Count, and User Location as shown below so that the Twitter feed details will be shown as metadata in the SharePoint List. 

Create SharePoint –Twitter Flow

Now, we can integrate the SharePoint List with Twitter feeds. Select "Create a Flow" option from the SharePoint List.

This will open up the Flow window from where we can select Flow options. 

Select "See more templates" option present at the bottom of the page. 

Select the option "Save specific Tweets to a SharePoint List and get a notification".

Now, select "Use this template" option to start configuring the Flow option. 

We can use this template to track all the tweets about your business and archive the important ones to a SharePoint list. You'll get a push notification upon successful Flow run. Select "Sign in" against each component to authenticate to SharePoint as well as Twitter using Flow. 

Once authenticated to all 3 services, click on "Continue".

This will open up the configuration page where we can modify the default Flow. 

The above action acts in such a way that whenever a new tweet that contains the term SharePoint is posted, we will create item in SharePoint List. 

In the "Create item" action, specify the SharePoint Site URL and List Item. 

For the time being, I am removing the push notification action.

In the "Create Item" action, we can configure the action by adding more information about the tweet so that a 1-1 mapping between the tweet and SharePoint List Item is created. 

After configuration, the action will look like below. 

Click on "Create Flow" to complete the creation of the Flow.

It will start creating the Flow. 

The Flow has been created and we can click on Manage, if we want to edit the Flow action. 

After some time, if we head over to the SharePoint List, we can see the Twitter feeds created in SharePoint Lists. 

If we head over to Microsoft Flow site, My Flows will list out all the created flows. We can conditionally switch On/Off the Flow from here. 

Clicking on the inverted exclamation mark will show the history of the Flow runs. 

Clicking on the Flow name will take us to the Flow edit page where we can add/update the actions. Once done, clicking on "Update flow" will update the Flow. 

Summary

Thus, we have created a new Microsoft Flow that integrates SharePoint List with Twitter feeds.