In twitter, send a tweet from your account. Save the Flow and check that it is enabled. You can then select each column and add the appropriate tweet field. The table will appear automatically under the Table name drop down. In the insert row action, find the tweets excel spreadsheet in your OneDrive for Business by using the folder icon. This will fire off the process when that account tweets. In the twitter trigger, add the twitter account name to the search text box. When both services are signed in, press continue. When logging into Excel, make sure that you sign into OneDrive for Business with the correct account (otherwise you will get unauthorised access when trying to add rows). You will then be required to login to Twitter and Excel. Search the templates for “Twitter”, and select the “Save tweets to an Excel file” template. The Flow icon should be available in your Office 365 App Launcher if you have the licence enabled (alternatively you can just go to the website). This will make a new table in Excel which Flow can access to add rows. Select the column headers and in the insert menu, select “table”. In OneDrive for business, create a new excel spreadsheet called “tweets”. To start, we are going to create a new excel spreadsheet with a table. The excel spreadsheet will sit in OneDrive for business but you can determine where you would like it stored. This is a simple process but might be useful for keeping track of marketing or even leaving an audit trail of marketing activity by the social media owners within an organisation. In this example, I’m going to setup a Flow to put all the tweets made from the company (my) twitter account into an excel spreadsheet. I wrote a blog post earlier this year about integrating machine learning tools and another post about syncing Google calendar data into SharePoint using Flow processes, but I thought I would get back to basics and provide a clear easy tutorial for Microsoft Flow newcomers. Such as social media providers like Twitter and Facebook or file sharing platforms like Dropbox, OneDrive and Google Drive, and many more services. Microsoft Flow is the new tool integrated with Office 365 which allows different services to interact.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |