{"id":110783,"date":"2017-03-27T09:00:03","date_gmt":"2017-03-27T16:00:03","guid":{"rendered":""},"modified":"2025-06-11T08:15:05","modified_gmt":"2025-06-11T15:15:05","slug":"flows-by-vertical-social-media","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flows-by-vertical-social-media\/","title":{"rendered":"By Industry – Social Media: Flows that will save you hours"},"content":{"rendered":"
Today we are going to start a new series called Flow by Industry<\/b>, and our first focus will be for those of you working in Social Media<\/b>.<\/p>\n
Let\u2019s face it, effective Social Media management can be a real struggle! Even if we focused on Twitter use only, it’s full of tasks like maintaining an editorial calendar, posting tweets, responding to mentions, moderating spam, and then the reporting on all the above actions and their impact Wow, that\u2019s a lot! Luckily, with Flow, we can take some of the frustration out of those tasks.<\/p>\n
\u00a0<\/p>\n
First, let\u2019s automate your editorial calendar and Twitter posting, as you probably either spend a lot of time doing this manually or pay for a tool to handle it. Instead of those two options, let’s use what we already have and simply be more effective with it!<\/p>\n
For this demo, we’ll use a SharePoint list as the place to organize our Tweets. To follow along, you\u2019ll need to make a SharePoint list, and give it the following headers:<\/p>\n
Now that that’s set up, let’s get started with Microsoft Flow!<\/p>\n
\u00a0<\/p>\n
<\/p>\n<\/li>\n
\u00a0<\/p>\n
<\/p>\n<\/li>\n
\u00a0<\/p>\n
<\/p>\n<\/li>\n
We’ve now established where our tweets will be coming from and when they will be posted for us. It’s time to use the SharePoint list to establish WHAT will be tweeted out at those times. In the Post a Tweet<\/b> box, let’s also choose Add Dynamic Content<\/b>, and this time let’s select Tweet Content <\/b> so that what gets tweeted is what we put into the SharePoint list column titled Tweet Content <\/b>. Here’s an example:<\/p>\n
<\/p>\n<\/li>\n
\u00a0<\/p>\n
<\/p>\n
You should now see a screen like this:<\/p>\n
<\/p>\n<\/li>\n
\u00a0<\/p>\n
<\/p>\n<\/li>\n<\/ol>\n
Now, let\u2019s look at how we can automate the opposite action, and collect tweets containing a certain hashtag into a SharePoint List, so we can run NSAT and other tools against the data.<\/p>\n
First, you\u2019ll need to make a SharePoint list, and give it the following headers:<\/p>\n
Let’s get started!<\/p>\n
Click on over to this template<\/a> on the Flow website. Got it open? Great. It should look something like this:<\/p>\n Once you have made your SharePoint and Twitter connections, go ahead and click on continue<\/b>. You should see a screen like the one below, where you can set the specifics of how you want tweets to be put into the SharePoint list.<\/p>\n In the top box, labelled When a new tweet appears<\/b>, enter the hashtag you would like to track for this list. I am using #microsoftflow<\/b>, as I like to see the conversation around our product in a manageable fashion.<\/p>\n<\/li>\n Now, in the Create item<\/b> box, we need to define a few things so that the Twitter data we want goes into our list in expected ways.<\/p>\n<\/li>\n First, for the top two entries, enter your SharePoint site URL, and then select the SharePoint list you created earlier from the dropdown menu.<\/p>\n<\/li>\n You can customize the title any way you want. Personally, I simply say \u201cTweet From <Name>\u201d – that being the dynamic name content pulled from Twitter.<\/p>\n<\/li>\n Map the Username<\/b> dynamic content field to the User name field.<\/p>\n<\/li>\n Map the Tweet text<\/b> dynamic content field to the Tweet Content field.<\/p>\n<\/li>\n For the date column, I map the Original tweet created<\/b> at dynamic content field.<\/p>\n<\/li>\n Now that I have filled all of that out, I click Create Flow<\/b> near the top of the page, and then Done<\/b>.<\/p>\n<\/li>\n<\/ol>\n And that\u2019s it! My first flow is actively tweeting all of my pre-determined content at the times I told it to, and my second Flow is now actively searching Twitter for my hashtag and filling my second SharePoint list with those results for me!<\/p>\n I just saved myself HOURS of work with a few clicks, connecting the tools I already have, to work in more efficient and automated ways.<\/p>\n Which flows are you using for Social Media? Which industry should we cover next?<\/p>\n We would love to hear from you on Twitter<\/a>, in our Community<\/a>, or here in the comments!<\/b><\/p>\n Thanks for reading!<\/p>\n","protected":false},"excerpt":{"rendered":" Welcome to the Flow Blog! Today we are going to start a new series called Flow by Industry and the first industry we will focus on will be those of you working in Social Media. Let’s take a step-by-step look at automatically posting tweets at a scheduled time, and collecting details about all tweets that use a set hashtag.<\/p>\n","protected":false},"author":348,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3423],"job-role":[],"product":[3474],"property":[],"topic":[3435],"coauthors":[2899],"class_list":["post-110783","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-automate","topic-operations"],"yoast_head":"\n
<\/p>\n<\/li>\n
<\/p>\n<\/li>\n