Using the new "Upload Attachment" in Microsoft Forms

[RPNZ]

The ability to add an Attachment to a Microsoft Form has hit my tenant - really exciting. I want to be able to attach the uploaded file in an email flow or at least the URL to the target location.

I tested adding the uploaded file in a flow but rather than the attachment I get a file with the following data:

[{"name":"FILE_NAME","link":"https://MYDOMAIN/personal/myaccount/Documents/Apps/Microsoft%20Forms/FORM_NAME/Question/PICTURE_UPLOADED.jpg","id":"BLAHBLAHBLAH","type":null,"size":YADAYADA,"referenceId":"BLAHBLAHBLAH","driveId":"BLAHBLAHBLAH","status":1,"uploadSessionUrl":null}]

-How can I strip this file back to the URL alone or include the actual attachment?

[ScottShearer]

@RPNZ 

Please post a screen shot of your Flow - that will make it much easier to assist.

What do you want to do with the attachment?  Add it to a library? Add it as an attachment to a SharePoint list?  You need to save it somewhere.

[RPNZ · Accepted solution]

Hi Scott, photo of this part of flow attached

This flow is used to create a new computer user so has a couple of approval steps but ends with an email being created and sent to the helpdesk inbox for action. That step below:

User Photo is the question in the Form used for uploading attachment.

Ideally I would like to have the uploaded attachment inserted as an attachment in the email sent to the helpdesk for processing.

[ScottShearer]

@RPNZ 

Unfortunately I can't use this feature as yet so I can't provide screen shots.  However, I do see two potential issues with your Flow.

First, you need to include a file extension with the file name.  I suspect there is a Dynamic property that will give you file name with extension.  In addition, I suspect that you'll see a property that is something like "User Photo Content" - use that for the file content.

As I said, this is not available to me yet but try what I am suggesting.

[RPNZ]

Thanks Scott, I checked again but the only option I have for Dynamic Content insertion is (in my case) the field User Photo

I did try filename.JPG initially but as mentioned, the file itself contains ONLY the data in my initial post, so no image or even just the direct URL itself. I also tried suffix of URL but still no go.

I realise this is early days for this functionality still so will check back from time to time.

[yashag2255 · Accepted solution]

Hi @RPNZ 

If you are still hitting a dead end with this, I just published a blog that helps you understand how to access the uploaded files. You can follow it here: 

https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[RPNZ]

That's brilliant, worked for me (just note for anyone else, READ THE INSTRUCTIONS CAREFULLY)

[Anonymous]

This may also help - https://www.youtube.com/watch?v=IDW3ikTHu9U

[Tosyn_88]

Hi @yashag2255 

You are the bizneez boss 🙂

I wanted to ask if your solution works for multiple attachments.

Say, for example, i want the user to attach 5 documents to the form which is then added to a SharePoint list

Can you give a small tip as to how?

Thank you

[dsiman]

Hi,

This just hit my tenant today and we're pretty excited. 

Question, how do I identify the attachments that were uploaded on the Form back to the Form Response ID so that we can track the lifecyle of the response.

Thanks!

[yashag2255]

Hi @Tosyn_88 

I have updated my blog post that can help you with multiple attachments: 

https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[yashag2255]

Hi @dsiman 

Can you share more details? One thing you can do is add a metadata column to the document library if you are creating new files in SP or OneDrive with the uploaded files and then store the response ID over there to later track the files. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

@yashag2255I have attempted to follow your blog post but I do not get the append output to be able to use in my dynamic content. 

My Form is a Group Form posting the attachments into a folder within SharePoint - I want to then add the attachments into a document library list as an attachment. So slightly different scenario to emailing them, not sure if that makes a difference. 

[Anonymous]

Hello Yash, 

I am using your method but my flow is giving me an error that the item is not found even when the file is existing in the OneDrive.  Please let me know what you think. 

Thanks,

Vaibhav

 

[yashag2255]

Hi @Anonymous 

It should work more or less the same way. However, here is a post I published that might help you out in case of group forms. 

https://www.bythedevs.com/post/working-with-files-on-ms-forms-group-form-in-ms-power-automate 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[yashag2255]

Hey @Anonymous 

Can you check if you are using a group form?

If so, you can follow this one: https://www.bythedevs.com/post/working-with-files-on-ms-forms-group-form-in-ms-power-automate

Also, you might want to navigate to the individual file that is uploaded to verify that the path is created appropriately. I have this video published here that might help in step by step implementation: https://www.youtube.com/watch?v=Xxad-kSLQ9Y&t=354s. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Hello Yash, 

Thanks for your reply. The video is really great and very helpful. I designed my flow following your steps.

What I did wrong was- the path. The text that I copied from a code line had '%20' for all the spaces in the path of the folder. 

Thanks,

Vaibhav

[Tosyn_88]

The solution is fantastic Yash! @yashag2255 

One last question and do not feel pressured to answer.

Do you have any idea how to have the attachment added to a SharePoint list item?

[yashag2255]

Hey @Tosyn_88 

So we cannot pass an array for sharepoint attachments and so will have to create individually. In the place of the append to array variable action, you can add the attachment option to add each file individually as an attachment. 

So something like: get response details-> create item -> parse json -> apply to each -> create attachment.

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Hey Yash, 

Thanks for your guidance & links shared. 

I also have a group form with attachments going to a sharepoint site, but there are multiple different questions with attachments. Before moving it to a group form, I used the same Parse step and didn't need to specify a path, which worked fine. Is there a way of consolidating all of the upload template inputs from the form into a single sharepoint path? 

(nb: there are no circumstances where more than one upload template question is completed)

Thanks!