Microsoft Forms Attachments to User Story in Azure Devops Projects

[mmorley]

Hi,

I have created a flow to obtain details from a form which then creates a user story on our AD Project Board, a lot of users have asked if they could attach files to the form and these get added to the story.

I can find details online on how to add to a sharepoint list or to an email for forwarding, but can't find anything to add to a user story.

Does anyone know if this can be done or will be available in a future update or must we continue to complete form without attachments, send email back to end user with the id and then get them to send us the attachments that need to be added to the user story and we do it manually.

Ideally I want all this process automated to ensure nothing gets missed.

Thanks

[v-litu-msft]

Hi @mmorley,

It's unfortunate that there is no action that could add the file to a user story via Flow.

So your desire that makes it automatically couldn't satisfied. if you like this feature and want it could be added in Flow in the future, you could head to IDEA forum to submit your idea, collect votes to collect more support:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

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.

[mmorley · Accepted solution]

thanks,

I've logged the request but in the meantime I have used the option of adding them to a sharepoint list, which is not ideal but works, just now need to get the hyperlink into the work item (i can add the link but does not show up as a hyperlink)

[Anonymous]

I haven't figured it out yet, but I feel like the approach taken in solving the email attachment to Azure Devops issue a couple weeks ago has to be applicable.

https://powerusers.microsoft.com/t5/General-Power-Automate/Adding-the-attachments-to-Azure-DevOps-wo...

[Anonymous]

Finally figured this out by adapting this recently solved approach from email attachments to Azure Devops. I'll readily admit I did a lot of copy pasting and a little bit from here and there, so there may be room for improvement in this process, as I don't consider myself a Power Automate expert by any means.

First get the submitted form and responses, then create a work item in Devops

 Next parse the JSON response using this template

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

removing the space from the filename and getting the ContentBytes of the attachment

replace(items('Apply_to_each')['name'],' ','-')

Add the file to the ticket

binary(body('Get_file_content_using_path')['$content'])

 Forms adds the submitters name to the end of the file URL, so I wanted to parse out the space in the filename

replace(outputs('Compose')['url'],'%20','-')

 

And here's the files uploaded from the Form

 

 

[nvelissaris]

Thanks for the above solution. I followed your steps @Anonymous and managed to upload the attachment to my Work Item. However, when I try to preview it (it is a jpeg) nothing comes up. When I try to download it and open it, I get a "it seems we do not support these types of files". Any ideas? I am not an expert but heavily experimenting with Power Automation! Thanks in advance!

[nvelissaris]

And one more question please @Anonymous - on the 'Append to array variable' step, you use in "ContentBytes" the $Content from the SharePoint. I can only see "File Content" from my list in the Dynamic Content. Am I doing something wrong? Thanks!

[Anonymous]

@nvelissarisThis is what it's set for in my flow. I'm not sure if it changed or I changed it sometime in the interim(it's been a long time since I mucked with this). Hopefully that works for you.

[PoppyB]

Did you figure this out? I'm hitting the same issue with the file type. Tried a jpeg and xlsx. 

Thanks 

[nvelissaris]

Hello @PoppyB 

I did a mix and match of the above and my flow looks like this...(the first two steps not showing here are: when a response is submitted and (2) Get response details from a Form

 Hope that helps

[Lig]

I feel like I'm so close to making this work, but I get "Unable to parse Base64 encoded bytes." from the last step.  

[rglezmcr85]

@Anonymous thanks for this idea, I am currently working on making work but I am not clear about this step. the one that gets the file content using path. How does this work if we are not using Sharepoint, the file actually comes from a MS Forms. Thanks

[Lig]

I ended up giving up on this and instead just linking to the file from the link tab instead of adding it as an attachment.  Not perfect, but better than  everything we'd had before.  Thanks for this help!

[Lig]

I'm no expert on this, but MS Forms puts files into Sharepoint whether you like it or not and you have to hunt down the location of them for that step.

[nvelissaris]

As far as I am aware, Forms is using a folder to store all the items that are uploaded via it.

[rglezmcr85]

Thanks... and how do you extract the files form the folder in order to send them to Devops? Indeed Forms adds the files to OneDrive folder.

[rglezmcr85]

Its an oneDrive folder actually but I couldnt find the way to read the files and send them to DevOps

[nvelissaris]

It really depends first of all where your configuration saves the file (OneDrive or SharePoint Folder)? If it is SharePoint then you get the file as you show on your screenshot. 

Then in my case, I needed to Append the file to an array

Then you create a Send request as it has been described on this post, using POST. 

You then use Compose...

And finally you Send another HTTP Request using PATCH now.

In the body, I used the following:

Hope it helps 😏

[rglezmcr85]

Thanks @nvelissaris . Your input helped me to complement the original post and I am pretty close to make it work. Here is what I did, hopefully you can help me figuring out what am I doing wrong! 

High Level Flow

The HTTP Request

The binary content: "binary(body('Get_file_content')['$content'])"

and the Final HTTP

However I am getting the following error in the last HTTP Request:

Linking to a work item requires the full url

[nvelissaris]

Check your Compose. Mine looks like

And the POST Body/Binary like the below:

Also, I used API Version 6.0 (not 5.0)