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
    Community Member Microsoft Employee 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
    Community Member Microsoft Employee 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
    a33ik 84,325 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans