Working with multiple file upload questions for Microsoft Forms

[SofiaNelson]

I've searched many different sites/forums but can't seem to find instruction how to build a flow for multiple file upload questions, that ones responses are submitted attachments from all the upload questions would go into new item list on sharepoint, or new folder is created to place all those attachment for that single new responds. 

For example I have 3 questions in the form that asks to upload multiple files. So I need to be able to create a flow that when person responds to either all 3 of those questions or just two one of those questions, all the files will go into new list item or new folder is created at sharepoint where all those attachments are stored.

Please help!

[efialttes · Accepted solution]

Hi!

GReat stuff here, from one of our all-time top three contributors!

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

Hope his helps

[Jay-Encodian · Accepted solution]

Hey @SofiaNelson @efialttes 

This may also be of interest - https://blog.encodian.com/2020/04/handling-files-provided-in-a-microsoft-forms-response/

Some extra bits on how to convert the files to dataUri's for inclusion in html 🙂

HTH

Jay

[SofiaNelson]

Thank you for responds. I've seen that one. But that article for single questions with multiple attachments to send an email.

I need help with multiple questions where each has multiple attachment and to be able to add to new sharepoint item or in a new folder at sharepoint.

For example I have 3 questions in the form that asks to upload multiple files. So I need to be able to create a flow that when person responds to either all 3 of those questions or just two one of those questions, all the files will go into new list item or new folder is created at sharepoint where all those attachments are stored.

[SofiaNelson]

Thanks for responds. You know how do I then handle if I have multiple questions with multiple file upload? To be able to save all the files into new folder at sharepoint?

[Jay-Encodian]

@SofiaNelson the blog I linked to covers handling multiple files and adding them to SharePoint... you'd just repeat the logic for each question which could return one or more files.

https://blog.encodian.com/2020/04/handling-files-provided-in-a-microsoft-forms-response/

HTH

Jay

[efialttes]

@SofiaNelson 

An example of how to handle multiple questions each of them allowing multiple attachments... but then attaching all of them to an email.

Not exactly what you are looking for, but here you are just in case

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-file-information-from-MS-Form-s-quot-F...

https://powerusers.microsoft.com/t5/Building-Flows/Send-multiple-attachments-from-multiple-forms-que...

Hope this helps

[v-bacao-msft · Accepted solution]

Hi @SofiaNelson ,

You could add a parallel branch to handle the attachments included in these questions separately:

Please take a try and feel free to let us know if you have any other questions.

Best Regards,

[SofiaNelson]

Thank you for responds.

I actually tried parallel, 2 questions in parallel worked, but when adding third parallel for 3rd question it wouldn't work. 

[SofiaNelson]

I finally made it work. had to put a condition under first 2 questions and another condition for the 3rd question.