Upload attachments from MS Forms to Azure DevOps Board work item

[shsharma14]

Hi

I have an MS form where the user has to upload a file in one of the questions. 

I was able to create a flow that generates a work item when the form is submitted.

But how do I get the attachments as well from forms into the work item?

I know the attachments get stored in one drive and we can get contents from one drive and then send a HTTP request to Azure DevOps but I am confused about the flow.

Can anyone please help me with the steps?

[v-bofeng-msft · Accepted solution]

Hi @shsharma14 ,

You could this way to get the file content:

Best Regards,

Bof

[KelvinRHC]

Hi @v-bofeng-msft I am trying to replicate your advice above in my own flow however I'm not seeing the same Field 'id' as yourself. I copied your expression into the 'Get file content' and I also tried looking up an 'id' field however the only available one which appeared for me in the list objects was 'Response Id'. Can you tell me where I'm going wrong here?

Many thanks,

Kelvin

[ersanbil]

this is not a good answer even its marked as solution.

please provide step-by-step flow details, this solution provides only how to get necessary file parameters from one drive, after that there is no mention to post is as azure devops attachments and relate it with the created workitem.

i'd be glad if anyone provides an end-to-end solution for this.

thanks

[Rachy_2023]

Did we get a solution for this?

[KelvinRHC]

This 100% was never resolved. I was pretty clear on that based on my responses and I never marked it as resolved myself. Are there any admins watching this page who know how to mark it as "not resolved"?

[KelvinRHC]

Nope never resolved (not even close). Someone marked it as resolved even though I never accepted the solution and I'm not able to change that status.

[Sanna2499]

Hi,

Has anyone found a solution to this problem?

I am also trying to upload MS Forms attachments to the Azure DevOps work item.

[Ratheeshvenu]

I am also trying to upload MS Forms attachments to the Azure DevOps work item but no luck yet. The below flow works and can get all the fields but except the attachment. Any suggestions?

[lupompei]

Same here. Need to solve how to include the attachments in Azure DevOps from Forms. I have tried the Send an Http request action, however my power user has no access to the one drive. I could not test if works. 

[NiclasWJ]

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 @ersanbil @Ratheeshvenu @shsharma14 @KelvinRHC 

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']}"
}
}
}
]