04-20-2023 23:34 PM - last edited 04-20-2023 23:45 PM
Hello everyone,
This video is a step-by-step tutorial on how to leverage Power Automate flows to save Microsoft Forms Responses along with the attachments (multiple file uploads) to SharePoint Lists, SharePoint Document Libraries, SharePoint Folders & Send Email with Forms responses and attachments.
I will also show where Microsoft Forms Attachments are saved. We will leverage Power Automate to query the saved Forms attachments which would either be in OneDrive for Business or SharePoint depending upon whether it is a Personal Microsoft Form or a Group Microsoft Form.
This Power Automate Tutorial Video covers the following:
✅ Create Microsoft Forms with File Upload
✅ Save MS Forms Response & Attachments to SharePoint List
✅ Save MS Forms Attachments to Document Library
✅ Save MS Forms Attachments to Folders
✅ Send Group Forms Attachments & Response in Outlook Email
⬇️ To download the Microsoft Forms, flows and JSON Formatting sample for SharePoint List showcased in the video: https://github.com/rdorrani/Microsoft-Flow/tree/master/MicrosoftForms
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
watch?v=K-hiDOPAG-4
Hi Reza,
Many thanks for your video, I follow your video and create a MS form with multiple upload files (one of them is mandatory, and one is not mandatory requirement)
I want to attach those files to the email to get approval. and it shows the below error
"The 'inputs.parameters' of workflow operation 'Send_email_with_options_2' of type 'OpenApiConnectionWebhook' is not valid. Error details: The API operation 'SendMailWithOptions' is missing required property 'optionsEmailSubscription/Message/Attachments/0/ContentBytes'."
Hi Rezza,
This has been a really useful video to watch - thank you. It was really easy to understand and do it myself.
Quick question...On my Microsoft form it is not required to attached any documents. So how would I put in a condition that it would only attach documents for those forms whihc people actually attached a document? Otherwise it is going to fail when there is nothing attached.
I am sure it is putting a condition before the apply to each.
Hi @RezaDorrani
You are amazing 😀
I have a question here, I am planning to build my MS form & store it in Share Point, but in the middle I need to send that form for an approvals of 3 departments.
Could you draw the flow for that?
thank you
Sorry the above should have read "cover files or photos generated from 1 or 2 questions"
Hi Reza,
I have been watching and attempting to use your procedure for saving form responses and multiple attachments to a SharePoint list and have had moderate success except, yours and every other tutorial I have found only cover questions generated from 1 or 2 questions. I have a form that asks users to upload photographs they take while using the form (it is an inspection checklist), so there are 7 separate photos being taken along with the responses to the other questions in the form. Is there a way of adding all the photos to the SharePoint list using the flow you have designed?
I use the Set Variable action for the first photo taken (which is required) and then Conditions for the remaining photos which may or may not be included.
Would really appreciate your assistance if you are able to help.