Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

How to create a workflow that creates an activity and then sends and email notification after 3 weeks if activity is still open?

Posted on by 20

Hello

I'm hoping someone can help me as I'm going round in circles trying to find a solution to this new workflow.

Simply put, I need to create a workflow that does the following;

If opportunity = Won, AND 'Who signed deal' = 'Dealer', 'Introducer' or 'Distant Sale', then create an activity (phone call) for the opportunity owner. 

If activity is still open 3 weeks after the opportunity close date, an email is sent from the opportunity owner to our Sales Director. 

The workflow I have created is completely flawed. When I activate the workflow, it appears to run any job that is a closed won opportunity, but doesn't take into consideration 'Who Signed Deal'. The activity (phone call) is also created as my activity even though the phone call is set as Call From : {Owner(Opportunity)}. The job then changes to waiting status, and then doesn't ever proceed to send email after the wait condition.

Please see workflow set-up below;

6332.Notification.PNG

Can anyone help me resolve or simplify this problem? For testing purposes I set wait condition as 2 minutes but it will be for 3 weeks.

Thanks 

*This post is locked for comments

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: How to create a workflow that creates an activity and then sends and email notification after 3 weeks if activity is still open?

    Hi,

    You need to use Timeout instead of Process:Execution Time. Also, Actual Close Date is a date only field so may be your 2 minute thing will not work.

    Refer below, do note that with timeout the postpone until date actually tells you the time the process is waiting for based on the current value of the field.

    1018.timeout.png

    Also, refer the below blog on wait until vs timeout.

    http://blog.clickdimensions.com/crm-workflows-wait-versus-timeout/

    Hope this helps.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans