cancel
Showing results for 
Search instead for 
Did you mean: 
crminnovation

Dynamics 365 Copy a Qualified Lead's Notes to a New Opportunity

The qualification or disqualification of a Lead in Dynamics 365 is a human triggered event that kicks off a predefined process. That process will convert the Lead to a new Contact and Account record and also create an Opportunity that is associated with the Contact and Account. There will also be a link back to the originating lead in the Opportunity record.

 

But what happens to important pieces of information that were recorded in the CRM user's conversations with the Lead? Absolutely nothing! They stay with the Lead record and remain several clicks away from the Opportunity record and are basically out of sight and out of mind.

 

I started thinking about how to solve this challenge with Microsoft Flow after seeing a post on the CRMUG Community support forum.

 

This is what I have come up with as one approach to copy the Notes and attachments to the Opportunity record automatically. You could also approach it differently by changing the regarding on the Notes from the Lead record to the new Opportunity record. Modify it to fit the way your company wants it to work.

 

Here is a big picture of what the Flow looks like. (if it looks a little scrunched on your screen, click on it to get a bigger view):

Copy a Lead's Notes to an Opportunity

 

Let's break down each step in the Flow:

 

Step 1 - Listen for the creation of a new Opportunity and then get all the field data from the Opportunity record. We will need some of that info in later steps.Get New Opportunity Record

 

Step 2 - Check to see if the Opportunity was created as a result of the Automated Lead Qualification workflow. We do this by checking to see if the attribute field on the Opportunity record has any data in the Originating Lead Lookup field (look for this in the Marketing section of the Opportunity form)Did the Opportunity originate from a Lead

 

Step 3 - If it resolves to False, it means the lookup field is not empty, ie it came from a Lead, so then go down the Yes path. If it didn't come from a Lead conversion we don't need to do anything so we don't need any steps for the No result.Did the Opportunity come from a Lead

 

Step 4 - Now lets get all the Notes for the Lead record and then loop through them using the Apply to Each function to make a Copy of the Lead Note to a New Note along with the attachment, if any. And set the regarding to the new Opportunity.Duplicate the Notes

There you go. The takeaway is the List and Apply to Each Actions in Microsoft Flow is the greatest thing to happen for us in the Dynamics 365 world.

Comments
Anonymous

Hi,

 

This looks interesting and I tried to replicate on my environment to make my Marketing team happier.

Interestingly, I am unable to use the Common Data steps (the magenta icons). I copied the steps as closely as possible using the equivalent Dynamics 365 actions (get record, list record, etc.).

 

My version of your flow works as far as the step where we grab all the notes from the relevant Lead. In my case, rather than copying only the notes from that one parent record, it copies all the notes from all leads. Since I am admin on this test environment, it copies a lot of notes 🙂

 

Did you apply any filter (ODATA?) on that Step 4? Can you help out?

 

Thanks,

 

NLima

NLima, Take a closer look at Step 3, where it uses the Lead lookup from the Opportunity record. That is how the filtering is done. It goes to the Lead record that generated the Opportunity.
About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/