Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

how to create a Task when a file is uploaded to contacts sharepoint?

Posted on by 775

Hello, we are wanting to create a Task whenever we upload a document to a Contact's sharepoint folder. I'm thinking we will use power automate. The Task will have a link to the sharepoint document in a URL field. Does anyone have a break down of the specifics of going about this? Thank you very much in advance. 

  • Ben T Profile Picture
    Ben T 775 on at
    RE: how to create a Task when a file is uploaded to contacts sharepoint?

    Thank you! This was exactly what we needed - incredibly helpful

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to create a Task when a file is uploaded to contacts sharepoint?

    Hi Ben T,

    If you use the Default Site to upload file, you can get it form folder path/file link/full path. However, it isn't GUID format and you need to convert it to GUID.

    For example, in my case, I can get it by this expression: substring(split(triggerOutputs()?['body/{Path}'],'_')[1],0,sub(length(split(triggerOutputs()?['body/{Path}'],'_')[1]),1))

    pastedimage1655434347533v1.png

    Result:

    pastedimage1655434377695v2.png

    Then you can convert it to GUID, please refer to this blog:

    community.dynamics.com/.../power-automate-convert-a-string-to-guid

  • Ben T Profile Picture
    Ben T 775 on at
    RE: how to create a Task when a file is uploaded to contacts sharepoint?

    Steve,

    Thank you for your response. Sorry I did not mention this in the OP, but we would need the task associated with the contact whose Sharepoint folder we are adding a document to. I am thinking it may be more practical to simply update a URL field on the contact with the file URL. I am wondering how I can get the Contact ID so I can update the contact form with the "link to time." Do you have any thoughts on this? This would be a hugely helpful thing if we can do it.

    pastedimage1655408526485v1.png

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to create a Task when a file is uploaded to contacts sharepoint?

    Hi Ben T,

    Please try the following flow:

    pastedimage1655286599101v1.png

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans