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.

SharePoint

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

SharePoint

SharePoint

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.

SharePoint

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.

SharePoint

Create SharePoint –Twitter Flow

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

SharePoint

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

SharePoint

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

SharePoint

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

SharePoint

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

SharePoint

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.

SharePoint

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

SharePoint

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

SharePoint

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.

SharePoint

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

SharePoint

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

SharePoint

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.

SharePoint

After configuration, the action will look like below.

SharePoint

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

SharePoint

It will start creating the Flow.

SharePoint

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

SharePoint

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

SharePoint

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.

SharePoint

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

SharePoint

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.

SharePoint

Summary

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