{"id":5960,"date":"2024-07-25T04:20:16","date_gmt":"2024-07-25T04:20:16","guid":{"rendered":"https:\/\/powergi.net\/?p=5960"},"modified":"2025-09-09T21:28:52","modified_gmt":"2025-09-09T21:28:52","slug":"always-show-est-time-zone-in-power-apps","status":"publish","type":"post","link":"https:\/\/powergi.net\/de\/blog\/always-show-est-time-zone-in-power-apps\/","title":{"rendered":"Always show EST time zone in Power Apps"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5960\" class=\"elementor elementor-5960\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63b83ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63b83ae\" data-element_type=\"section\" data-e-type=\"section\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f35648f\" data-id=\"f35648f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c33ed1a elementor-widget elementor-widget-table-of-contents\" data-id=\"c33ed1a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"marker_view\":\"numbers\",\"hierarchical_view\":\"yes\",\"min_height\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]}}' data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__c33ed1a\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ee57d0 elementor-widget elementor-widget-text-editor\" data-id=\"9ee57d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">When we save data in SharePoint or Dataverse from Power Apps, datetimes are stored in the universal time zone (UTC) and whenever we show date time columns in the apps, <\/span><a href=\"https:\/\/powergi.net\/\"><b>Power Apps<\/b><\/a> <span style=\"font-weight: 400;\">will always recognize the user\u2019s setting and will show date time based on this.<\/span><\/p><p><span style=\"font-weight: 400;\">There are some scenarios in which we need to standardize which time zone we show dates and times in. In this blog, we will show you the options available <\/span><span style=\"font-weight: 400;\">to ensure a consistent <\/span><b>Power Apps EST Time Zone. <\/b><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8aeb656 elementor-widget elementor-widget-heading\" data-id=\"8aeb656\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">The DateAdd and TimeZoneOffset functions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd301b5 elementor-widget elementor-widget-text-editor\" data-id=\"cd301b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">We can use the DateAdd function in Power Apps to force time zones in UTC and to add or remove X number of hours from a date time:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ebafa97 elementor-widget elementor-widget-code-highlight\" data-id=\"ebafa97\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>DateAdd( \r\n\u202f \u202f \u202f \u202f {your-datetime-column}, \r\n\u202f \u202f \u202f \u202f {number-of-minutes-or-hrs}, \r\n\u202f \u202f \u202f \u202f {minutes-or-hours} \r\n\u202f \u202f ) \r\n \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-88b4136 elementor-widget elementor-widget-text-editor\" data-id=\"88b4136\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Above function can be combined with TimeZoneOffset, to force a datetime value to be shown in UTC time zone. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a277830 elementor-widget elementor-widget-code-highlight\" data-id=\"a277830\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>DateAdd( \r\n\u202f \u202f \u202f \u202f {your-datetime-column}, \r\n\u202f \u202f \u202f \u202f TimeZoneOffset(), \r\n\u202f \u202f \u202f \u202f TimeUnit.Minutes \r\n\u202f \u202f ) <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-963755f elementor-widget elementor-widget-text-editor\" data-id=\"963755f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The TimeZoneOffset function will calculate the difference in minutes between the user\u2019s time zone and UTC, so when used as the second parameter of the DateAdd function, this will return the date time value in UTC.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Now, we need to convert UTC into the final time zone we need to display in the app. We can just add another DateAdd function wrapping the code above and then just add or remove the number of hours we want to adjust UTC:\u00a0<\/span><\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7267\" class=\"elementor elementor-7267\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Turn your ideas into digital solutions<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Our team guides you step by step to build custom apps in Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/de\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73914f3 elementor-widget elementor-widget-code-highlight\" data-id=\"73914f3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>DateAdd( \r\n\u202f \u202f DateAdd( \r\n\u202f \u202f \u202f \u202f {your-datetime-column}, \r\n\u202f \u202f \u202f \u202f TimeZoneOffset(), \r\n\u202f \u202f \u202f \u202f TimeUnit.Minutes \r\n\u202f \u202f ), \r\n\u202f \u202f -4, \r\n\u202f \u202f TimeUnit.Hours \r\n) \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-419f3ed elementor-widget elementor-widget-text-editor\" data-id=\"419f3ed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In the above function, we\u2019re calculating the UTC-4 time zone.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">This approach works perfectly for time zones that do not have daylight saving. If the time zone you want to display on has daylight saving, you will have to remember to come to the app and update the new number of hours against UTC for your app to keep displaying the right values.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">But don\u2019t you worry! There is a workaround to automatically change the number hours based on daylight saving using <a href=\"https:\/\/powergi.net\/blog\/power-automate-desktop-app-licensing-explained-updated-2024\/\"><strong>Power Automate<\/strong><\/a>.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78dade9 elementor-widget elementor-widget-heading\" data-id=\"78dade9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Workaround 1: use a Power Automate workflow<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03d58c2 elementor-widget elementor-widget-heading\" data-id=\"03d58c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 1. Add a workflow in your app <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b1f553d elementor-widget elementor-widget-text-editor\" data-id=\"b1f553d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Go to flows and then create a new <\/span><a href=\"https:\/\/powergi.net\/blog\/power-automate-desktop-app-licensing-explained-updated-2024\/\"><b>power automate workflow<\/b><\/a><span style=\"font-weight: 400;\">. You don\u2019t need to add any triggers.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Find the \u201cConvert time zone\u201d action, and set up two of these actions as follows: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ac42ad elementor-widget elementor-widget-image\" data-id=\"2ac42ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"376\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-14-1024x376.png\" class=\"attachment-large size-large wp-image-5962\" alt=\"Power Apps Settings\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-14-1024x376.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-14-300x110.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-14-768x282.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-14-1536x564.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-14.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ff0fa3 elementor-widget elementor-widget-text-editor\" data-id=\"2ff0fa3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Important: make sure to rename your actions. For the EST action, we selected EST time zone in the destination field, but you can select the time zone you want to work with in this step.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">After that, let\u2019s just add a compose action with the following PowerFX code: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2feba41 elementor-widget elementor-widget-code-highlight\" data-id=\"2feba41\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{int(first(split(dateDifference(body('UTC'),body('EST')),':')))} <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0dd1332 elementor-widget elementor-widget-text-editor\" data-id=\"0dd1332\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">What this function is doing is taking the time in EST and also in UTC and just calculating the difference in hours between these two.<\/span><\/p><p>This process is a great example of how <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>Power platform consulting services<\/strong><\/a> can help organizations automate their workflows efficiently.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56a43f6 elementor-widget elementor-widget-image\" data-id=\"56a43f6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"738\" height=\"853\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-15.png\" class=\"attachment-large size-large wp-image-5963\" alt=\"Power Apps Timezone Settings\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-15.png 738w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-15-260x300.png 260w\" sizes=\"(max-width: 738px) 100vw, 738px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5ee57b elementor-widget elementor-widget-text-editor\" data-id=\"c5ee57b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Finally, just add the \u201cRespond to a Power App or flow\u201d action and add an output to it. We will call out output variable \u201coffsetval\u201d and just add the compose action into the value field:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7563cba elementor-widget elementor-widget-image\" data-id=\"7563cba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"735\" height=\"233\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-16.png\" class=\"attachment-large size-large wp-image-5964\" alt=\"Power App or flow\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-16.png 735w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-16-300x95.png 300w\" sizes=\"(max-width: 735px) 100vw, 735px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1536aad elementor-widget elementor-widget-text-editor\" data-id=\"1536aad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">For this scenario, we added the output as a string and not a number because Power Apps was not liking the number format.<\/span><\/p><p><span style=\"font-weight: 400;\">This is how end result should look:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67a31a4 elementor-widget elementor-widget-image\" data-id=\"67a31a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"468\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-17-1024x468.png\" class=\"attachment-large size-large wp-image-5966\" alt=\"Calculate EST difference\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-17-1024x468.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-17-300x137.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-17-768x351.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-17-1536x703.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-17.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a53adc0 elementor-widget elementor-widget-text-editor\" data-id=\"a53adc0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Save and close.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6dd662c elementor-widget elementor-widget-heading\" data-id=\"6dd662c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 2. Run the flow OnStart <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c1a0c6 elementor-widget elementor-widget-text-editor\" data-id=\"8c1a0c6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Find the OnStart attribute of your app and paste the following code: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c36916 elementor-widget elementor-widget-code-highlight\" data-id=\"7c36916\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>Set( \r\n\u202f \u202f varTimeOffset, \r\n\u202f \u202f CalculateESTdifference.Run().offsetval \r\n); \r\nIf( \r\n\u202f \u202f IsBlank(varTimeOffset), \r\n\u202f \u202f Set( \r\n\u202f \u202f \u202f \u202f varTimeOffset, \r\n\u202f \u202f \u202f \u202f \"-4\" \r\n\u202f \u202f ) \r\n); <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-675fcba elementor-widget elementor-widget-text-editor\" data-id=\"675fcba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">It should look like this: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0aae420 elementor-widget elementor-widget-image\" data-id=\"0aae420\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"974\" height=\"327\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-18.png\" class=\"attachment-large size-large wp-image-5967\" alt=\"OnStart Format Text\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-18.png 974w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-18-300x101.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-18-768x258.png 768w\" sizes=\"(max-width: 974px) 100vw, 974px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ca0e312 elementor-widget elementor-widget-text-editor\" data-id=\"ca0e312\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">With these lines of codes, we\u2019re running the flow everytime the app starts and saving the value of the <\/span><b>offsetval<\/b><span style=\"font-weight: 400;\"> output (the one that gives us back the difference in hours between EST and UTC) from the flow into the <\/span><b>varTimeOffset<\/b><span style=\"font-weight: 400;\"> variable in Power Apps.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">We also added some additional logic to assign -4 in case something goes wrong with the flow.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c413dd6 elementor-widget elementor-widget-heading\" data-id=\"c413dd6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 3. Use the varTimeOffset variable in your date time calculations <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb2def6 elementor-widget elementor-widget-text-editor\" data-id=\"fb2def6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Now, it\u2019s just about using the variable that stores the EST vs UTC difference in the different controls we want to display EST time zone.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">We will use the same function we reviewed in the previous section, but this time instead of hardcoding the -4, we will use this dynamic variable that will calculate automatically the number of hours difference, regardless of daylight saving.<\/span><\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7276\" class=\"elementor elementor-7276\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">From vision to execution<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Whether you're just starting or scaling automation, we help turn your ideas into impactful solutions.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/de\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3eee101 elementor-widget elementor-widget-code-highlight\" data-id=\"3eee101\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>DateAdd( \r\n\u202f \u202f DateAdd( \r\n\u202f \u202f \u202f \u202f ThisItem.'Send on', \r\n\u202f \u202f \u202f \u202f TimeZoneOffset(), \r\n\u202f \u202f \u202f \u202f TimeUnit.Minutes \r\n\u202f \u202f ), \r\n\u202f \u202f varTimeOffset, \r\n\u202f \u202f TimeUnit.Hours \r\n)\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-94462f4 elementor-widget elementor-widget-text-editor\" data-id=\"94462f4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">It should look like this: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ccc0d68 elementor-widget elementor-widget-image\" data-id=\"ccc0d68\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"306\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-19.png\" class=\"attachment-large size-large wp-image-5968\" alt=\"EST vs UTC difference\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-19.png 771w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-19-300x119.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-19-768x305.png 768w\" sizes=\"(max-width: 771px) 100vw, 771px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d85ecc2 elementor-widget elementor-widget-heading\" data-id=\"d85ecc2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 4. Make sure to share the flow with all the users that have access to the app \n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc04578 elementor-widget elementor-widget-text-editor\" data-id=\"fc04578\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Open the Power Automate portal and locate the flow.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Find the \u201cRun only users\u201d section and click on Edit <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c8f1a5 elementor-widget elementor-widget-image\" data-id=\"3c8f1a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"492\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-20-1024x492.png\" class=\"attachment-large size-large wp-image-5969\" alt=\"Calculate EST difference\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-20-1024x492.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-20-300x144.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-20-768x369.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-20.png 1429w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9056a7c elementor-widget elementor-widget-text-editor\" data-id=\"9056a7c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In the next panel, select users, security groups or SharePoint lists you want to share this flow with: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55e14ef elementor-widget elementor-widget-image\" data-id=\"55e14ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"526\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-21.png\" class=\"attachment-large size-large wp-image-5970\" alt=\"Manage run-only permissions\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-21.png 577w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/07\/unnamed-21-300x273.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff48d3b elementor-widget elementor-widget-text-editor\" data-id=\"ff48d3b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Empower your business with <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>Power Platform consulting services<\/strong><\/a>, which streamline processes and remove inefficiencies. We help you tap into the full potential of automation, ensuring seamless and effective integration with your existing systems.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b29aa3 elementor-widget elementor-widget-heading\" data-id=\"9b29aa3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Workaround 2: store difference in a SharePoint list or a Dataverse table<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a12677b elementor-widget elementor-widget-text-editor\" data-id=\"a12677b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The caveat to the workaround #1 approach is that this flow will run every single time users open the app, because timezone difference needs to be calculated every time. If this is an issue for your use case, you can store the timezone difference in a SharePoint list or a Dataverse table with a single row, and have a Power Automate workflow that checks daily the difference and updates your datasource with the time difference.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents When we save data in SharePoint or Dataverse from Power Apps, datetimes are stored in the universal time zone (UTC) and whenever we show date time columns in the apps, Power Apps will always recognize the user&#8217;s setting and will show date time based on this. There are some scenarios in which [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":5980,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"","footnotes":""},"categories":[155,81,85],"tags":[13,17,133],"class_list":["post-5960","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-canvas-apps","category-power-apps-cat","category-power-automate-cat","tag-automation","tag-power-automate","tag-power-automate-desktop-app-services"],"glossary_letter":null,"rank_math_title":"Power Apps | Power Apps EST Time Zone | Power Automate Workflow","rank_math_description":"Show EST time zone in Power Apps effectively with DateAdd and TimeZoneOffset functions, supported by a Power Automate workflow for seamless updates.","rank_math_focus_keyword":"Power Apps","_links":{"self":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/5960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/comments?post=5960"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/5960\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media\/5980"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media?parent=5960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/categories?post=5960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/tags?post=5960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}