{"id":20899,"date":"2019-10-25T05:47:57","date_gmt":"2019-10-25T05:47:57","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=20899"},"modified":"2020-06-01T12:50:52","modified_gmt":"2020-06-01T12:50:52","slug":"working-of-delay-until-microsoft-flow-component-with-different-dynamics-365-crm-date-behaviour","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/10\/working-of-delay-until-microsoft-flow-component-with-different-dynamics-365-crm-date-behaviour\/","title":{"rendered":"Working of \u2018Delay Until\u2019 Microsoft Flow component with different Dynamics 365 CRM Date behaviour"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

Introduction of Microsoft Flow for Dynamics 365 CRM has extended the functionality of Dynamics 365 CRM thereby allowing it an easy way to interact with other systems or include features which required much more custom development.<\/p>\n

It is also considered as an advanced version of Workflow where we can achieve tasks which were difficult to achieve using Workflow. In this blog, we are going to discuss one of the flow component – Delay Until<\/strong> and how it works with different behaviour of CRM data type \u2018Date and Time\u2019<\/strong>.<\/p>\n

\"\"<\/p>\n

Here we are going to consider a scenario to check the working. There will be a Next Revised Date<\/strong> on Quote and we need to create task automatically that will inform the user that they need to create New Quote when Next Revised date<\/strong> is elapsed. Given below is the design of the Microsoft Flow:<\/p>\n

\"\"<\/p>\n

We have created three date fields for each date behaviour and used them one by one for Delay Until<\/strong> as shown in the above screen shot to check their behaviour.<\/p>\n

    \n
  1. Next Revised Date 1:<\/strong>\u00a0With Behaviour \u201cUser Local\u201d<\/li>\n
  2. Next Revised Date 2:<\/strong>\u00a0With Behaviour \u201cTime-Zone Independent\u201d<\/li>\n
  3. Next Revised Date 3:<\/strong>\u00a0With Behaviour \u201cDate Only”<\/li>\n<\/ol>\n

    Now let\u2019s discuss them in detail.<\/p>\n

    1. Next Revised Date 1:<\/strong>\u00a0User Local<\/p>\n

    To check how it works we have created two users with one in IST time zone and another in EST time zone.<\/p>\n

    To make Microsoft Flow available to another user you need to add second user as Owner of the Flow as shown below in the below screenshot:<\/p>\n

    \"\"<\/p>\n

    To navigate to this window you need to Edit Flow, then Edit Flow Connections as shown below:<\/p>\n

    \"\"<\/p>\n

    Still you won\u2019t be able to execute Flow and you will face error for permission as shown below:<\/p>\n

    \"\"<\/p>\n

    Here, you will need to add connection for Login user as shown below. Only then, you will be able to execute the Flow for second user.<\/p>\n

    \"\"<\/p>\n

    Here since Microsoft Flow connection is provided for each user, Next Date will be considered as per their respective Time Zone instead of the user which configured the Flow. We checked and found that the Flow were in waiting stage as per user\u2019s respective Time zone as shown below:<\/p>\n

    \"\"<\/p>\n

    2. Next Revised Date 2:<\/strong>\u00a0Time-Zone Independent<\/p>\n

    As this field is to store UTC date and time, Flow as well uses UTC date to execute the task. So in this case when Flow waits for Date and time to elapse it is actually based on UTC Time Zone.<\/p>\n

    As shown in below example, we have set local time for Next Revised Date 2.<\/strong><\/p>\n

    \"\"<\/p>\n

    Here, local time already elapsed on 7:15 AM but Flow is still in waiting stage since UTC time is still 3.00 AM. It completes execution at UTC 3.00 AM.<\/p>\n

    3. Next Revised Date 3:<\/strong>\u00a0Date Only<\/p>\n

    Field with this behaviour is not available for selection as shown in below screen shot where earlier fields \u2018Next Revised Date 1<\/strong>\u2019 and \u2018Next Revised Date 2<\/strong>\u2019 are available and \u2018Next Revised Date 3<\/strong>\u2019 is not.<\/p>\n

    \"\"<\/p>\n

    Note: <\/strong>In workflow if we are to update the field, for example, we have similar workflow which have waiting Job for date of next year and we change the record date with today\u2019s or yesterday\u2019s date then in that case all waiting jobs will be executed. But in case of Microsoft Flow, it will store the details and wait for the date to arrive next year instead of today\u2019s date.<\/p><\/blockquote>\n

    Conclusion<\/strong><\/h2>\n

    As illustrated above, in this way Microsoft Flow component \u2018Delay Until\u2019<\/strong> functions with different behaviour of Dynamics 365 CRM data type \u2018Date and Time\u2019<\/strong>.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction Introduction of Microsoft Flow for Dynamics 365 CRM has extended the functionality of Dynamics 365 CRM thereby allowing it an easy way to interact with other systems or include features which required much more custom development. It is also considered as an advanced version of Workflow where we can achieve tasks which were difficult\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":20905,"comment_status":"closed","ping_status":"closed","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":[18,19,36,1985],"tags":[1967,1150],"class_list":["post-20899","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365-v9-2","category-dynamics-crm","category-microsoft-flow","category-power-automate","tag-dynamics-365-crm-date-behaviour","tag-microsoft-flow"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/20899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=20899"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/20899\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/20905"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=20899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=20899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=20899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}