Office 365

How to capture and store tweets based on a hashtag using Microsoft Flow in a SharePoint Online list

Lets look a tutorial to capture tweets using a hashtag using Microsoft Flow and store them in a SharePoint Online list.

The steps are:

  1. Enter the Office 365 portal at, once inside click on the SharePoint option.
  2. Within SharePoint Online we will create a site, click on Create Site and then click on Team Site.
  3. Enter a name for the site and a description. Then click on Next.
  4. Add additional administrators and site members (Optional). Click on Finish
  5. Once our site is created go to the left side and select Site contents
  6. In Site contents click on New and select List
  7. Give the List a name and a description. Click on Create.
  8. Once created the list we will create 2 columns, the type of columns should be Single line of text, to do this we click on the + sign on the side of Title, select Single line of text and in the popup panel on the right put as a name: Message and click on Save, repeat this step but in name put as name: Date.
  9. Change the name to the Title column for which we click on the word Title and click on Column Setting> Rename. Name it: User
  10. Once we have the fields to store the information of the tweets we click on Flow> Create a Flow
  11. In the popup panel on the right, select the flow named Save tweets that include a specific hashtag to SharePoint list
  12. In the next window add your Twitter credentials and you should see two green checks of SharePoint and Twitter. Click on Continue.
  13. In the new window, enter as hashtag #Microsoft in the upper part and, in the lower part, the url of our site and the list that we created, in addition to each column select Username, text of Tweet and Created in respectively. Click Create flow at the top and then at the same place click on Done
  14. In the new window appears the summary of our flow and the history of executions. Wait between 3 to 5 minutes for the flow to run.
  15. Go to the SharePoint list, update the page and see that we already have some tweets.
5 1 vote
Article Rating
Notify of

Inline Feedbacks
View all comments