Azure DevOps to SharePoint – automated integration for storing documents

Do you have the need to store links to SharePoint documents from Azure DevOps for an easier collaboration? Unfortunately, to make this work you have to manually create your SharePoint folder and then reference it in your DevOps items.

What about having an automated integration that will:

  1. Create the SharePoint folder for you.
  2. Store the folder and the URL under a field in Azure DevOps so that you can quickly reference it for any other documents.

I this article, I am showing you how to accomplish that automation, including a cloud flow that you re-create in your organization to make this work.

Decide where in DevOps you want to store the URL to SharePoint.

In my scenario, I usually create a new field that I call “Documents”. I then add that field into the DevOps items where I want my SharePoint integration to work.

Here is how to add a custom field to a work item in DevOps.

Create the cloud flow.

1. You can remove the “Type” if you want to trigger the flow on the creation of any item in DevOps.

2 & 3. Define a folder structure, in my exemple I am using the “Item ID” and “Item Title” as part of the folder name.

4. Update the DevOps item.

5. Set the Work Item Type. If your triggered your cloud flow to create folders on different Item types, you will need to create separate action to update each one separately.

6. Set the custom field you create using “Custom.[field name]”. You can find the field name if you edit your field and click on “Options”.

7. Add an HTML sintax that will let you open the SharePoint folder as a link.