{"id":110916,"date":"2017-11-28T07:57:22","date_gmt":"2017-11-28T15:57:22","guid":{"rendered":""},"modified":"2025-06-11T08:10:48","modified_gmt":"2025-06-11T15:10:48","slug":"working-with-dates-and-times","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/working-with-dates-and-times\/","title":{"rendered":"Working with Dates and Times inside of your flows"},"content":{"rendered":"<p>Last month <a href=\"https:\/\/flow.microsoft.com\/blog\/nested-apply-to-each\/\">we announced new actions and expressions to help you work with dates and times<\/a>. Read more today, to learn about how to use these features.<\/p>\n<h2>Send an email with formatted times<\/h2>\n<p>One common scenario is to send an email about files created in a OneDrive or SharePoint list. You want the created time text in the email to be in the right time zone for your company. However, all times in Microsoft Flow are in Universal Time (aka, UTC or GMT) by default.\u00a0To get started, let&#8217;s <a href=\"https:\/\/flow.microsoft.com\/manage\/flows\/new\" style=\"font-size: 13.008px;\">create a Flow from blank<\/a> with the\u00a0<strong style=\"font-size: 13.008px;\">When a file is created or modified (properties only)<\/strong>\u00a0trigger:<\/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\/working-with-datetimes-file-trigger.png\" style=\"width: 410px; height: 121px;\"\/><\/p>\n<p>Now, select <strong>New Step<\/strong> and<strong> Add an Action<\/strong>. You will be given a lot of options &#8211; we support over 300 different actions today. To find the actions that work with dates and times, search for\u00a0<strong>Date Time<\/strong>\u00a0and select that connector. You will see the six actions that we have today:<\/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\/working-with-datetimes-datetime-connector.png\" style=\"width: 409px; height: 279px;\"\/><\/p>\n<p>In this scenario, let&#8217;s select\u00a0<strong>Convert time zone<\/strong>. In the\u00a0<strong>Base time\u00a0<\/strong>property select\u00a0<strong>Created<\/strong>\u00a0from the\u00a0<strong>Add dynamic content\u00a0<\/strong>menu &#8211; this will contain the time the file was created in SharePoint, in UTC. Note that <em>all <\/em>times output by any action are in UTC.<\/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\/working-with-datetimes-formats.png\" style=\"width: 484px; height: 391px;\"\/><\/p>\n<p>Thus, for <b>Source time zone<\/b>\u00a0select UTC. For\u00a0<strong>Destination time zone\u00a0<\/strong>select the time zone that your organization uses. Finally, you can choose a friendly format string to include in your email. I like the\u00a0<em>General date\/time<\/em>, which looks like: 6\/15\/2009 1:45PM.<\/p>\n<p>Second, you&#8217;ll want to repeat this same process for the\u00a0<strong>Modified<\/strong> time of the file (add another <strong>Convert time zone<\/strong>\u00a0action, but this time select <strong>Modified\u00a0<\/strong>from the <b>Dynamic content<\/b>).<\/p>\n<p>Finally, add an\u00a0<strong>Send an email<\/strong>\u00a0action. First, fill out who you want the email to go to, and the subject of the email. Then in the <b>Email body <\/b>look at the\u00a0<strong>Add dynamic content<\/strong>\u00a0menu and you&#8217;ll see\u00a0<strong>Converted time<\/strong>\u00a0for each of the two actions that you added:<\/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\/working-with-datetimes-add-timestamps.png\" style=\"width: 462px; height: 258px;\"\/><\/p>\n<p>You can select both items to put them into the body of the email. With all the various properties it could look like this in the Flow designer:<\/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\/working-with-datetimes-email-body.png\" style=\"width: 411px; height: 172px;\"\/><\/p>\n<p>Save your flow! Now, when you add a file to document library, you&#8217;ll get a new email that looks like this (showing the File properties on the top, and the actual email content on the bottom), notice the formatted date times that are in Pacific Time, not UTC:<\/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\/working-with-datetimes-outputs.png\" style=\"width: 382px; height: 324px;\"\/><\/p>\n<h2>Adding to and subtracting times<\/h2>\n<p>Another common ask is to create a relative time in your flow &#8211; for example, to create a task that is due at the end of the day. We will use <a href=\"https:\/\/flow.microsoft.com\/blog\/download-history-recurrence\/\">the new options in the\u00a0<strong>Recurrence<\/strong> trigger<\/a> to start this flow at 8am every weekday. Like <a href=\"https:\/\/flow.microsoft.com\/manage\/flows\/new\">with the first flow<\/a>, create from blank. This time, select the Recurrence trigger.\u00a0<\/p>\n<p>For the Recurrence pattern we want to select a <strong>Frequency <\/strong>of 1\u00a0<strong>Week<\/strong> (this may be counter-intuitive because the flow will run more than once per week<sup style=\"font-size: 70%;vertical-align: super;\">1<\/sup>). Next, select\u00a0<strong>Show advanced options<\/strong>\u00a0and choose the time zone of your business. Then, under\u00a0<strong>On these days<\/strong>\u00a0select the weekdays, and finally <strong>At these hours<\/strong>\u00a0select 8.<\/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\/working-with-datetimes-recurrence.png\" style=\"width: 405px; height: 296px;\"\/><\/p>\n<p>You should now see a preview that says\u00a0<em>Runs at 8:00 on Monday, Tuesday, Wednesday, Thursday, Friday every week.<\/em><\/p>\n<p>Now you can select New Step and Add an action. In the search box enter\u00a0<strong style=\"font-size: 13.008px;\">Get Future Time<\/strong>. For this action you&#8217;ll choose how many hours in the future you want the task to be due:<\/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\/working-with-datetimes-future-time.png\" style=\"width: 413px; height: 133px;\"\/><\/p>\n<p>Finally, you can add the task. Add an action and select where you want to task to be (for example Todoist). First, you will provide a Subject. Then, select\u00a0<strong>Due Date<\/strong>\u00a0and open up\u00a0<strong>Add dynamic content<\/strong>. Here, you&#8217;ll see the output for <strong>Future time<\/strong>. Select that and it&#8217;ll be included as the due date. You&#8217;re all set &#8211; now each weekday you&#8217;ll get a new task due for you at the end of the day.<\/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\/working-with-datetimes-create-task.png\" style=\"width: 367px; height: 150px;\"\/><\/p>\n<p>We hope you found these examples helpful, if you have any questions about how to work with Dates and Times, please <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkID=787467\">reach out to us on the community<\/a>.<\/p>\n<hr\/>\n<p><sup style=\"font-size: 70%;vertical-align: super;\">1<\/sup> <em>The recurrence frequency, when you use the advanced options, indicates how often the overall recurrence pattern repeats. Because we want the same pattern each week, the Interval and Frequency are set to 1 week. Then, inside of each week, you can have multiple days, or even hours, for the trigger to run at.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last month <a href=\"https:\/\/flow.microsoft.com\/blog\/nested-apply-to-each\/\">we announced new actions and expressions to help you work with dates and times<\/a>. This blog post will walk through in more detail how to use these new features &#8211; for example, to send an email with times in the appropriate time zones, or create a task that is due at a certain period of time each weekday.<\/p>\n","protected":false},"author":347,"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":[],"coauthors":[2913],"class_list":["post-110916","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-automate"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Working with Dates and Times inside of your flows - 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\/2017\/11\/28\/working-with-dates-and-times\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Working with Dates and Times inside of your flows - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Last month we announced new actions and expressions to help you work with dates and times. This blog post will walk through in more detail how to use these new features - for example, to send an email with times in the appropriate time zones, or create a task that is due at a certain period of time each weekday.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/working-with-dates-and-times\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-28T15:57:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:10:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.png\" \/>\n<meta name=\"author\" content=\"Stephen Siciliano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Siciliano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/stepsic\/\",\"@type\":\"Person\",\"@name\":\"Stephen Siciliano\"}],\"headline\":\"Working with Dates and Times inside of your flows\",\"datePublished\":\"2017-11-28T15:57:22+00:00\",\"dateModified\":\"2025-06-11T15:10:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/\"},\"wordCount\":748,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/\",\"name\":\"Working with Dates and Times inside of your flows - 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\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.png\",\"datePublished\":\"2017-11-28T15:57:22+00:00\",\"dateModified\":\"2025-06-11T15:10:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.webp\",\"width\":1226,\"height\":362},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with Dates and Times inside of your flows\"}]},{\"@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\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/b8a38edd2ea768aab5f3023847696101\",\"name\":\"Stephen Siciliano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1d877134c29e412a215d4853bd4e3e9df96ad94cb3893c278d245d861dc01dda?s=96&d=mm&r=g496f73519710e0b4d95cff2095e4c011\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1d877134c29e412a215d4853bd4e3e9df96ad94cb3893c278d245d861dc01dda?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1d877134c29e412a215d4853bd4e3e9df96ad94cb3893c278d245d861dc01dda?s=96&d=mm&r=g\",\"caption\":\"Stephen Siciliano\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/stepsic\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with Dates and Times inside of your flows - 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\/2017\/11\/28\/working-with-dates-and-times\/","og_locale":"en_US","og_type":"article","og_title":"Working with Dates and Times inside of your flows - Microsoft Power Platform Blog","og_description":"Last month we announced new actions and expressions to help you work with dates and times. This blog post will walk through in more detail how to use these new features - for example, to send an email with times in the appropriate time zones, or create a task that is due at a certain period of time each weekday.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/working-with-dates-and-times\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-11-28T15:57:22+00:00","article_modified_time":"2025-06-11T15:10:48+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.png","type":"","width":"","height":""}],"author":"Stephen Siciliano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Siciliano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/stepsic\/","@type":"Person","@name":"Stephen Siciliano"}],"headline":"Working with Dates and Times inside of your flows","datePublished":"2017-11-28T15:57:22+00:00","dateModified":"2025-06-11T15:10:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/"},"wordCount":748,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/","name":"Working with Dates and Times inside of your flows - 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\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.png","datePublished":"2017-11-28T15:57:22+00:00","dateModified":"2025-06-11T15:10:48+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/working-with-datetimes-file-trigger.webp","width":1226,"height":362},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/28\/working-with-dates-and-times\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Working with Dates and Times inside of your flows"}]},{"@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\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/b8a38edd2ea768aab5f3023847696101","name":"Stephen Siciliano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1d877134c29e412a215d4853bd4e3e9df96ad94cb3893c278d245d861dc01dda?s=96&d=mm&r=g496f73519710e0b4d95cff2095e4c011","url":"https:\/\/secure.gravatar.com\/avatar\/1d877134c29e412a215d4853bd4e3e9df96ad94cb3893c278d245d861dc01dda?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1d877134c29e412a215d4853bd4e3e9df96ad94cb3893c278d245d861dc01dda?s=96&d=mm&r=g","caption":"Stephen Siciliano"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/stepsic\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_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\/posts\/110916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"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=110916"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110916\/revisions"}],"predecessor-version":[{"id":131153,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110916\/revisions\/131153"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110916"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110916"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110916"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110916"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110916"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110916"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110916"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}