Upload an attachment from MS forms to Azure Devops

[lupompei]

Hello 

I have checked que topics in the community but I was not able to conclude what I need. I have a form - simple one, to request help for operation situations - and sometimes, an attachment is needed. Can be a png, xls, doc. 

I want to include the attachment in the work item Im sending to the support. So, the flow I have right now is just:

When a new response is submitted

Get response details

Create a work item

Questions: how do I get the attachment and how do I upload in the work item?

Thank you

[David_MA]

This is something I have been wanting to do as well, but have not tried yet. According to ChatGPT, you can use the Other Fields option in the action to attach a file to the work item. In the Other Fields option, you would send it a JSON object with the corresponding values. It says to use this for attachments:

{
  "attachments": [
    {
      "op": "add",
      "path": "/fields/System.History",
      "value": "<p>Attached file: [filename]</p>",
      "resource": {
        "fileName": "[filename]",
        "fileContent": "[base64-encoded file content]"
      }
    }
  ]
}

It also says, replace [filename] with the desired file name and [base64-encoded file content] with the base64-encoded content of the file you want to attach. Note that the fileName property within the resource object should also match the file name.

In the above example, the file attachment is added to the work item's System.History field. You can modify the path property to specify a different field for the attachment if needed.

To use this JSON object in Power Automate, you can include it as part of the "Other Fields" value within the "Create work item" action. Specify the "Other Fields" value as the JSON object described above, and the file will be attached to the work item during creation.

Remember to encode the file content as base64 before including it in the JSON object. You can use appropriate methods or actions in Power Automate to convert the file content to base64 format before assigning it to the fileContent property.

Keep in mind that there may be limitations on file size and attachment capabilities in Azure DevOps. Make sure to review and comply with the Azure DevOps documentation regarding attachments and any restrictions that may apply.

[NiclasWJ · Accepted solution]

EDIT:
Below only worked if an attachment was actually uploaded but failed if no upload was made.
To fix this, we add a condition based on length on the actual form output that we are using and put the "Parse JSON" and "For Each Attachment" within that "If yes".

The condition should be " "0" is not equal to "length(body('Get_response_details')?['the_form_question'])" "

Hi @lupompei & @David_MA 

Recently I managed to get this working and since I do not see this "solution" elsewhere in the community I thought of posting it.
This solution adds ALL attachments for me.

I am no Power Automate veteran so have that in mind, and sorry in advance for the mix of Swedish and English in the samples below.

Explanation:

1. "Parse the JSON" with the question including the upload attachment from the MS Forms "Get Response Details"

Scheme:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": "string"
            },
            "link": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

2. "For Each" I then:

3. "OneDrive for Business - Get File Content by Path" where the content is the path such as apps/Microsoft Forms/{form name}/{question}/@{items('For_Each_Attachment')['name']} - This to get the content of all files as Base64, Name is from the first Parse JSON

4. "Compose" with the expression below - This is to retrieve only the Base64 content from the Get File Content which contains other information as well.

outputs('Get_File_Content_by_Path')?['body/$content']

5. "Send a HTTP request to Azure DevOps - Send Attachment to DevOps" with:

POST

URL = {project}/_apis/wit/attachments?filename=@{items('For_Each_Attachment')['name']}&api-version=7.1

Content-Type = application/octet-stream

Body = Output of "Compose"

Set body as Base64

This is to send the attachment into DevOps, this does not link it to any workitem. Name is from the first Parse JSON.

6. "Parse JSON" with the output from "Send Attachment to DevOps" as content and the following scheme:

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

This is so we can know what the URL is of the attachment we want to attach later on.

7. "Send a HTTP request to Azure DevOps - Add attachment" with:

PATCH

URL = {project}/_apis/wit/workitems/@{outputs('Create_change_request')?['body/id']}/?api-version=7.2-preview

@{outputs('Create_change_request')?['body/id']} is the ID of your workitem which is created before in the flow

Content-Type = application/json-patch+json

Body = ( url = "url" from lst Parse JSON ) ( name = name from first Parse JSON )

[
{
"op": "add",
"path": "/relations/-",
"value":
{
"rel": "AttachedFile",
"url": "@{body('Parsa_JSON_2')?['url']}",
"attributes": 
{
"comment": "Automatic attachment upload",
"name":"@{items('For_Each_Attachment')['name']}"
}
}
}
]

[lupompei]

hi , thanks. I will try to implement here and check if works for me. Really appreciate

[nvelissaris]

Thanks for sharing @NiclasWJ - worked like a charm!

I used the SharePoint Get file content using Path as I am using a Form that is stored under a Group/Team.