Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

How to update notes with the Blob url using power automate or through code

Posted on by

Hi,

I need to create notes in CRM online and attachments to azureblob.

I am able to achieve this using power automate, but unable to update the blob url back to the Notes. 

I should update the Notes entity only, as it is used in the Portal.

When i delete the notes, attachment is not deleted from the azure blob.

I cannot use the Attachment Management solution as , i need to Migrate the attachments from the Sharepoint files to DCRM.

Thanks

  • Yao Du Profile Picture
    Yao Du on at
    RE: How to update notes with the Blob url using power automate or through code

    Sorry I am not familar with Portal, share one doc here:docs.microsoft.com/.../configure-notes

  • sulochana1 Profile Picture
    sulochana1 on at
    RE: How to update notes with the Blob url using power automate or through code

    We can add it to description field but, in portal description field will not be visible, need to fetch the data using odata query and need to manipulate the url...which will make the page slow

  • Yao Du Profile Picture
    Yao Du on at
    RE: How to update notes with the Blob url using power automate or through code

    Could we add it to 'Description' field?

  • sulochana1 Profile Picture
    sulochana1 on at
    RE: How to update notes with the Blob url using power automate or through code

    Note entity will not be customizable.. we cannot create any fields.

  • Suggested answer
    Yao Du Profile Picture
    Yao Du on at
    RE: How to update notes with the Blob url using power automate or through code

    I think you should

    1. create a new field called 'Blob Url' under your Entity: Notes(Activity).

    2. Customise(show) the field in your Portal page

    3. Update your Web url to 'Blob Url' in Power Automate

    Reference: crmbook.powerobjects.com/.../

  • sulochana1 Profile Picture
    sulochana1 on at
    RE: How to update notes with the Blob url using power automate or through code

    Hi Dan you,

    Thanks for you resonse.

    I have tried the way you have suggested and got the WEb url also..

    but to which field should i map the weburl in the NOTES entity of the CRM, so that is downloadable from the portal.

    Should we update any flag, so that attachments is retrieved from the blob?

    Please help.

    pastedimage1602144648770v1.png

    Thanks in advance

  • Verified answer
    Yao Du Profile Picture
    Yao Du on at
    RE: How to update notes with the Blob url using power automate or through code

    If your trigger is when Notes in CRM was created,

    Could you please try to  ‘Create SAS URI by Path’ action

    pastedimage1602141842483v1.png

    Then, save web Url and update to your Notes records

    More details see in  www.freefall365.com/.../automating-my-batch-transcription-flow-using-azure-blob-connector-in-power-automate

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans