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.

Image 1Flow-image_1

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.
Image 2Flow-image_2

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

Image 3Flow-image_3

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

Image 4Flow-image_4

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

Image 5Flow-image_5

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

Image 6Flow-image_6

16. After a few minutes it will appear in the list

Image 7Flow-image_7

Let me know in the comments section what are your thoughts about Microsoft Flow, will this be useful to automate events in your SharePoint?

About the Author:
joao-ferreiraJoão Ferreira is a Web and SharePoint developer and I’m currently living in Vila do Conde, Portugal. João has a degree and a master in Computer Science and over the last three years has been a Web developer focused in branding to make life easier and prettier for SharePoint users. João works for BindTuning.

Share this on...

Rate this Post: