web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Converting a Lead to a...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Converting a Lead to an Existing Opportunity

(1) Share

Report

Report

Posted on by MT-21051813-0

16

During our qualification process, when we qualify a lead and we are converting it to a contact, account and opportunity; we are able to search for an existing contact and account but for an opportunity can create new or delete. Is there a way to open this up to search for existing?

Screenshot 2025-05-21 at 2.14.39 PM.png

Categories:

Dynamics 365 general

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Tom_Gioielli 3,084 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
The standard relationship between a lead and an Opportunity is One to Many, meaning a single lead can spawn multiple opportunities but not the other way around. There's a logic to this, in that a lead isn't really a lead if you already have an Opportunity for that specific sale existing in your system. If anything, I would typically recommend the lead be closed out as qualified with a status reason of 'Existing Opportunity' or something similar.

With the above being said, I know that companies don't always fit into the preferred or standard definitions of the sales process that is provided to us out of the box. In this case, you can meet the business requirement in a few ways.

You can create a custom relationship between the lead and Opportunity form, and then place a lookup on the lead to the Opportunity table. This would allow users to essentially define an existing Opportunity that the lead is related to prior to closing. This helps preserve reporting based on your situation, but the lead process would remain as-is when you click on qualify or disqualify

You can customize the lead qualification process with a custom page. You could use this page to include an Opportunity search option, and the value selected by the user can then be updated on the form/table itself. (Design a custom page for your model-driven app - Power Apps | Microsoft Learn)

With both of the above approaches, the new relationship could then also allow you to place a subgrid on the Opportunity table to show all of the related leads to the Opportunity.

At the end of the day, something like this is doable but it requires straying outside of the standard processes. I might recommend making sure you have a strong business case and understanding of what a lead truly is in your organization, and if it makes sense to have and work a lead that is in actuality further down the sales funnel already.

Hope this helped, and good luck on the requirement!

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

#2

ManoVerse 58 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans