Connect external services to SharePoint using Microsoft Flow

Connecting external services to SharePoint specially the ones that are not part of Microsoft ecosystem was incredibly hard but this is about to change with Microsoft Flow.

Microsoft Flow is an event-automation service developed to create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and more.

SharePoint 2016 was officially announced last week and it will include a full integration of Microsoft Flow but you don’t need to wait to put your hands in the new version, if you have SharePoint online you can start using it today.

Microsoft Flow

At the moment I’m writing this article Microsoft Flow it’s still in Preview, and you will need to register with your Office 365 account.

Even though it supports a variety of services in this article I’ll just use Twitter and SharePoint.

  1. To register open the Microsoft Flow site and click in the Sign up free
  2. While your account is being created open one of your SharePoint site collections and create a custom list to save the tweets.
    Let’s use the column Title to save the tweet and create a new column to save the Author.
    SharePoint custom list
  3. Open Microsoft Flow, the option will appear in the waffle icon in the Office 365 suite bar
  4. In Microsoft Flow click My Flows and then click Create new flow
  5. Let’s start with Twitter, this will execute an action every time that a tweeter appears and matches a certain condition. Once you select it you will need to Sign in into your Twitter account
    Microsoft Flow - Twitter
  6. Write your query, in this case all the tweets with the hash tag #handsonsharepoint will be processed
  7. Click in the plus icon to add an action
    Microsoft Flow - Twitter
  8. Select SharePoint Online – Create Item and Sign in into SharePoint online
  9. In the Site url field write the url of the site where you’ve created the list
  10. All the lists from the site will populate the List name field, select the one you’ve created to save the tweets
  11. In the Title field select the the Tweet text
  12. In the Author field select the Tweeted by
  13. Provide a name to the Flow and press Create Flow
    Microsoft Flow - Twitter
  14. The Flow will start running immediately and you have the option to share it in the Microsoft Flow gallery
  15. To test your Flow make a tweet that match your query
    Microsoft Flow - Twitter
  16. After a few minutes it will appear in the listMicrosoft Flow - Twitter
  17. Let me know in the comments section what are your thoughts about Microsoft Flow, will this be useful to automate events in your SharePoint?

3 Responses to “Connect external services to SharePoint using Microsoft Flow”

  1. […] Connect external services to SharePoint using Microsoft Flow […]

  2. steve

    July 14, 2017

    Hi there, I’m trying to follow the instructions but when I select the Twitter trigger, I get an error from Flow- it says “You have reached the maximum number of connections for the ‘twitter’ API.”

    Do you think this limit is just for my organization (we have a 10k+ employees, but I doubt more than 10 or 20 people are using Flows for twitter), or is MS Flow on Office 365 running all its queries through the same API key? if they’re all through the same Microsoft key, that seems … limiting

    is there a way to generate/use a different API key with Office 365?

    • João Ferreira

      August 1, 2017

      Hi Steve, I don’t know if there is any limitation on this.
      Were you able to find a solution?


Leave a Reply

I've been working with Microsoft Technologies over the last ten years, mainly focused on creating collaboration and productivity solutions that drive the adoption of Microsoft Modern Workplace.

%d bloggers like this: