Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Bulk create opportunities

Posted on by 365

My staff would like to be able to select a number of accounts in CRM and create an opportunity record for each of them. These opportunities would all be linked to an event.

At first this seemed like a job for a dialog. It can collect all the information about the opportunity and then run them against the organisation. However, this would only work one by one as dialogs can't be run on more than 1 record.

I could create a workflow but a workflow can't accept information from the user so this workflow would need to be preprogrammed with all the info needed for the opportunity. I would prefer to be more flexible.

Is there a way around this without resorting to programming? Can a dialog trigger workflows? The dialog collects the information and then passes that into a workflow? 

*This post is locked for comments

  • RahulGupta1307 Profile Picture
    RahulGupta1307 2,725 on at
    RE: Bulk create opportunities

    Nice Approach Tim!!!

  • jsteelecrm Profile Picture
    jsteelecrm 365 on at
    RE: Bulk create opportunities

    excellent. Thank you so much. I had no idea you could essentially do what I needed to do from a marketing list. When i clicked on the button to create opportunities there was no option to link to an event but I can add that to the opportunity quick create form. Anything else can be done after they are created through bulk edit. Thank you.

  • Verified answer
    Tim Dutcher Profile Picture
    Tim Dutcher 2,100 on at
    RE: Bulk create opportunities

    Ideally, you could provide a custom HTML web resource popup for users to make their selections and programmatically create the opportunities or via workflow, but with some configuration and training there are some no-code possibilities.

    One idea is to use marketing lists. Users can add accounts to a marketing list and possibly use the "Create Opportunities" button that's available from the Account Associated View for a marketing list.

    If the built-in Create Opportunities functionality won't meet the needs, then you could provide a lookup to the event on a marketing list. First, add a 1:N relationship from marketing list to the event entity. Add the lookup field to a marketing list form. Users will start by creating a marketing list and setting the event. Then they can add accounts and run a workflow on the accounts that will create the opportunity records. You can set the account and event as a dynamic value for the new opportunity records that get created.

    Another option is to have users select accounts and run a workflow on them to create opportunities. They can then list the new opportunities that were created (e.g., where they are the owner and createdon is today) and use the bulk edit feature to set the event lookup field and any other fields.  This is more of manual process but it's an option.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans