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

Posted on by 2,645

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,323 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 2,645 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 2,645 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,323 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 2,645 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,323 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 2,645 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,323 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans