Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Find opportunities without active tasks

Posted on by

Hi!

Every day I need to find opportunities without active tasks and create new task.

How I could do it? Have somebody any ideas?

*This post is locked for comments

  • RE: Find opportunities without active tasks

    Thanks for answers!

    I created recursive workflow and custom workflow activity.

    Nick your idea is very interesting too, thanks!

  • Suggested answer
    Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: Find opportunities without active tasks

    Quick and easy way would be to add a rollup field that counts all active tasks associated to an opportunity.

    Then create a view for opportunities where active tasks = 0.

    Cheers

    Nick

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Find opportunities without active tasks

    Hi Anatoliy,

     If you are on CRM online, it might be worth looking into the Azure Functions.

     You can connect to Dynamics from an Azure Function:

     crmtipoftheday.com/.../connect-to-dynamics-365-in-azure-functions

     Combine it with a timer trigger, and you are good to go:

     docs.microsoft.com/.../functions-bindings-timer

     Not sure how pricing is going to work out - depends on the resource consumption:

     azure.microsoft.com/.../functions

  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Find opportunities without active tasks

    Anatoliy,

    Usually we use SSIS + Kingsway Soft adapters for Dynamics 365 for such tasks. Of course that would require to get separated server and install SSIS and adapters on it.

    If you want to solve that task using only CRM you can use recursive workflow to execute that workflow daily - www.powerobjects.com/.../setting-up-recurring-workflows-in-dynamics-crm-2016 and develop custom workflow activity that will find opportunities and create tasks for those.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans