Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Notify Contract Expiry Date

Posted on by

Hi All,

I've a created a custom entity named Contract where there is a field named "Contract Expiry Date" and I've a business logic to notify business just before a week of contract expiry date and also on the same day of contract expiry through email. Could you please let me know if this possible to achieve it in system workflow?

Also, I would like to do the same by creating a task in the system to notify.

Thank you,

Leo

  • cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Notify Contract Expiry Date

    Hi Leo,

    I found that even we create a new workflow for "7 days before date" and the workflow will still execute if we set the expiry date within 7 days.

    It seems that system might regards the contract record had passed the "7 days before date" point, so it wouldn't wait.

    So the only normal scenario would be that the contract record expiry date was set to 7 days later than current date.

    My thought is that you could still contains them inside one workflow due to the reason,

    by adding 3 check condition stages for 3 fields, and include different timeout in each check condition stage,

    then the workflow will only jump into one brance,

    Regards,

    Clofly

  • LeoFernandas Profile Picture
    LeoFernandas on at
    RE: Notify Contract Expiry Date

    Hi Clofly,

    As suggested, I've set two timeout conditions for 7 days before contract expiry date and on same of contract expiry date. However, the email is not sending out when there is a scenario like,

    First I set current date which is on same day (trigger point is on Create) and the email is not going out as the workflow enters into waiting condition at 7 days timeout step and moving to another timeout step where I have mentioned for same day expiry date.

    Looks like, I can have only one timeout step in a workflow which can either be 7 days or same day expire date. Also, for three different fields, I need to have different timeout steps for each field conditions check and that's not actually triggering correctly.

    This is my conclusion that I should have a three different workflow for three different fields and can have only timeout condition in a workflow.

    Could you please let me know if there is any other and good way?

    Thank you,

    Leo

  • cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Notify Contract Expiry Date

    Hi Leo,

    You should insert a check condition step inside timeout step:

    pastedimage1574243821638v1.png

    and group your fields validation with AND:

    pastedimage1574243911120v2.png

    Regards,

    Clofly

  • LeoFernandas Profile Picture
    LeoFernandas on at
    RE: Notify Contract Expiry Date

    Thank you Clofly and Naveen for answering my questions pretty quickly.

    I've one more question -  I have three different field where I need to check expiry date in workflow. So, is it possible to have timeout check for more than one field in single workflow?

    Thank you,

    Leo

  • Verified answer
    Naveen Ganeshe Profile Picture
    Naveen Ganeshe 3,393 User Group Leader on at
    RE: Notify Contract Expiry Date

    Hello Leo,

    1. The Trigger point can be set only on Create and Change of Contract Expiry Date.

    2. Yes, it's possible to notify twice through email before 7 and 1 day before as Clofly showed in screenshot below:

    pastedimage1574159414994v1.png

    Here in 2nd step will replace the condition as timeout until 1 day before "Contract Expiry Date".

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Notify Contract Expiry Date

    Hi Leo,

    • Trigger point can be set only on Create and Change of Contract Expiry Date or it should be on any other point?

    Those options are all available trigger points, 

    pastedimage1574157654610v3.png

    while there are other two types of workflow, they could be triggered manually without trigger point.

    1. on-demand, it's mainly used for bulk data operation in entitylist view, and it could be executed manually by javascript. 

    pastedimage1574157669366v4.png

    2. real-time workflow, it could be used for form fields validation like business rule, but it requires more system resources, while the background not.

    pastedimage1574157697435v5.png

    -----------------------------------------------------------------------------------------------------------------------------

    •  it's possible to notify twice through email?

    You could insert another step after "7 days before the actual contract expiry date" step:

    pastedimage1574157150926v1.png

    Regards,

    Clofly

  • LeoFernandas Profile Picture
    LeoFernandas on at
    RE: Notify Contract Expiry Date

    Hi Clofly,

    Thanks for answering my questions.

    I've created a workflow and set trigger point as create and change of Contract Expiry Date field. I would like to notify twice that is 7 and 1 days before the actual contract expiry date.

    Could you please let me know if,

    • Trigger point can be set only on Create and Change of Contract Expiry Date or it should be on any other point?
    •  it's possible to notify twice through email?

    Thanks,

    Leo

  • LeoFernandas Profile Picture
    LeoFernandas on at
    RE: Notify Contract Expiry Date

    Hi Naveen,

    Thanks for answering my questions.

    I've created a workflow and set trigger point as create and change of Contract Expiry Date field. I would like to notify twice that is 7 and 1 days before the actual contract expiry date.

    Could you please let me know if,

    •  Trigger point can be set only on Create and Change of Contract Expiry Date or it should be on any other point?
    •  it's possible to notify twice through email?

    Thanks,

    Leo

  • LeoFernandas Profile Picture
    LeoFernandas on at
    RE: Notify Contract Expiry Date

    Hi Naveen,

    Thanks for answering my questions.

    I've created a workflow and set trigger point as create and change of Contract Expiry Date field. I would like to notify twice that is 7 and 1 days before the actual contract expiry date.

    Could you please let me know if,

    •  Trigger point can be set only on Create and Change of Contract Expiry Date or it should be on any other point?
    •  it's possible to notify twice through email?

    Thanks,

    Leo

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Notify Contract Expiry Date

    Hi Leo,

    You could let your workflow waits to send email util 7 days before the Contract Expiry Date by Wait condition(but we need to set Process to Timeout),

    pastedimage1574074210695v2.png

    then create a task record:

    pastedimage1574074185255v1.png

    if you have any doubt about concepts and differences between wait condition and timeout, you could read article below:

    https://www.magnetismsolutions.com/blog/paul-nieuwelaars-blog/2012/11/25/workflow-wait-conditions-best-practices-dynamics-crm-2011

    You could also take these previous threads as reference:

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/78139/workflow-email-reminder-when-estimated-close-date-is-near/144948

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/244801/workflow-email-reminder-before-2-days-from-appointment-date

    https://survivingcrm.com/2014/04/crm-reminder-workflows-done-right/

    Regards,

    Clofly

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans