Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

(0) ShareShare
ReportReport
Posted on by

How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record?

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    That's a bit complicated. I would say build SSIS package that will do that for you.

  • USA80 Profile Picture
    USA80 on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    Actually one more thing - if I want to run this workflow on already existing opportunities, how can I grab the latest note and populate the field correctly?  Right now when I tried to update the existing opportunities, it is grabbing the first one that was ever made, not the last one.

  • USA80 Profile Picture
    USA80 on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    That did the trick, thank you.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    That is weird. I have never seen that before. It was a usual thing in email to case scenario (usual pain in the back) but with the notes... Check this - meganvwalker.com/.../ but you will have to install additional workflow toolkit.

  • USA80 Profile Picture
    USA80 on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    So I created a real-time workflow that when a Note is created it grabs the note description and puts that into my new field.  However, it is showing the html tags.  How can I remove that tags?  The Notes description field is just a multi line text field and that is the same as my new field.  So I am not sure why the tags are showing.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    Hello,

    You can cover "Create" scenario with the simple workflow that will react on "Create" of annotation, check if it is a text and not annotation, check regarding and if it is opportunity - just update the field with the content. But with the "Delete" one it becomes more challenging.

    I would recommend to use plugin for that so you will be able to "sync" that value.

  • USA80 Profile Picture
    USA80 on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    When the note is created and then if the note is deleted I need the workflow or something to look at the next note in line and grab that description.

  • a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: How to copy the latest note from the Opportunity Timeline and bring that into a new field on the Opportunity record

    Hello,

    Do you want to do that on-demand or automatically when the note is created?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans