#Office365Challenge Today’s Flow template will allow you to find tweets that include a product (word) you’re interested in. It will then take the tweet, and add a line item in Excel on OneDrive.
|Day:||248 of 365, 117 left|
|Tools:||Office 365 / SharePoint / Flow|
|Description:||Flow – Log the latest tweets about your product in Excel|
Around the Office in 365 Days: Day 247 – Flow: Save my email attachments to a SharePoint document library
Around the Office in 365 Days: Day 246 – Flow – Save updates from Facebook to a SharePoint List
Around the Office in 365 Days: Day 245 – Flow – Save tweets that include a specific hashtag to a SharePoint list
Around the Office in 365 Days: Day 244 – What is Microsoft Flow?
Seeing as Microsoft launched Microsoft Teams last night, I used this as my example. I will search twitter and whenever the words “Microsoft Teams” appear, it will add a line to an Excel Spreadsheet in OneDrive.
First things first, I created an Excel spreadsheet on OneDrive and created a table by selecting an area > Format as table (thank you for helping me fix this Johan Myburgh, I originally just named the table and that didn’t work):
(Your SharePoint and Twitter connection should be setup by now, if not, do so). You’ll see that the Flow starts with a Button – I’ll explain that in a bit. Under Search Tweets, add the text you want to search for:
In the “Insert Row” section you need to find the file on OneDrive:
Once the file is selected, you can select the table you defined above, and publish the necessary Twitter fields to your columns:
Save and click on Done to finalize your Flow. I’ve downloaded the Flow app on my Android phone. On this App I can execute the Flow by going to Buttons > then click on the specific Flow. This Flow will only execute when you click on the button to run:
I got a message to say that it ran successfully, and when I checked my Excel spreadsheet – VOILA!!!
I know. It’s pretty awesome. Sooooooo easy. Makes super stars of “Mere Mortals” like me 🙂
Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.