Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 2zmFMB43phJktl7v+k+Gsq
Power Automate - General Discussion
Answered

SharePoint List to ADO Work Item

Like (0) ShareShare
ReportReport
Posted on 3 Sep 2019 02:15:51 by 15

Hi Everyone,

 

We have a SharePoint (SP) list where users create/modify items and ALWAYS attach a file within the list. Below is what I'm trying to achieve:

 

  • When a SP List Item is Created or Modified, Create or Modify a Work Item (Task) on Azure DevOps (ADO)

AND 

  • Attach the List Item Attachment File to that same Work Item (Task) on ADO ... OR.... Save the Attachment File in the ADO Repository and Link it with the related Work Item (Task)

 

Please help! Thank you in advance.

  • mbhammad Profile Picture
    15 on 09 Sep 2019 at 01:55:24
    Re: SharePoint List to ADO Work Item

    Neat! Thank you so much @v-litu-msft ...

  • Verified answer
    v-litu-msft Profile Picture
    on 09 Sep 2019 at 01:41:51
    Re: SharePoint List to ADO Work Item

    Hi @mbhammad,

     

    Yes, you can use the Get Work item details action instead of Create a new item action, then put the Dynamic content of Get work item details into these previous steps.Annotation 2019-09-09 094004.png

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mbhammad Profile Picture
    15 on 08 Sep 2019 at 00:51:32
    Re: SharePoint List to ADO Work Item

    Thank You @v-litu-msft .. It works great for new items.. But when an item is modified on SP, it creates a "New" work item on Azure DevOps (ADO).. Can it update the same/existing work item and attachment on ADO?

     

    Many thanks for your help.

  • Verified answer
    v-litu-msft Profile Picture
    on 04 Sep 2019 at 02:42:20
    Re: SharePoint List to ADO Work Item

    Hi @mbhammad,

     

    You could refer to the following steps to create the work item of DevOps according to the created or modified items in the SharePoint, then add the attachments into it.

     

    This is the whole steps:

    Annotation 2019-09-04 102740.pngThese are key steps that you need to notice is send the HTTP request to create the Attachment.

    - Upload Attachment

    Full documentation for this endpoint can be found here: https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/attachments/create?view=azure-devops-rest...

    Annotation 2019-09-04 102813.png

    - Parse JSON

    {
     "type": "object",
     "properties": {
     "id": {
     "type": "string"
     },
     "url": {
     "type": "string"
     }
     }
    }

    - Relate Attachment

    Full documentation for this call can be found here:

    https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/work%20items/update?view=azure-devops-rest-5.0
    Annotation 2019-09-04 102844.png

    This is a simplified step, a lot of details have been omitted, the specific source is from @if you want to know more, you can click on this blog:

    https://blog.mattweston365.com/2019/06/uploading-attachments-from-sharepoint.html

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
ankit_singhal Profile Picture

ankit_singhal 5 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 4 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 2 Super User 2025 Season 1

Overall leaderboard