Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

Update Opportunity with Data from Opportunity Close

(0) ShareShare
ReportReport
Posted on by 5

Hello, 

I have a requirement where I need to update the Opportunity with data from the Opportunity Close form. Is there a way to do this without code? I tried to create a workflow that would pull data from the Opportunity Close and populate it on the Opportunity, but I was not able to select Opportunity Close or Activity as a trigger entity. 

Thanks!

  • Community Member Profile Picture
    on at
    RE: Update Opportunity with Data from Opportunity Close

    Hi ras13j ,

    Have any updates?

    Could you click 'Yes' to close the thread if my answer is helpful?

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Update Opportunity with Data from Opportunity Close

    Hi ras13j,

    Yes, You can't use opportunity close entity in the workflow, which is by-design.

    But you can find it in the power automate, so you can create one flow to achieve your goal:

    1.Go Power Automate to create one automated flow:

    pastedimage1664777270440v5.png

    2.Trigger--when a row is added:

    pastedimage1664777031580v3.png

    3.Add one action--Update a row:

    pastedimage1664777207880v4.png

    Test:

    pastedimage1664776974534v1.png

    Refresh current form:

    pastedimage1664777008912v2.png

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at
    RE: Update Opportunity with Data from Opportunity Close

    Hello,

    My recommendation would be to use Power Automate for this purpose. The algorithm should be the following:

    1. Create a Power Automate that handles onchange of "State" field.

    2. Check if the state is "Won"/"Lost".

    3. Query the latest "Opportunity Close" record.

    4. Update the opportunity using the data from "Opportunity Close" record.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,430 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,043 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans