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.
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.
- To register open the Microsoft Flow site and click in the Sign up free
- 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.
- Open Microsoft Flow, the option will appear in the waffle icon in the Office 365 suite bar
- In Microsoft Flow click My Flows and then click Create new flow
- 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
- Write your query, in this case all the tweets with the hash tag #handsonsharepoint will be processed
- Click in the plus icon to add an action
- Select SharePoint Online – Create Item and Sign in into SharePoint online
- In the Site url field write the url of the site where you’ve created the list
- All the lists from the site will populate the List name field, select the one you’ve created to save the tweets
- In the Title field select the the Tweet text
- In the Author field select the Tweeted by
- Provide a name to the Flow and press Create Flow
- The Flow will start running immediately and you have the option to share it in the Microsoft Flow gallery
- To test your Flow make a tweet that match your query
- After a few minutes it will appear in the list
Let me know in the comments section what are your thoughts about Microsoft Flow, will this be useful to automate events in your SharePoint?
May 17, 2016
[…] Connect external services to SharePoint using Microsoft Flow […]
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?
August 1, 2017
Hi Steve, I don’t know if there is any limitation on this.
Were you able to find a solution?