{"id":1652,"date":"2018-03-09T16:21:33","date_gmt":"2018-03-09T21:21:33","guid":{"rendered":"https:\/\/toddbaginski.com\/blog\/?p=1652"},"modified":"2018-06-04T14:45:31","modified_gmt":"2018-06-04T18:45:31","slug":"working-with-local-and-utc-dates-and-times-in-powerapps","status":"publish","type":"post","link":"https:\/\/toddbaginski.com\/blog\/working-with-local-and-utc-dates-and-times-in-powerapps\/","title":{"rendered":"Working with Local and UTC Dates and Times in PowerApps"},"content":{"rendered":"

Handling dates and times with Local time and UTC time when you are developing PowerApps can be tricky.\u00a0 Believe me, I know.\u00a0 \ud83d\ude42<\/p>\n

“A man who dares to waste one hour of time has not discovered the value of life.” – Charles Darwin<\/strong><\/p>\n

“A man who dares to waste one hour of time developing PowerApps has not discovered this blog post.” – Todd Baginski<\/strong><\/p>\n

To make reading this blog post as awesome as possible, I highly recommend listening to Pink Floyd\u2019s ‘Time’ in another browser window by clicking\u00a0this link<\/a>.<\/h5>\n

Alright, enough joking around, here are a couple of things related to Dates and Times to be aware of in PowerApps.<\/p>\n

First, in case you never noticed, the Date Picker control in PowerApps allows you to set the Date time zone<\/strong> property.<\/p>\n

Here’s one set to UTC time:<\/strong><\/p>\n

\"\"<\/p>\n

Here’s another set to Local time:<\/strong><\/p>\n

\"\"<\/p>\n

Depending which value you select, the date and time returned by the control will reflect the Local or UTC date and time.\u00a0 Pay attention to this and make sure you set the property to meet your scenario.<\/p>\n

Another thing to be aware of, the connectors that communicate with the Graph API (or any other API), or custom connectors you create, may return Local or UTC times, and they may also expect Local or UTC times as parameters.<\/p>\n

Here’s an example of a date and time value coming back from the Graph API.<\/p>\n

\"\"<\/p>\n

When you are developing PowerApps, you need to make sure you are always using the appropriate Local or UTC times to ensure all your data makes sense in the PowerApp as well as all the systems it integrates with.<\/p>\n

You may also need to convert Local dates and times to UTC dates and times.\u00a0 It all depends on your PowerApp and the connectors it uses.<\/p>\n

To make this easier to figure out I created a sample PowerApp that demonstrates how Local and UTC Date Pickers work and also how to use the TimeZoneOffset function to convert Local to UTC time.<\/p>\n

Here’s what it looks like.<\/p>\n

\"\"<\/p>\n

You can also convert UTC to Local time pretty easily, but it’s not demonstrated in the sample PowerApp.\u00a0 You can learn how to do that\u00a0here<\/a>.<\/p>\n

Download the sample PowerApp here.<\/a><\/p>\n

Now, quit wasting time and go download it!\u00a0 \ud83d\ude42<\/p>\n

Thanks,\u00a0Ian Davis,<\/a> for working through this with me.<\/p>\n","protected":false},"excerpt":{"rendered":"

Handling dates and times with Local time and UTC time when you are developing PowerApps can be tricky.\u00a0 Believe me, I know.\u00a0 \ud83d\ude42 “A man who [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":1682,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[104,121],"tags":[10,5,54,45,112],"class_list":["post-1652","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-365","category-powerapps","tag-custom-development","tag-helpful-code","tag-mobile","tag-o365","tag-powerapps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/1652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/comments?post=1652"}],"version-history":[{"count":15,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/1652\/revisions"}],"predecessor-version":[{"id":1681,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/1652\/revisions\/1681"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/media\/1682"}],"wp:attachment":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/media?parent=1652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/categories?post=1652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/tags?post=1652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}