{"id":110763,"date":"2017-01-27T10:58:06","date_gmt":"2017-01-27T18:58:06","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/"},"modified":"2017-01-27T10:58:06","modified_gmt":"2017-01-27T18:58:06","slug":"fotw-schedule-from-sharepoint","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/","title":{"rendered":"Flow of the Week: Schedule tweets from a SharePoint list"},"content":{"rendered":"<p>Often you want to schedule some sort of post to happen in the near future, but the service doesn&#8217;t have an auto-schedule capability. For example, you have a Twitter post that you want to make tomorrow at 8am. It&#8217;s easy to set this up with SharePoint and Microsoft Flow.<\/p>\n<h2>Set up your SharePoint list<\/h2>\n<p>The first step is to set up a SharePoint list to save your scheduled posts to. You will need to have at least two columns:<\/p>\n<ul>\n<li>The content of the post you want to create<\/li>\n<li>The date-time that you want the post to be made at &#8211; make sure that this column is of type Date and Time<\/li>\n<\/ul>\n<p>The list will look something like this:<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.png\" style=\"width: 404px; height: 145px;\"\/><\/p>\n<h2>Set up your flow<\/h2>\n<p>Now you can set up your flow. <a href=\"https:\/\/flow.microsoft.com\/galleries\/public\/templates\/3c017990e4d711e6a628931fb219f561\/\">You can use this template here<\/a>, or build it from scratch.\u00a0<\/p>\n<p>The first step in the flow is going to be triggered when a new item is added to the SharePoint list that you just created. Select <strong>SharePoint<\/strong>\u00a0and then <strong>When a new item is created.<\/strong>\u00a0Select or paste the Site Url and the List name.<\/p>\n<p>Next you will need to add a <strong>Delay until <\/strong>step. To find this action, select <strong>New Step<\/strong>,\u00a0<strong>Add Action\u00a0<\/strong>then <strong>Show more\u00a0<\/strong>at the top\u00a0to see all of the different types of actions Microsoft Flow supports. When you scroll down you should see <strong>Schedule<\/strong>:<\/p>\n<p style=\"text-align: center;\">\u00a0<img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-services.png\" style=\"width: 349px; height: 270px;\"\/><\/p>\n<p>Schedule has two actions &#8212; select\u00a0<strong>Delay until<\/strong>. Inside of Delay until select\u00a0<strong>Add Dynamic Content<\/strong>\u00a0and choose the column in the SharePoint list that contains the date-time you want to post at.<\/p>\n<p>Now, find the\u00a0<strong>Post Tweet<\/strong>\u00a0step by adding an action and selecting the\u00a0<strong>Twitter<\/strong>\u00a0service. If you haven&#8217;t connected to Twitter before with Microsoft Flow you will need to sign in. Last, click in the Tweet Text field and select\u00a0<strong>Add Dynamic Content<\/strong>. This time, choose the column that contains the text of the tweet you would like to send.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-tweet.png\" style=\"width: 350px; height: 346px;\"\/><\/p>\n<p>Since you have finished setting up your flow, select\u00a0<strong>Create flow\u00a0<\/strong>at the top of the screen.<\/p>\n<h2>Schedule your tweets<\/h2>\n<p>When you want to have a tweet be sent out, go to the SharePoint list you created and select\u00a0<strong>New Item<\/strong>. Fill in the columns for Tweet text and the date to post. As soon as you click <strong>Save <\/strong>your tweet will be scheduled.\u00a0<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-form.png\" style=\"width: 300px; height: 326px;\"\/><\/p>\n<p>You can monitor your flow activity by selecting the <strong>(i)<\/strong> icon in the My Flows list. For example, if you accidentally scheduled a tweet that you don&#8217;t want to go out, find the\u00a0<strong>Running<\/strong>\u00a0flow run that was created when you created the SharePoint item, select it, and then click\u00a0<strong>Cancel<\/strong>\u00a0in the command bar at the top of the screen. This will prevent the tweet from being sent.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the scheduling capabilities of Microsoft Flow to have schedule posts to happen in the near future. In this Flow of the Week we will show how you can save scheduled tweets to a SharePoint list and have them posted to Twitter exactly when you want. <a href=\"https:\/\/flow.microsoft.com\/galleries\/public\/templates\/3c017990e4d711e6a628931fb219f561\/\">See the template here.<\/a><\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-110763","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Flow of the Week: Schedule tweets from a SharePoint list - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flow of the Week: Schedule tweets from a SharePoint list - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Use the scheduling capabilities of Microsoft Flow to have schedule posts to happen in the near future. In this Flow of the Week we will show how you can save scheduled tweets to a SharePoint list and have them posted to Twitter exactly when you want. See the template here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Stephen Siciliano\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/\",\"name\":\"Flow of the Week: Schedule tweets from a SharePoint list - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.png\",\"datePublished\":\"2017-01-27T18:58:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.webp\",\"width\":605,\"height\":217,\"caption\":\"graphical user interface, text, application, chat or text message\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Flow of the Week: Schedule tweets from a SharePoint list\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flow of the Week: Schedule tweets from a SharePoint list - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/","og_locale":"en_US","og_type":"article","og_title":"Flow of the Week: Schedule tweets from a SharePoint list - Microsoft Power Platform Blog","og_description":"Use the scheduling capabilities of Microsoft Flow to have schedule posts to happen in the near future. In this Flow of the Week we will show how you can save scheduled tweets to a SharePoint list and have them posted to Twitter exactly when you want. See the template here.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Stephen Siciliano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/","name":"Flow of the Week: Schedule tweets from a SharePoint list - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.png","datePublished":"2017-01-27T18:58:06+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-schedule-list-columns.webp","width":605,"height":217,"caption":"graphical user interface, text, application, chat or text message"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-schedule-from-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Flow of the Week: Schedule tweets from a SharePoint list"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"msxcm_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/347"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110763"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110763\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110763"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110763"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110763"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}